Brooksource · 4 hours ago
Senior Data Engineer - Analytics & BI
Charlotte Metro
Contract
Hybrid
Senior Level
$54/hr - $64/hr
5+ years expBrooksource is searching for an exceptional Senior Data Engineer to join their Fortune 500 Energy & Utilities client in Charlotte, NC. The role involves designing and maintaining data pipelines, supporting business intelligence efforts, and collaborating across multiple domains to deliver impactful data solutions.
EmploymentHuman ResourcesInformation Technology
No H1B
Hiring Manager
Wiley Marsteller
Responsibilities
Design, develop, and maintain scalable data pipelines using Python, Dagster, and modern orchestration tools
Build robust data architectures that support analytics, reporting, and business intelligence needs
Develop ETL/ELT processes to integrate data from multiple source systems into our data warehouse
Optimize data models for performance, reliability, and scalability
Support AWS Redshift namespace migration efforts, including pipeline migration and validation
Collaborate with the Data Engineering Pod to establish and maintain best practices
Design and build advanced Power BI reports and dashboards with a focus on performance and user experience
Develop Power Platform solutions (Power Apps, Power Automate) to enhance self-service analytics and automation
Analyze data to uncover insights, identify trends, and answer complex business questions
Ask probing questions, challenge assumptions, and provide data-driven recommendations
Translate ambiguous business problems into actionable analytical solutions
Present findings and insights to stakeholders through compelling visualizations and storytelling
Work across Billing, Accounts Receivable, Metering, and Customer Engagement domains
Run stakeholder meetings independently—gathering requirements, presenting solutions, and taking detailed notes
Teach and mentor team members on technical concepts, tools, and best practices
Present technical deep dives and training sessions to the team
Participate actively in weekly domain meetings and monthly pod meetings
Collaborate with team members on code reviews, troubleshooting, and problem-solving
Track all work in JIRA with clear tasks, updates, and status reporting
Document code, data pipelines, reports, and processes thoroughly for team continuity
Maintain version control using GitHub with proper branching, commits, and collaboration practices
Deliver projects on time and communicate proactively about progress, blockers, and risks
Contribute to technical documentation, runbooks, and knowledge base articles
Qualification
Required
5+ years of professional experience in data engineering, business intelligence, or analytics
Expert-level SQL skills (complex queries, window functions, CTEs, query optimization, stored procedures)
Python programming for data engineering, automation, and analytics
Data orchestration tools (Dagster strongly preferred; Airflow, Prefect, or similar also acceptable)
AWS experience including S3, Redshift, and cloud data architectures
Power BI development with advanced DAX, data modeling, and performance optimization
GitHub for version control, code collaboration, and repository management
Data pipeline development from source systems to analytics platforms
Strong understanding of data warehousing concepts, dimensional modeling, and ETL/ELT patterns
Proactive and self-driven — you identify problems and solve them without waiting for direction
Exceptional communication skills — perfect English (written and verbal), able to present complex ideas clearly
Highly organized — manages multiple priorities, tracks work meticulously, meets deadlines consistently
Team player — collaborates openly, shares knowledge, and supports teammates
Curious and analytical — loves asking 'why,' digging into data, and uncovering insights
Comfortable with ambiguity — thrives when given complex, open-ended problems to solve
Reliable and dependable — delivers on commitments, even under pressure
Passionate about learning — stays current with new tools, techniques, and industry trends
High energy and positive attitude — brings enthusiasm and motivation to the team
Goes above and beyond — consistently exceeds expectations and takes initiative
Preferred
Power Platform (Power Apps, Power Automate) development experience
Experience with ISU (Industry Solution for Utilities) or utility industry data
AWS Redshift migration or cloud data migration projects
Billing, Accounts Receivable, or Metering domain knowledge
Data quality frameworks and automated validation/testing
CI/CD pipelines for data and BI deployments
dbt (data build tool) for transformation workflows
Company
Brooksource
Brooksource is a single source for project and supplemental support through contract employment, contract-to-hire labor employment.
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
Ashley Cigolotti
Director, Global Partnerships
Matt Ayala
National Account Executive (Global Partnerships)
Recent News
Technically Media
2025-05-27
Technically Media
2025-05-17
2025-05-06
Company data provided by crunchbase