Sr. Business Intelligence Analyst
Job description
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.
Description copied from Mathematica's careers page. Read the full posting before you apply.
More jobs at Mathematica
Researcher, Data Strategy and Analytics (Remote Eligible)
Mathematica· Cambridge, MA, United StatesHuman Services Research Analyst (Quantitative Research)
Mathematica· Cambridge, MA, United StatesResearcher, Performance Measurement and Technical Assistance (Remote Eligible)
Mathematica· Cambridge, MA, United StatesQuantitative Researcher, Human Services (Remote Eligible)
Mathematica· Ann Arbor, MI, United StatesProject Manager, Human Services Policy (Remote Eligible)
Mathematica· Ann Arbor, MI, United States
More jobs in Princeton
WorkPlace Operations Manager
K2services-wd503-opensity· USA-Princeton-NJ· $115k – $125kManager Financial Planning and Analysis
Abbott Laboratories· Princeton, New Jersey, United States· $99kFine Dining Server/Bartender
Medical Diagnostic Laboratories· Princeton, NJ, United StatesCertified Surgical Technologist
United Surgical Partners International· Princeton, New Jersey, United States· $77k – $168kMedical Writer
SystImmune· Princeton, NJ· $80k – $130k