ETL Developer

$120,000 - $130,000/Yr

OpTech - Frisco, TX

Full-time - Mid Level

Frisco, TX

Religious, Grantmaking, Civic, Professional, and Similar Organizations

About the position

The ETL Developer position at OpTech LLC in Frisco, TX, is a full-time contract role focused on architecting and developing scalable data applications and pipelines. The role requires extensive experience in data engineering, particularly with Informatica and Snowflake, and involves leading a team to deliver technical solutions for complex business problems. The position is primarily onsite, requiring in-person collaboration two days a week.

Responsibilities

• Identify technical solutions for complex business problems and provide recommendations.
• Architect and develop end-to-end scalable data applications and data pipelines.
• Lead the team in assisting with story creation and sprint deliverables.
• Develop automated Informatica data pipelines and ensure data quality and profiling.
• Work with enterprise data warehouse solutions and various databases including Snowflake and AWS technologies.
• Design and implement automated data solutions using Snowflake lakehouse.
• Mentor other technologists and support their development.
• Implement data solutions by improving CICD, change management, and data security processes.

Requirements

• Bachelor's Degree in Computer Science, Engineering, or a related field, or equivalent experience.
• 7 years of experience in technology and data engineering, particularly in developing data applications and pipelines.
• 7 years of experience leading and developing automated Informatica data pipelines, with at least 4 years in Informatica Cloud (IICS).
• 5 years of experience designing and implementing automated data solutions using Snowflake lakehouse.
• 5 years of experience mentoring other technologists.
• 4 years of experience with software engineering best practices across the development lifecycle.

Nice-to-haves

• AWS or Informatica or Snowflake certification is preferred.
• Experience with Dataiku is a plus.

Benefits

• Dental insurance
• Health insurance
• Vision insurance