BI Architect

Vytwo; Dallas (TX); Hybrid; USD 120,000 - 150,000; Full time

Benefits offered by this job

Flexible work from home options

Job summary

Vytwo is seeking an experienced BI Architect to design and implement scalable Business Intelligence solutions. Located in Iselin, NJ, with hybrid work options, the ideal candidate will have over 15 years of experience in BI, strong proficiency in Power BI, SQL, and data warehousing, alongside excellent communication skills. Responsibilities include working with stakeholders to gather requirements, developing dashboards, and mentoring junior staff. The role also supports flexible remote work arrangements.

Qualifications

• 15+ years of experience in BI and managing large report migrations.
• Strong analytical, problem-solving abilities, and stakeholder management.

Responsibilities

• Designing, developing, and implementing BI solutions.
• Collaborating with cross-functional teams for requirement gathering.
• Mentoring junior BI developers and analysts.

Skills

Power BI

SQL

Data warehousing

DAX

Cognos

ETL tools

Data modeling

Tools

Tableau

Azure

AWS

Google 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.
• 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.

Flexible work from home options available.