Senior Business Intelligence Developer (Concord)

About the Role:

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.

The Senior BI Developer will serve as the primary local technical resource — enabling local BI adoption, supporting GMP-compliant reporting, and helping the site leverage cutting-edge AI/ML and self-service analytics tools.

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.

Required Skills:

Strong command of Azure data services, SQL, DAX, Power Query (M), and emerging AI/ML tools (Claude, Copilot, Databricks Genie).

Preferred Skills:

Experience with MCP connectors and Agentic AI Architecture preferred.