- Current Openings
- Veterans Program
- Working With Indotronix
- Referral Program
All current openings
Lead ETL Developer
- Location: Columbus, Ohio 43219
- Work model: On-site
- Posted 6 days ago
- Job ID: JPC - 211226
Easy ApplyApply Now
Job Description
Job Summary: Lead ETL Developer - Enterprise Data Warehouse (EDW)
Location: Columbus, OH (Remote flexibility) | Contract to Hire
About the Role
Apex Systems is hiring a Lead ETL Developer to drive the design, development, and performance optimization of enterprise-grade data pipelines within our modern cloud-based EDW. As a technical leader, you will spearhead solution delivery, mentor developers, and shape the data engineering strategy leveraging AWS, Snowflake, and Python frameworks. This is a high-impact opportunity to influence best practices, support modernization, and elevate data as a true strategic asset.
Responsibilities
- Lead the end-to-end design, development, and maintenance of scalable ETL/ELT pipelines in AWS and Snowflake environments
- Translate business requirements and data mapping documents into robust, reusable technical solutions
- Build and optimize data pipelines leveraging AWS Glue, Snowflake, Python/PySpark, and IBM DataStage
- Implement metadata-driven, performance-optimized data integration patterns
- Enforce coding standards, version control, and CI/CD best practices
- Define and execute comprehensive data quality, testing, and validation strategies
- Collaborate with product owners, architects, and cross-functional teams to deliver end-to-end data solutions
- Support production operations, incident triage, and root cause analysis for critical data flows
- Mentor and guide junior and mid-level developers to elevate team capability and enforce best practices
- Contribute to ongoing modernization efforts, including cloud migration, automation, and Snowflake optimization
- Stay current on emerging data technologies, tools, and industry trends
Required Skills and Experience
- Bachelor's degree or 9+ years of relevant experience
- 5+ years in ETL/data engineering within enterprise data warehouse settings
- Advanced SQL and database development skills
- 5+ years hands-on experience with Python/PySpark and ETL tools
- 3+ years working with cloud-based data platforms (AWS, Snowflake)
- Demonstrated technical leadership and ability to drive best practices
Preferred Skills
- Strong knowledge of data warehousing concepts, data modeling, and SDLC methodologies
- Experience leading development teams or acting as a technical lead on large-scale data projects
- Proficiency with AWS services (Glue, S3, EC2) and Snowflake architecture optimization
- Familiarity with data pipeline observability, monitoring, and automated testing frameworks
- Experience with CI/CD, DevOps practices, and version control systems
- Understanding of data governance, security, and regulatory requirements in financial services
- AWS Certifications (Solutions Architect, DevOps Engineer)
- Prior experience in banking or financial services industry
Benefits
- Career growth with opportunities for technical leadership and strategy influence
- Exposure to modern cloud technologies and innovative data architectures
- Collaborative, high-performing team environment with a focus on mentorship
- Contract-to-hire path for long-term career advancement
- Flexible work arrangements (remote options available)
How to Apply
Ready to take the lead in shaping the future of enterprise data engineering? Submit your resume and a brief cover letter highlighting your relevant experience and technical leadership achievements. Qualified candidates authorized to work in the U.S. are encouraged to apply.
Easy ApplyApply Now
Interested in this role?
Easy ApplyApply Now
Job details
Job ID JPC - 211226
Location Columbus, Ohio, United States
Work Model On-site
Job Type Contract to Hire
Posted October 13, 2026
Skills AWS Snowflake and Python-based frameworks
Share this job
*