Senior BI Engineer: Power BI & Data Pipeline Expert

Mathematica, Inc.; Washington (District of Columbia); On-site; USD 105,000 - 135,000; Full time

Job summary

Mathematica is seeking a Sr. Business Intelligence Analyst to design and deliver scalable BI solutions using Power BI and Tableau, with strong data engineering and cloud capabilities.

The ideal candidate is a hands‑on senior engineer who can independently solve complex data and BI challenges while providing technical leadership to project teams. In addition to 7–10 years of BI experience, you will advance data modeling, ETL/ELT pipelines, and collaboration with clients and cross‑functional teams

Qualifications

• 7-10 years of experience developing production BI, analytics, data engineering, or related data solutions.
• Strong hands-on experience with Power BI and/or Tableau, with advanced proficiency in at least one and ability to independently develop, deploy, and support complex BI solutions.
• Advanced SQL and relational database skills, including complex queries, transformations, and performance optimization.
• Experience designing dimensional models, star/snowflake schemas, semantic models, data marts, and aggregation strategies for BI and analytics.
• Hands-on experience building and troubleshooting ETL/ELT production processes and data pipelines across multiple data sources.

Responsibilities

• Design, develop, and maintain enterprise BI and analytics solutions using Power BI and Tableau, translating business requirements into scalable, intuitive, production-ready products.
• Design supporting data models and data marts, including dimensional models, star/snowflake schemas, semantic models, and aggregation strategies optimized for analytics and reporting.
• Build and maintain production data pipelines and ETL/ELT processes using SQL and, where appropriate, Python, .NET, AWS-native services, Snowflake, or Databricks.
• Optimize end-to-end BI performance, identifying and resolving bottlenecks across dashboards, semantic models, queries, data models, pipelines, databases/warehouses, and cloud infrastructure.
• Apply software engineering and DevOps practices, including version control where supported, testing and data validation, CI/CD and deployment automation where applicable, release management, monitoring, and production support.
• Lead technical design and architecture discussions, prototypes, proofs of concept, and architecture reviews, ensuring solutions meet scalability, security, accessibility, maintainability, data quality, and cost requirements.
• Collaborate with clients and cross-functional teams to translate complex business and analytical needs into effective BI, data engineering, and data modeling solutions.
• Provide technical leadership and mentorship through code, dashboard, and data model reviews; establish development standards and best practices; and guide teams through complex technical challenges.
• Troubleshoot complex production issues across the BI and data stack, identify root causes, and implement solutions that improve reliability and performance.
• Support project planning and technical solutioning by estimating effort, identifying risks and dependencies, evaluating technologies, and contributing to proposals and implementation approaches.

Skills

Power BI

Tableau

SQL

Data modeling

Python

ETL/ELT

AWS

CI/CD

Tools

Snowflake

Databricks

Looker

Qlik

Cognos

Job description

Mathematica is seeking a Sr. Business Intelligence Analyst to design and deliver scalable BI solutions using Power BI and Tableau, with strong data engineering and cloud capabilities.

The ideal candidate is a hands‑on senior engineer who can independently solve complex data and BI challenges while providing technical leadership to project teams. In addition to 7–10 years of BI experience, you will advance data modeling, ETL/ELT pipelines, and collaboration with clients and cross‑functional teams