Data Engineer II

Data Engineer II

Join our growing team and see why Summit Utilities, Inc was named as one of the fastest growing Denver area private companies 2019 and 2020; best places to work in Maine 2019, 2020, 2021, 2022 and 2023; and best places to work in Arkansas 2020 and 2023, Oklahoma 2022 and 2023 and Missouri 2023. Summit was also recently named one of Forbes 2023 America's Best Small Employers.

Summit is a growing natural gas utility providing safe, reliable, and clean burning natural gas service to homes and businesses in Arkansas, Colorado, Maine, Missouri, Oklahoma, and Texas. Being part of the Summit team means embracing excellence and innovation, committing to safety each and every day, and doing all that we can to serve each other, our customers, and the communities where we live. We aim to bring warmth and energy to everything we do.

We have an exciting hybrid opportunity for a Data Engineer II based in Fort Smith, Arkansas.

Position Summary

Summit Utilities is seeking a Data Engineer II to design, develop, and optimize enterprise-grade data pipelines and integration workflows across hybrid environments. Engineers at this level are expected to work independently on complex data solutions that involve structured and semi-structured data across multiple systems. This role is essential to delivering scalable, cost-efficient, and reliable data infrastructure that supports reporting, analytics, and operational needs across the business. Ideal candidates bring a preferred 3–8 years of experience, strong technical problem-solving skills, and a deep understanding of data orchestration, transformation, and integration within modern data environments.

Primary Duties And Responsibilities

• Design and implement end-to-end data pipelines that extract, transform, and load data across a variety of enterprise systems.
• Optimize existing pipelines for performance, cost efficiency (CU usage), and reliability within cloud environments.
• Develop and maintain scalable transformation logic for structured and semi-structured data (e.g., CSV, JSON, XML)
• Implement error handling, alerting, and retry mechanisms in pipelines to ensure system robustness and uptime.
• Collaborate with Data Analysts and SAP Analysts to translate functional requirements into technical designs and extraction logic.
• Support integration with third-party systems via APIs, FTP/SFTP, or service connectors.
• Contribute to source control and CI/CD workflows.
• Perform data quality checks, build reconciliation logic, and ensure pipeline health through automated logging and monitoring.
• Participate in data platform design discussions, providing input on storage models, partitioning strategies, and pipeline orchestration.
• Participate in team standups, sprint planning, and code reviews to contribute to project delivery.
• Document pipeline architecture, business logic, and metadata dependencies to support maintainability and cross-team understanding.
• Troubleshoot complex data pipeline issues and provide advanced support for system failures and data integrity concerns.

Education And Work Experience

• Bachelor's degree in computer science, Information Systems, Engineering, or a related field preferred; equivalent combination of education and relevant experience will be considered.
• 3–8 years of experience in data engineering, software development, or ETL/integration roles preferred
• Proven experience designing and maintaining pipelines using cloud based equivalent tools.
• Hands-on experience developing with scripts for data movement, transformation, and automation.
• Strong experience working with relational databases, including query optimization and scripting.
• Demonstrated experience working in a cloud environment and integrating data from multiple enterprise systems.
• Familiarity with source control practices and CI/CD workflows

Knowledge, Skills, Abilities

• Strong proficiency with cloud services
• Skilled in writing and maintaining custom data processing scripts.
• Deep understanding of SQL, including complex joins, CTEs, performance tuning, and stored procedure development.
• Familiarity with SAP data structures and integrating SAP data into enterprise pipelines.
• Experience designing resilient data workflows with built-in validation, retries, and alerting.
• Knowledge cloud architecture, and data transformation/staging strategies
• Solid grasp of API integrations, flat file ingestion (CSV, JSON, XML), and secure data movement via FTP/SFTP
• Ability to work independently and lead portions of project development from planning through deployment.
• Strong documentation habits and ability to communicate technical logic to teammates and stakeholders.
• Proficiency with source control tools and collaborative development practices
• Analytical mindset with a focus on system reliability, scalability, and maintainability
• Friendly, solution-oriented team player aligned with Summit's PEAKS values.

The above statements are intended to describe the general nature and level of work being performed by employees assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties and/or skills required of all personnel so classified.

Summit offers competitive pay and medical/dental/vision and other benefits that provide flexibility, choice and support to our employees when they need it most. We understand that home and family are essential pieces of your life, and our benefits are designed to support you both at work and at home.

Summit Utilities, Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or protected veteran status and will not be discriminated against on the basis of disability or veteran status.