Senior Power BI / Microsoft Fabric Developer (867 - 1)

MetAntz; Santa Clara (CA); On-site; USD 130,000 - 180,000; Full time

Job summary

MetAntz in Santa Clara, CA is seeking a Data Scientist – Tools Developer to gather requirements and build Power BI reports, semantic models, and scalable data pipelines.

The role emphasizes hands-on data modeling, SQL, Fabric, and Databricks, with collaboration across stakeholders to deliver production-grade dashboards on time.

Qualifications

• Extensive experience with Power BI Desktop and service.
• Strong skills in DAX, Power Query, and semantic modeling.
• Advanced SQL and query optimization capabilities.
• Hands-on with Microsoft Fabric platforms and Databricks.
• Experience designing scalable dimensional data models.
• Ability to connect Power BI to Databricks and SQL warehouses.
• Knowledge of data security, governance, and access controls.
• Excellent analytical, documentation, and stakeholder communication.
• Ability to deliver production-ready solutions independently.

Responsibilities

• Gather reporting requirements and translate into dashboards and visuals.
• Design, develop, test, deploy, and maintain Power BI reports and models.
• Create data models, calculations, and KPIs using DAX.
• Use Power Query and SQL to prepare data for reporting.
• Integrate Power BI with Fabric and Databricks data sources.
• Optimize performance of reports, queries, and semantic models.
• Implement data security including workspace permissions and row-level security.
• Document report logic, data sources, and refresh processes.
• Collaborate with stakeholders, data engineers, and platform teams to resolve issues.

Skills

Power BI Desktop & Service

DAX

Power Query

Semantic modeling

SQL

Microsoft Fabric

Databricks

Data security & governance

Stakeholder communication

Documentation & troubleshooting

Tools

Power BI

Fabric

Databricks

Lakehouse / Warehouse

OneLake

Data Factory

Dataflows Gen2

Databricks SQL warehouses

AWS services (S3, Redshift)

Job description

• Gather reporting requirements and translate them into effective dashboards, reports, and data visualizations.
• Design, develop, test, deploy, and maintain Power BI reports and semantic models.
• Create efficient data models, relationships, calculations, and KPIs using DAX.
• Use Power Query and SQL to transform, validate, and prepare data for reporting.
• Integrate Power BI with Microsoft Fabric and Databricks data sources.
• Optimize report, query, refresh, and semantic-model performance.
• Implement appropriate data security, including workspace permissions and row-level security.
• Document report logic, data sources, calculations, refresh processes, and operational procedures.
• Collaborate with business stakeholders, data engineers, and platform teams to resolve data-quality and reporting issues.

Data Scientist - Tools Developer

Key Responsibilities

• Gather reporting requirements and translate them into effective dashboards, reports, and data visualizations.
• Design, develop, test, deploy, and maintain Power BI reports and semantic models.
• Create efficient data models, relationships, calculations, and KPIs using DAX.
• Use Power Query and SQL to transform, validate, and prepare data for reporting.
• Integrate Power BI with Microsoft Fabric and Databricks data sources.
• Optimize report, query, refresh, and semantic-model performance.
• Implement appropriate data security, including workspace permissions and row-level security.
• Document report logic, data sources, calculations, refresh processes, and operational procedures.
• Collaborate with business stakeholders, data engineers, and platform teams to resolve data-quality and reporting issues.

Required Skills And Experience

• Expert-level experience with Power BI Desktop and the Power BI service.
• Advanced proficiency in DAX, Power Query, semantic modeling, and report design.
• Advanced SQL skills, including complex queries, joins, aggregations, common table expressions, and performance optimization.
• Strong hands-on experience with Microsoft Fabric, including Lakehouse or Warehouse, OneLake, Data Factory pipelines, Dataflows Gen2, and semantic models.
• Experience designing scalable dimensional or star-schema data models.
• Experience connecting Power BI to Databricks, including Databricks SQL warehouses.
• Knowledge of data security, governance, access controls, and secure authentication practices.
• Strong analytical, troubleshooting, documentation, and stakeholder-communication skills.
• Ability to work independently and deliver production-quality solutions within agreed timelines.

Preferred Qualifications

• Experience with AWS data and analytics services, particularly Amazon S3, IAM, AWS Glue, and Amazon Redshift.
• Experience working with cloud-based lakehouse or data-platform architectures.
• Familiarity with deployment pipelines, source control, release management, and automated testing.
• Relevant Microsoft Power BI or Fabric certifications.
• Previous experience delivering enterprise reporting solutions in a contractor or consulting capacity.