Job Description
*Role is onsite in Tucker, GA 5-days a week*
*Role is 12-month contract*
Position Summary/responsibilities: 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.
Required Qualifications / skills:
- 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.
Plusses:
- 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.
*role can pay 60-65/hr based on YoE*
Job Tags
Contract work