Senior BI Architect — Power BI/Tableau (Remote)

Mathematica

United States

Remote

USD 105,000 - 135,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Mathematica is seeking an experienced Senior BI Analyst to design and deliver scalable BI and data solutions. You will leverage Power BI and Tableau with SQL-driven data pipelines, data modeling, and cloud services to build dashboards, reports, and semantic models.

The role emphasizes technical leadership, mentorship, and collaboration with clients and cross-functional teams. Remote-eligible in the United States with a focus on scalable analytics, secure architectures, and production-quality

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.

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
Dimensional modeling
ETL/ELT
AWS
Data engineering
Technical leadership

Tools

Snowflake
Databricks
Looker
Qlik
Cognos
Tableau Server

Job description

Mathematica is seeking an experienced Senior BI Analyst to design and deliver scalable BI and data solutions. You will leverage Power BI and Tableau with SQL-driven data pipelines, data modeling, and cloud services to build dashboards, reports, and semantic models.

The role emphasizes technical leadership, mentorship, and collaboration with clients and cross-functional teams. Remote-eligible in the United States with a focus on scalable analytics, secure architectures, and production-quality

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior BI Engineer & Data Solutions Lead
Senior BI Engineer & Data Solutions Lead

Mathematica, Inc. • Princeton (NJ)

On-site
USD 105,000 - 135,000
Senior BI Engineer: Power BI & Data Pipeline Expert
Senior BI Engineer: Power BI & Data Pipeline Expert

Mathematica, Inc. • Washington

On-site
USD 105,000 - 135,000
Senior Power BI Architect - Remote Data Visualization
Senior Power BI Architect - Remote Data Visualization

FormativGroup • Oregon

Hybrid
USD 41,000 - 55,000
Remote Senior Power BI Architect
Remote Senior Power BI Architect

FormativGroup • Nashville (TN)

Remote
USD 41,000 - 55,000
Senior BI & Reporting Analyst—Tableau/Power BI (Remote)
Senior BI & Reporting Analyst—Tableau/Power BI (Remote)

INSPYR Solutions • New York (NY)

Remote
USD 61,992 - 72,324
Comprehensive medical benefits
Competitive pay
401(k) retirement plan
Senior Power BI Architect - Remote
Senior Power BI Architect - Remote

Cooperdyne Tech • United States

Remote
USD 100,000 - 170,000
Competitive salary
Comprehensive health benefits
Paid time off
+2
Senior Power BI Architect (Remote) – Analytics & Data Modeling
Senior Power BI Architect (Remote) – Analytics & Data Modeling

Dentive • United States

Remote
USD 100,000 - 115,000
Senior BI Analyst, Strategy & Analytics - Remote
Senior BI Analyst, Strategy & Analytics - Remote

Partner Company • United States

Remote
USD 110,000 - 140,000
Remote work in approved states
Relocation assistance
High visibility to senior leadership
+1
Senior Power BI Architect — Remote & Data-Driven
Senior Power BI Architect — Remote & Data-Driven

FormativGroup • Saint Paul (MN)

Remote
USD 41,000 - 55,000
Remote Senior Power BI Lead & Analytics Architect
Remote Senior Power BI Lead & Analytics Architect

FormativGroup • Kentucky

Remote
USD 90,000 - 130,000
Medical
Dental
Vision
+1