Data Engineer
Job Description
Copeland is hiring a Data Engineer in St. Louis, MO (onsite) to help build and operate scalable enterprise data pipelines and transformations. In this role, you will leverage Snowflake and modern ETL/ELT tooling, partnering with stakeholders to turn business needs into reliable data solutions. You will also play an active part in production support through monitoring, CI/CD, and incident management, helping keep data platforms performing at an enterprise standard.
Responsibilities
- Develop and maintain scalable data pipelines, data integrations, and data transformation solutions across enterprise platforms.
- Write code to transfer, transform, and curate data from multiple source systems.
- Design and optimize data models, data marts, and analytical datasets for reporting, analytics, and operational use.
- Maintain deep technical knowledge of Snowflake, cloud data platforms, ETL/ELT frameworks, and dbt.
- Ensure data systems are efficient, scalable, reliable, and maintainable.
- Follow software development lifecycle standards, coding standards, source control practices, and deployment processes.
- Collaborate with key stakeholders to understand functional and technical requirements and translate them into data engineering solutions.
- Recommend approaches that simplify design and reduce overall solution complexity.
- Develop and execute test plans to support successful deployments and data accuracy.
- Communicate expectations, risks, dependencies, delivery timelines, and operational issues to leadership and stakeholders.
- Support production operations, including monitoring, incident management, troubleshooting, and root cause analysis (RCA) with corrective actions.
- Support ServiceNow incident, request, problem, and change management processes.
- Develop and maintain CI/CD pipelines, deployment automation, and operational runbooks.
- Implement monitoring, alerting, observability, and platform health dashboards.
- Support platform governance, security controls, access management, and audit activities.
- Identify opportunities for performance improvement, automation, and cost optimization.
Requirements
- Bachelor’s Degree in Computer Science, Information Technology, or equivalent.
- Minimum 4-7 years of experience in Data Engineering and related technologies.
- Strong experience with SQL, Python, data modeling, and data warehousing concepts.
- Experience with Snowflake, Oracle, SQL platforms, and cloud-based data ecosystems.
- Experience building and supporting batch and real-time data pipelines.
- Experience with dbt, ETL/ELT frameworks, APIs, and data integration technologies.
- Experience with Git, CI/CD tools, DevOps practices, and deployment automation.
- Experience implementing monitoring, observability, and operational support processes.
- Understanding of platform governance, security controls, access management, and audit requirements.
- Demonstrated ability to isolate and resolve complex technical and operational issues.
Technologies
Snowflake, Oracle, SQL, Python, dbt, ETL/ELT frameworks, APIs, data integration technologies, Git, CI/CD tools, DevOps practices, ServiceNow, CI/CD pipelines, monitoring, alerting, observability
Benefits
- Medical insurance plans
- Dental and vision coverage
- 401(k)
- Flexible time off plans
- Paid parental leave
- Vacation and holiday leave
Preferred Skills
- Professional communication and technical documentation skills.
- Strong analytical and problem-solving capabilities.
- Ability to lead problem-solving teams and technical discussions.
- Ability to resolve conflict efficiently and influence stakeholders.
- Strong ownership mindset and operational accountability.
- Ability to manage multiple cross-functional initiatives simultaneously.
- Continuous improvement mindset focused on automation and operational excellence.
Work Authorization
Copeland will only employ those who are legally authorized to work in the United States. This is not a position for which sponsorship will be provided. Individuals with temporary visas such as E, F-1 with OPT or CPT, H-1, H-2, L-1, B, J or TN, or who need sponsorship for work authorization now or in the future, are not eligible for hire.
Equal Opportunity Employer
Copeland is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to sex, race, color, religion, national origin, age, marital status, political affiliation, sexual orientation, gender identity, genetic information, disability or protected veteran status. Committed to providing a workplace free of any discrimination or harassment.