Sr Analytics Engineer

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

Alpharetta, GA

Full time

R0002061

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.

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.