Senior BI Developer

Aligned Automation Services Pvt Ltd | Contract

Concord, United States | Posted on 05/06/2026

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.

• 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.

• 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.

• 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, Git Hub 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.

• 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.

• 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.

• 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.
• 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…