BI Architect

Vytwo Technologies Inc.; Prosper (TX); Hybrid; USD 140,000 - 190,000; Full time

Benefits offered by this job

Flexible work from home

Job summary

Vytwo Technologies Inc. is seeking a BI Architect in a hybrid Iselin, NJ environment. You will design, develop, and implement scalable BI solutions using Power BI, Tableau, and modern data platforms, partnering with stakeholders to translate business needs into actionable insights.

The role requires 15+ years of BI experience, strong SQL and data warehousing skills, and Cognos proficiency, with a focus on capital markets and risk data understanding.

Qualifications

• Power BI, DAX, and Paginated Reports in enterprise BI environments.
• 15+ years in BI/data architecture with large report migrations.
• Cognos experience is mandatory.
• Capital Markets domain knowledge and risk data understanding.

Responsibilities

• Design, develop, and implement scalable end-to-end BI solutions.
• Build semantic models, dashboards, and reports for decisions.
• Create and maintain data models, ETL pipelines, and data warehouses.
• Governance, security, and collaboration with stakeholders.
• Mentor and lead junior BI developers and analysts.

Skills

Power BI

Paginated Reports

DAX

SQL

Data warehousing

Cognos

Capital Markets

Tools

Talend

Informatica

SQL Server

PostgreSQL

Oracle

Azure

AWS

BigQuery

Job description

Role : BI Architect

Location : Iselin, NJ (Hybrid) / Local candidates only

Indent : PSL-US211278_1-46-1

Rate: Depends on Experience

Must have:

• Strong Power BI, Paginated Reports, Dax, Strong in SQL and data warehousing.
• At least 15 years’ experience and managing large report migrations.
• Must have : Cognos

Should have Capital Markets experience and understanding of trading, risk data.

Role Overview

The BI Architect is responsible for designing, developing, and implementing scalable and efficient Business Intelligence (BI) solutions using tools like Power BI, Tableau, and modern data platforms. This role involves working closely with stakeholders to understand business needs and translating them into actionable data insights and visualizations.

Key Responsibilities

• Core BI Architecture & Development
• Design and implement end-to-end BI solutions using Tableau and Power BI.
• Develop semantic models, dashboards, and reports to support business decision-making.
• Create and maintain data models, ETL pipelines, and data warehouses.
• Collaboration & Governance
• Work with cross-functional teams (finance, sales, operations) to gather requirements.
• Implement data governance, security, and compliance frameworks.
• Mentor junior BI developers and analysts.

Technical Skills

• Power BI: Semantic models, DAX, Paginated Reports, Q&A visual.
• Strong SQL skills and experience with relational databases (SQL Server, PostgreSQL, Oracle).
• Experience with ETL tools (e.g., Talend, Informatica) and data modeling (Star/Snowflake schemas).
• Familiarity with cloud platforms (Azure, AWS, Google BigQuery).
• Bonus: Python or R for data manipulation and AI/ML integration.
• Soft Skills
• Strong analytical and problem-solving abilities.
• Excellent communication and stakeholder management.
• Leadership and mentoring capabilities (for senior roles).

Preferred Experience

• 10+ years in BI, data analytics, or data architecture roles.
• Proven track record of delivering enterprise-grade BI solutions.
• Experience with DevOps for BI (e.g., Git, ALM Toolkit, Tabular Editor).
• Certifications in Power BI, Tableau, or Microsoft Fabric are a plus 1 2 3.

Flexible work from home options available.