Senior BI Developer

Job Description
Role Overview

We are urgently seeking a Senior Business Intelligence (BI) Developer to join our team onsite at our Concord, USA facility. This is a 100%-dedicated, immediate-hire position supporting the Concord site's local data and BI deliverables. The ideal candidate will design, develop, and maintain enterprise-grade Power BI dashboards, Databricks Lakehouse solutions, and AI-powered self-service analytics within a GMP-regulated manufacturing and pharmaceutical environment.

The role requires a strong command of Azure data services, SQL, DAX, Power Query (M), and emerging AI/ML tools (Claude, Copilot, Databricks Genie). You will be the primary BI technical resource for the Concord site, working directly with local SMEs and cross-functional stakeholders to drive data-driven decision-making and digital transformation.

Key Responsibilities

Power BI Report & Dashboard Development
•Design, build, and maintain Power BI reports and dashboards aligned to enterprise BI standards and GMP compliance requirements.
•Create and replicate GMP (Good Manufacturing Practices) reports from other sites; develop non-GMP reports for local Concord site-specific needs.
•Implement DAX measures, calculated tables, and row-level security (RLS); optimize report performance and data refresh cycles.
•Apply Power Query (M) transformations and advanced data modeling techniques (star schema, composite models) for scalable analytics.

Databricks Lakehouse & Data Engineering
•Develop and maintain staging, refined, and analytical data layers within the Databricks Lakehouse architecture (Unity Catalog).
•Write and optimize complex SQL queries, CTEs, window functions, views, and stored procedures on Databricks SQL and Azure SQL Server.
•Troubleshoot and resolve connectivity issues across Power BI, Databricks, Denodo, and SQL Server environments.
•Create and maintain stored procedures, functions, tables, views, triggers, jobs, and data backups.

AI-Powered & Self-Service Analytics
•Design, build, and maintain Databricks Genie agents and natural-language query spaces for end-user self-service analytics.
•Curate semantic models, example queries, and business glossaries to ensure accurate, governed AI responses.
•Leverage AI-powered development tools (Claude, GitHub Copilot, Databricks AI features) to accelerate SQL optimization, report development, and data profiling.
•Evaluate emerging AI/ML capabilities relevant to BI and manufacturing analytics; support configuration of NLQ interfaces for business users.
•Develop and deploy AI applications integrated with Azure ecosystem; experience with MCP connectors and Agentic AI Architecture preferred.

Data Integration & ETL
•Design, develop, and implement Data Integration (DI) processes to extract, transform, and load data from diverse sources for analytical needs.
•Leverage Azure Data Factory (ADF) and Azure Databricks pipelines for end-to-end ETL orchestration.
•Ensure data quality, lineage, and governance compliance within Azure Data Lake and Databricks Unity Catalog.

GMP Documentation & Validation
•Create test protocols, test scripts, and other validation deliverables per GMP regulatory requirements.
•Provide comprehensive documentation for reports, dashboards, data models, and custom solutions.
•Maintain audit-ready documentation in compliance with pharma/manufacturing quality standards.

Stakeholder Support & Knowledge Transfer
•Provide technical support to local Concord end users on BI reports and dashboards.
•Conduct knowledge-transfer sessions; create user guides and training materials for non-technical stakeholders.
•Collaborate with local SMEs to ensure DI and BI deliverables meet site-specific business requirements.

Key Deliverables
•Enterprise Power BI dashboards (GMP & non-GMP) deployed and adopted by Concord site users.
•Databricks Lakehouse data layers (staging, refined, analytical) operational and optimized.
•Databricks Genie self-service analytics spaces with curated semantic models and business glossaries.
•AI-powered BI workflows integrated with Azure ecosystem (Claude, Copilot, Genie).
•ETL/DI pipelines via Azure Data Factory fully documented and running in production.
•GMP test protocols, validation scripts, and audit-ready documentation.
•User guides, training materials, and knowledge-transfer sessions delivered to local SMEs.

Requirements

Must-Have Hard Skills

Power BI (DAX, Power Query/M, Data Modeling)

AI Tools: Claude API, GitHub Copilot, Databricks AI

Azure Databricks & Databricks SQL (Unity Catalog)

Python (scripting, data manipulation)

Advanced SQL (CTEs, Window Functions, Stored Procedures)

Data Modeling (Star Schema, Composite Models)

Azure Data Factory (ADF) - ETL/ELT Pipelines

Power BI Row-Level Security (RLS) & Governance

Azure SQL Database / SQL Server

Azure Data Lake Storage (ADLS Gen2)

Databricks Genie / Natural Language Query (NLQ)

GMP Documentation & Validation Protocols

Must-Have Soft Skills

Strong analytical & problem-solving mindset

Ability to translate complex data into actionable businessinsights

Clear written & verbal communication with non-technicalstakeholders

Collaborative mindset with cross-functional teams

Self-starter - able to work independently onsite with minimalsupervision

Attention to detail (critical in GMP-regulated environment)

Stakeholder management & requirements gathering

Time management & ability to prioritize multipledeliverables

Good-to-Have Hard Skills

MCP Connectors & Agentic AI Architecture

Azure DevOps / CI-CD for BI assets

Azure Cosmos DB

Lakehouse Medallion Architecture design

Flask Application Development

Manufacturing / Pharmaceutical domain knowledge

Prompt Engineering for LLM-based applications

Experience with Fabric / Microsoft OneLake

AI app deployment on Azure (App Service, ACI, AKS)

PySpark / Spark SQL

Denodo (Data Virtualization Platform)

SSRS, SSAS, or other legacy BI platforms

Good-to-Have Soft Skills

Experience in regulated (GMP/FDA) manufacturing environments

Experience conducting formal training / KT sessions

Ability to mentor and coach junior BI developers

Comfortable presenting findings to senior leadership

Proactive mindset - identifies gaps and proposes solutions

Adaptability to evolving AI/ML tool landscape