Senior Business Intelligence Analyst

About Mathematica:

Mathematica applies expertise at the intersection of data, methods, policy, and practice to improve well-being around the world. We collaborate closely with public- and private-sector partners to translate big questions into deep insights that improve programs, refine strategies, and enhance understanding using data science and analytics. Our work yields actionable information to guide decisions in wide-ranging policy areas, from health, education, early childhood, and family support to nutrition, employment, disability, and international development. Mathematica offers our employees competitive salaries, and a comprehensive benefits package, as well as the advantages of being 100 percent employee owned. As an employee stock owner, you will experience financial benefits of ESOP holdings that have increased in tandem with the company’s growth and financial strength. You will also be part of an independent, employee-owned firm that is able to define and further our mission, enhance our quality and accountability, and steadily grow our financial strength. Read more about our benefits here.

Mathematica is looking for an experienced Business Intelligence Analyst to join the Data Solutions team to design and deliver scalable, high-performing business intelligence and data solutions. This role combines deep expertise in Power BI and / or Tableau with strong data engineering, data modeling, and cloud capabilities to build solutions spanning data pipelines and data marts through semantic models, dashboards, reports, and visualizations. 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.

Primary Duties and 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.

Required 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.
• Experience with AWS data solutions, including cloud storage, databases, data integration/processing, security, and scalable architectures.
• Ability to diagnose and optimize performance across the BI and data stack, from dashboards and queries to pipelines and data warehouses.
• Experience with software engineering practices, including version control where supported, testing, CI/CD, release management, deployment, and production support.
• Strong technical leadership, analytical, and communication skills, including leading technical design, mentoring developers, establishing best practices, and collaborating across technical and business teams.

Qualifications:

• Hands-on experience developing data pipelines, transformation frameworks, APIs, utilities, or data processing applications using Python and/or .NET.
• Experience with Snowflake and/or Databricks, including data engineering, transformation, modeling, performance optimization, and analytics workloads.
• Experience with additional BI and analytics platforms such as Looker, Qlik, Cognos, or similar technologies.
• Experience designing and implementing cloud-based data warehouses, lakehouses, data lakes, and analytics platforms.
• Experience with modern data transformation and orchestration frameworks and cloud-native data integration services.
• Experience with data management, metadata, lineage, data governance, and data quality practices.
• Experience working with healthcare or public-sector data, including claims, beneficiaries, provider, enrollment, program, or quality-measurement data.
• Ability to administer Tableau server.

This position offers an anticipated base salary of $105,000- $135,000 annually. This position is eligible for an annual discretionary bonus based on individual and company performance. To apply, please submit cover letter, resume, and code samples via our careers page.

We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.

At Mathematica, we understand the importance of building relationships with colleagues. If you’re not located near one of our offices but would like opportunities to meet up with co-workers, we offer coworking spaces where available. Ask your Talent Acquisition partner for more information about this opportunity and whether it’s an option in your area.

Any offer of employment will be contingent upon passing a background check. Various federal agencies with whom we contract require that staff successfully undergo security clearance as a condition of working on the project. If you are assigned to such a project, you will be required to obtain the requisite security clearance. Additionally, if you participate in/complete the application process and are denied, Mathematica may choose to terminate your employment.

We take pride in our employees and in their commitment to excellence. We encourage staff to collaborate in developing creative solutions to difficult problems and to share the responsibility and enjoyment of carrying out complex projects. This collegial spirit has helped us earn our reputation for innovative and high quality work.