Job Description
This role will be Business Intelligence Program at an Electric Utility company located in the metro-Atlanta area. The selected individual will also work alongside the existing BI team to expand the current data lake, integrate additional high-value data sets, create reusable analytical data models, and develop Power BI dashboards that improve visibility into project, financial, fuel, and operational performance.
• Profile source systems, assess data readiness, define source-to-target mappings, and integrate priority datasets into the current data lake using scalable ingestion and transformation patterns.
• Build, optimize, and monitor data pipelines, refresh processes, and transformation logic to support reliable performance and maintainable data flows.
• Design curated data models and semantic layers that support consistent business definitions, reusable measures, dimensional analysis, and performant reporting.
• Develop executive, management, and operational dashboards for the priority domains, including drill-through capability, trend analysis, KPI scorecards, and role-appropriate views.
• Implement reconciliation checks, validation routines, exception handling, and testing protocols to improve trust in the resulting reports and dashboards.
• Leverage Power Apps and Power Automate where appropriate to streamline data collection, approvals, workflow, or exception management tied to reporting processes.
• Facilitate requirements sessions, translate business needs into technical designs, document solution logic, and provide knowledge transfer to the current BI team and business users.
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 HR@insightglobal.com.To 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/.
Required Skills & Experience
• Eight or more years of experience in business intelligence, analytics, data engineering, or related consulting roles, with a proven record of delivering enterprise reporting solutions from requirements through production.
• Five or more years of hands-on Power BI development experience, including semantic models, DAX, Power Query, dashboard UX design, row-level security, refresh management, and performance tuning.
• Strong SQL skills and demonstrated experience building ETL or ELT processes, integrating disparate data sources into a data lake or warehouse environment, and designing dimensional or analytical data models that support reusable reporting.
• Practical experience with several of the following domains: capital projects, new facility or plant construction, project management, financial/accounting reporting, fuel reporting, operations, or similar asset-intensive business environments.
• Experience defining validation rules, reconciliation checks, metadata, data dictionaries, lineage documentation, and controlled deployment practices that support trusted reporting.
• Working knowledge of Power Apps and Power Automate, plus familiarity with the broader Microsoft BI stack and Databricks used to streamline workflow, improve data collection, or support operational reporting processes.
• Ability to lead discovery sessions, translate business needs into technical designs, communicate effectively with executives and functional teams, prioritize multiple workstreams, and work with minimal supervision.
• Bachelor's degree in information systems, computer science, engineering, finance, accounting, or a related field. Relevant Microsoft, project management, or analytics certifications are strongly preferred.
Nice to Have Skills & Experience
• Experience in utility, energy, generation, construction, or other regulated or asset-intensive operating environments.
• Demonstrated success integrating project controls, ERP, accounting, operational, and performance data into a common analytical model.
• Knowledge of project controls concepts such as budget, forecast, commitments, change orders, milestone management, and schedule performance.
• Experience creating executive scorecards and operational dashboards that combine financial, project, and operational measures in a single reporting experience.
• Ability to mentor analysts, establish reusable BI standards, and leave behind documentation and design patterns that strengthen the internal BI capability.
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.