Sr. Business Intelligence Analyst

Mathematica Inc • Washington, DC

1d • $105,000 - $135,000

About The Position

Mathematica is seeking an experienced Business Intelligence Analyst to join its Data Solutions team and design and deliver scalable, high-performing business intelligence and data solutions. The role combines expertise in Power BI and/or Tableau with data engineering, data modeling, and cloud capabilities to build solutions spanning data pipelines and data marts through semantic models, dashboards, reports, and visualizations. The successful candidate will be a hands-on senior engineer able to independently solve complex data and BI challenges while providing technical leadership to project teams.

The position involves designing and maintaining enterprise BI and analytics solutions, supporting data models and production pipelines, and optimizing performance across the BI and data stack. It also includes technical architecture and design leadership, client and cross-functional collaboration, mentorship, production troubleshooting, and support for project planning and technical solutioning.

The anticipated base salary is $105,000–$135,000 annually. The role is eligible for an annual discretionary bonus based on individual and company performance. Employment offers are contingent on passing a background check; some projects may require security clearance. Mathematica is an independent, 100 percent employee-owned firm. Employees may have opportunities to meet coworkers through coworking spaces where available.

Requirements

• 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 the 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 production ETL/ELT processes and data pipelines across multiple data sources.
• Experience with AWS data solutions, including cloud storage, databases, data integration and 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.

Nice To Haves

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

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 by identifying and resolving bottlenecks across dashboards, semantic models, queries, data models, pipelines, databases or 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.

Benefits

• Competitive salaries and a comprehensive benefits package.
• Employee ownership through ESOP holdings, with financial benefits that have increased in tandem with company growth and financial strength.
• Annual discretionary bonus based on individual and company performance.
• Coworking spaces where available, offering opportunities to meet with coworkers.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed