Senior Power BI Architect – Azure Data & Analytics

Insight Global; Downey (CA); On-site; USD 120,000 - 175,000; Full time

Job summary

Insight Global is seeking an experienced BI Engineer/Developer to design, build, and optimize Power BI reports and dashboards within an Azure-based data environment. You will support ETL, data quality, and data warehouse initiatives, collaborating with data teams and stakeholders to deliver scalable, accurate analytics.

The role emphasizes data modeling, semantic layer development, and performance tuning, with opportunities to contribute across ERP-driven reporting and enterprise systems.

Qualifications

• 5–8+ years of experience in BI/reporting development with Power BI.
• Strong SQL and relational database experience; exposure to non-relational sources.
• Hands-on experience building interactive dashboards and BI semantic models.
• Knowledge of data warehousing, data lakes, and BI concepts.
• Experience with ETL, data transformation, and data integration workflows.
• Ability to analyze data, perform root cause analysis, and resolve data integrity issues.
• Experience with data ingestion pipelines and transformation processes.
• Strong experience with Power BI & data visualization tools and analytics best practices.
• Experience performing testing (UAT) and ensuring data accuracy in reporting.
• Experience with cloud data platforms (Azure required; AWS/GCP exposure acceptable).
• Familiarity with software engineering practices, version control, and multi-OS environments.
• Experience supporting enterprise data warehouse / centralized reporting environments.
• Exposure to ERP-driven reporting environments and enterprise business systems.
• Familiarity with Azure and Azure tools (ADF, Synapse, Fabric, or similar).
• Experience supporting data governance initiatives and data quality standards.
• Background in education, public sector, highly regulated industry, and/or large enterprise ecosystems.

Responsibilities

• Develop and maintain Power BI reports, dashboards, and analytical tools.
• Build and support ETL processes, transformation pipelines, and data ingestion workflows.
• Analyze and troubleshoot data quality and integrity issues; support data warehouse development.
• Create and optimize the presentation layer and reporting performance.
• Assist with data modeling, semantic layer development, and report optimization.
• Support audits, testing cycles, and release processes, including bug fixes and enhancements.
• Partner with functional teams to define security roles and data access controls.
• Provide ongoing production support and troubleshooting for BI tools and reporting systems.
• Recommend process improvements, technical enhancements, and reporting optimizations.

Skills

BI reporting development

SQL

Data analysis

Data modeling

ETL processes

Data warehousing

Data quality testing

Root cause analysis

Dashboard design

Stakeholder collaboration

Testing/UAT

Security/data access controls

Git/version control

Cross-functional collaboration

Tools

Power BI

Azure

Azure Data Factory (ADF)

Azure Synapse

Azure Fabric

Data governance tools

Git

Job description

Insight Global is seeking an experienced BI Engineer/Developer to design, build, and optimize Power BI reports and dashboards within an Azure-based data environment. You will support ETL, data quality, and data warehouse initiatives, collaborating with data teams and stakeholders to deliver scalable, accurate analytics.

The role emphasizes data modeling, semantic layer development, and performance tuning, with opportunities to contribute across ERP-driven reporting and enterprise systems.