Senior BI Engineer & Data Solutions Lead

Mathematica, Inc.; Princeton (NJ); Presencial; USD 105.000 - 135.000; Tempo integral

Resumo da vaga

Mathematica seeks a Sr. Business Intelligence Analyst to join the Data Solutions team. You will design, build, and deliver scalable BI and data solutions using Power BI and Tableau, with strong data modeling and ETL capabilities.

The role offers technical leadership across projects and requires hands-on expertise in cloud data architectures (Snowflake, Databricks) and SQL. You will lead architecture discussions, mentor developers, and collaborate with clients and cross-functional teams to

Qualificações

• 7–10 years developing production BI, analytics, data engineering, or related data solutions.
• Hands-on Power BI and/or Tableau with advanced proficiency to independently develop, deploy, and support complex BI solutions.
• Advanced SQL and relational database skills, including complex queries and performance optimization.
• Experience designing dimensional models, star/snowflake schemas, semantic models, data marts, and aggregation strategies.
• Experience building and troubleshooting ETL/ELT production processes and data pipelines.
• Experience with AWS data solutions including cloud storage, databases, data integration and secure architectures.
• Ability to diagnose and optimize performance across BI stack and data pipelines.
• Experience with software engineering practices: version control, testing, CI/CD, deployment, and production support.
• Strong technical leadership and cross-functional collaboration skills.

Responsabilidades

• Design, develop, and maintain enterprise BI solutions using Power BI and Tableau.
• Create data models and data marts, including dimensional models and semantic schemas.
• Build and maintain production data pipelines and ETL/ELT processes across sources.
• Optimize end-to-end BI performance and resolve bottlenecks.
• Apply DevOps practices, testing, deployment automation, and release management.
• Lead design discussions, prototypes, and architecture reviews for scalable solutions.
• Collaborate with clients and cross-functional teams to translate needs into BI and data models.
• Provide technical mentorship through code and dashboard reviews and set best practices.

Conhecimentos

Power BI

Tableau

SQL

Data modeling

ETL/ELT pipelines

AWS

Python

Team leadership

Communication

Ferramentas

Snowflake

Databricks

Looker

Qlik

Cognos

Tableau Server

Descrição da vaga

Mathematica seeks a Sr. Business Intelligence Analyst to join the Data Solutions team. You will design, build, and deliver scalable BI and data solutions using Power BI and Tableau, with strong data modeling and ETL capabilities.

The role offers technical leadership across projects and requires hands-on expertise in cloud data architectures (Snowflake, Databricks) and SQL. You will lead architecture discussions, mentor developers, and collaborate with clients and cross-functional teams to