Sr. Business Intelligence Analyst

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