Senior Analytics Engineer: DataOps, AI & BI

Colonial Pipeline Company; Alpharetta (GA); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Competitive benefits

Job summary

Colonial Pipeline Company in Alpharetta, Georgia, is seeking a Senior Analytics Engineer to design, build, and deploy data and analytics solutions that drive business outcomes. You will partner with cross-functional teams, develop data models and ETL pipelines, implement CI/CD practices, and create BI visuals using Power BI.

Travel up to 10%. The role requires 5+ years in data modeling/engineering, advanced SQL and Python, and strong communication skills in a fast-paced energy industry

Qualifications

• Bachelor's degree in a related field or equivalent experience.
• 5+ years of experience in data modeling, data engineering, or analytics.
• Advanced SQL and Python skills.
• Strong data modeling, engineering principles, and software engineering practices.
• Experience with CI/CD and maintaining reliable code.
• Strong data visualization and storytelling abilities.
• Experience with Power BI or Power Apps.
• Experience with ETL tools (Alteryx, Azure Data Factory).
• Experience with data from Oracle, SSIS, Azure, and APIs.

Responsibilities

• Identify and resolve efficiency blockers to accelerate the Data Program.
• Build, deploy, and maintain data models and ETL pipelines for analytics and data science.
• Develop analytics products that drive measurable business outcomes.
• Partner with functional teams to translate needs into metrics and documentation.
• Advise business groups on effective data usage and governance.
• Develop BI solutions and data visualizations to support functions.
• Collaborate with Data Science to develop AI and advanced analytics.
• Define enterprise data pipeline and data curation needs with Data Platform.
• Embed a DataOps philosophy into daily work.
• Support emergency response efforts, including training and travel.

Skills

SQL

Python

Data modeling

CI/CD

Data visualization

Communication

Collaboration

Cloud platforms

Machine learning (optional)

Education

Bachelor's degree or equivalent

Tools

Power BI

Power Apps

Alteryx

Azure Data Factory

dbt

Oracle

SSIS

Azure

Job description

Colonial Pipeline Company in Alpharetta, Georgia, is seeking a Senior Analytics Engineer to design, build, and deploy data and analytics solutions that drive business outcomes. You will partner with cross-functional teams, develop data models and ETL pipelines, implement CI/CD practices, and create BI visuals using Power BI.

Travel up to 10%. The role requires 5+ years in data modeling/engineering, advanced SQL and Python, and strong communication skills in a fast-paced energy industry