Sr Analytics Engineer

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 has provided a wide range of opportunities for job candidates who are highly qualified, skilled, motivated and team players. Employees find exciting opportunities to grow and develop their careers at a stable company which offers a generous compensation and benefits package that includes annual incentive bonuses, retirement plans, insurance coverage and a host of other features that support a happy, active, productive and rewarding life. Come to Colonial, a great place to work, where people matter most, and where safety 24/7 is paramount. Ready to work for Colonial Pipeline Company? Are you intrigued by the thought of being part of revolutionizing the energy industry and a new era in the pipeline industry? Do you want to be a part of a company that is obsessed with excellence in everything we do? A company growing and expanding our business that is full of opportunity? If so, we are seeking smart, safety focused, and energetic professionals to join our team to help us to the next level of excellence!

What is it that we do at Colonial Pipeline Company? Colonial Pipeline is the largest refined products pipeline in the United States, transporting more than 100 million gallons or 2.5 million barrels per day. Colonial transports various grades of gasoline, diesel fuel, home heating oil, jet fuel, and fuels for the U.S. military through a pipeline system. Colonial transports approximately 45 percent of all fuel consumed on the East Coast, providing refined products to more than 50 million Americans.

About the Senior Analytics Engineer Position

The Senior Analytics Engineer plays a vital role on the Data Team, designing, developing, and implementing comprehensive data and analytics solutions for stakeholders across Colonial Pipeline Company. Working closely with cross-functional teams, this role helps provide accurate and efficient access to data so teams can make informed decisions, identify opportunities, and solve business problems. The position follows a typical weekday schedule and is based in Alpharetta, Georgia, with travel up to 10% of the time.

What You Get to Do

• 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.

What You Bring to the Table

• 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.

Skills That Set You Apart

• Experience with machine learning and advanced analytics.
• Knowledge of DevSecOps practices.
• Cloud platform experience.
• Experience with dbt, including testing and workflow orchestration.
• Experience with real-time data solutions.

Advantages of Working at Colonial Pipeline Company

• Getting to work for a company that helps to meet our country’s energy needs and keeps us moving!
• Team members who care about each other while accomplishing remarkable things.
• Highly competitive benefits - Check out Colonial’s Total Rewards.

Are you up to the challenge? What are you waiting for?

Colonial Pipeline is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race, color, religion, sex, national origin, age, disability, sexual orientation, veteran status or any other reason prohibited by federal, state or local law.

Statement to all Third-Party Agencies and Similar Organizations: Colonial Pipeline accepts resumes only from agencies with which we formally engage their services. Please do not forward resumes to our applicant tracking system, Colonial Pipeline employees, hiring managers, or send to any Colonial Pipeline facility. Colonial Pipeline is not responsible for any fees or charges associated with unsolicited resumes.

Colonial Pipeline Company operates the world’s largest pipeline of its kind. It delivers refined petroleum products – gasoline, diesel fuel, home heating oil, jet fuel and fuels for the U.S. military – through a network of 5,500 miles of underground pipe buried under more than 3,000 miles of right of way in the Southern and Eastern United States. A vital part of the nation’s infrastructure, Colonial places the highest emphasis on safe operations that protect its employees as well as the communities in which we live and serve, and the environment along the pipeline route.