Senior Data Engineer: ETL, SQL & Cloud Pipelines

Socket.dev; Covington (KY); On-site; USD 90,000 - 130,000; Full time

Job summary

Socket.dev is seeking a data solutions expert in Covington, KY with 5+ years in technology and 3 years building data systems. You will design, implement, and tune multi-tenant data solutions while working closely with cross-functional teams in a fast-paced environment.

Strong SQL, Python, and ETL/ELT experience are essential, as is QA/testing expertise and familiarity with Agile methods. Knowledge of Snowflake and cloud platforms is a plus, with BI tools like Tableau/PowerBI valued.

Qualifications

• 5+ years in technology with 3 years in developing and deploying data solutions.
• Excellent written and verbal communication skills including documentation.
• Excellent collaboration skills across multiple teams.
• Ability to deal with ambiguity in fast-paced environments.
• Systems analysis with legacy process decomposition and debugging.
• Solid data analysis fundamentals with SQL, Python, and stored procedures.
• Experience writing complex SQL queries and stored procedures.
• QA and testing expertise with solid methodologies.
• Familiarity with Agile frameworks.
• SQL proficiency including MySQL and Snowflake knowledge.
• ETL/ELT experience, Informatica or similar tools a plus.
• Python for ELT pipelines and scripting.
• Data modeling to design multi-tenant data solutions.
• CI/CD tooling experience (Jenkins, Git/GitHub).
• Cloud concepts (Azure or AWS) a plus.
• BI development experience with Tableau/PowerBI a plus.
• DevOps tooling experience.

Tools

SQL

Python

Informatica

Snowflake

Jenkins

Git/GitHub

Job description

Socket.dev is seeking a data solutions expert in Covington, KY with 5+ years in technology and 3 years building data systems. You will design, implement, and tune multi-tenant data solutions while working closely with cross-functional teams in a fast-paced environment.

Strong SQL, Python, and ETL/ELT experience are essential, as is QA/testing expertise and familiarity with Agile methods. Knowledge of Snowflake and cloud platforms is a plus, with BI tools like Tableau/PowerBI valued.