Senior Analytics Engineer: Lead Data Solutions & AI

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

Job summary

Colonial Pipeline Company in Alpharetta, Georgia seeks a Senior Analytics Engineer to design and implement data and analytics solutions. You will work with cross-functional teams to provide accurate data access and enable informed decisions.

Responsibilities include building ETL pipelines, data models, BI products, and collaborating with Data Governance and Data Science to advance AI and analytics. Travel up to 10%.

Qualifications

• Bachelor’s degree in a related field or equivalent experience.
• Five or more years of experience in data modeling, data engineering, analytics, analytics engineering, or a related area.
• Advanced SQL and Python skills.
• Strong experience with data modeling, data engineering principles, and software engineering best practices.
• Experience with CI/CD practices and developing reliable, maintainable code.
• Strong data visualization and storytelling skills.
• Experience with Power BI, Power Apps, or a similar platform.
• Experience with data validation, automated workflows, testing, and orchestration.
• Experience with ETL tools such as Alteryx or Azure Data Factory.
• Experience working with data from multiple platforms, including Oracle, SSIS, Azure, and APIs.
• Strong written and verbal communication skills, including the ability to clearly explain complex business activities, technical requirements, and recommendations.
• A solutions-oriented mindset and the ability to collaborate effectively with leaders, employees, contractors, consultants, and vendors.

Responsibilities

• Identify and resolve efficiency blockers so that the Data Program can iterate faster.
• Build, deploy, and maintain data models and ETL pipelines for analytics, data science, and other business use cases.
• Develop and maintain analytics products that drive measurable business outcomes.
• Partners with functional teams to identify opportunities, solve business problems, and translate stakeholder needs into technical metrics and documentation.
• Advise business groups on the effective use of data.
• Collaborate with Data Governance to define data quality rules, standards, and metrics.
• Establish software engineering best practices for code used in analytics data products.
• Develop business intelligence solutions and data visualizations that support business functions.
• Partner with Data Science to develop AI, machine learning, and advanced analytics solutions.
• Work with the Data Platform team to define enterprise data pipeline and data curation needs.
• Embed a DataOps philosophy into day-to-day work.
• Support the company’s emergency response efforts when needed, including training, short-term travel, and backfill duties.

Skills

SQL

Python

Data modeling

Data engineering

CI/CD

Power BI

Power Apps

Data visualization

Dataops

Communication

Education

Bachelor’s degree in related field

Tools

Power BI

Power Apps

Alteryx

Azure Data Factory

dbt

Oracle

SSIS

Azure

APIs

Job description

Colonial Pipeline Company in Alpharetta, Georgia seeks a Senior Analytics Engineer to design and implement data and analytics solutions. You will work with cross-functional teams to provide accurate data access and enable informed decisions.

Responsibilities include building ETL pipelines, data models, BI products, and collaborating with Data Governance and Data Science to advance AI and analytics. Travel up to 10%.