Data Engineer 181872

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

The Expertise and Skills You Bring:

• 5+ years in Technology with 3 years in developing and deploying data solutions


• Excellent written and verbal communication skills including experience writing documentation


• Excellent collaboration skills to work with multiple teams in the organization


• Ability to deal with ambiguity and work in fast paced environment


• Systems analysis background with an emphasis on legacy process decomposition and debugging/tuning/refactoring


• Strong understanding of data analysis concepts and associated tools such as SQL, Python, Stored Procedure, etc.


• Experience building, maintaining, and tuning stored procedures, complex SQL queries.


• QA / Testing – must be highly proficient in QA and testing methodologies/concepts with a demonstratable level of expertise


• Comfortable working within an Agile framework


• Extensive experience with SQL required; knowledge of MySQL, Snowflake preferred


• Hands-on experience with ETL/ELT tools and processes, particularly Informatica, or similar platforms, is a plus.


• Experience with Python for building ELT pipelines or other scripting languages.


• A passion to design and implement single and multi-tenant data solutions using various database design and data modelling techniques.


• Experience with CICD toolset such as Jenkins, Jenkinscore, Udeploy, Git, GitHub.

Any combination of the following is a plus:

• Hands-on experience with either Azure or AWS cloud concepts and fundamentals


• Experience building scalable and robust data solutions for websites using a range of technologies


• Business Intelligence development experience with tools such as Tableau, PowerBI, etc.


• Development using DevAssist tools