BI Developer/Engineer

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

Job Description

One of the nation’s largest regional education agencies is looking for a BI Engineer/Developer to support the Power BI reporting, enhancements, and ongoing analytics initiatives within a rapidly evolving Azure-based data environment. This role will play a key part in delivering operational and analytical reporting tied to an ERP modernization effort, building out a master data warehouse, and broader data initiatives. The BI Engineer/Developer will focus on delivering and developing high-quality dashboards, analytical reporting, and data insights, while supporting ETL processes, testing, and ongoing enhancements. The developer will work closely with architects, data teams, and business stakeholders to ensure reporting solutions are accurate, scalable, and aligned with business needs.

Core 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, implementing corrective solutionsSupport data warehouse development, including integrating data from enterprise systems
• Create and optimize the presentation layer and reporting performance
• Assist with data modeling, semantic layer development, and report optimization
• Support system 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

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [e-mail] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

Skills and Requirements

• 5–8+ years of experience in BI/reporting development, with strong expertise in Power BI
• Strong experience with SQL and relational databases, with exposure to non-relational data sources
• Hands‑on experience building interactive dashboards, reports, and BI semantic models
• Strong understanding of data warehousing, data lakes, and BI concepts
• Experience with ETL processes, data transformation, and data integration workflows
• Ability to analyze data, perform root cause analysis, and resolve data integrity issues
• Experience supporting data ingestion pipelines and transformation processes
• Strong experience with Power BI & data visualization tools and analytics best practices
• Experience performing testing (UAT), validation, 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