Data Engineer

Data Engineer - Contract - Raleigh, NC - $52.62 - $52.62/hr.

The final salary or hourly wage, as applicable, paid to each candidate/applicant for this position is ultimately dependent on a variety of factors, including, but not limited to, the candidate's/applicant's qualifications, skills, and level of experience as well as the geographical location of the position.

Applicants must be legally authorized to work in the United States. Sponsorship not available.
Our client is seeking a Data Engineer in Raleigh, NC.

Role & Description

The Engineering team is looking for a Data Engineer to design build and optimize scalable data solutions while supporting enterprise migration initiatives from legacy or on premises systems to cloud based platforms
We are seeking a highly skilled Data Engineer with strong hands-on experience in modern data engineering practices deep expertise in Snowflake architecture and implementation and proven experience in data platform migrations
The ideal candidate will lead the engineering work to align with the approved solution architecture and technology roadmap to comply with enterprise technical standards providing expertise as a technical resource to solve complex business issues translating data integration and database systems design for new initiatives
Design develop and maintain scalable and reliable data engineering pipelines to support analytics and business intelligence needs
Architect design and implement solutions that meet stakeholders needs
Architect implement and optimize Snowflake data warehouse solutions including data modeling performance tuning and cost optimization
Lead and support data migration initiatives including migration from on premises or legacy data platforms to Snowflake or other cloud based solutions
Develop and manage ELTETL processes using modern data integration tools and frameworks
Participate actively in requirements gathering data modelling and design sessions
Prepare high level and detailed technical specifications for the projects in accordance with security and architecture documentation objectives
Develop detailed plans and accurate estimates for the completion of the build system testing and implementation phases of a project
Collaborate with data architects analytics teams and business stakeholders to translate requirements into technical solutions
Running and optimizing SQL queries on RDBMS like MS SQL server MySQLMariaDB
Ensure data quality security governance and compliance throughout the data lifecycle
Develop code document and execute unit tests systems integration and acceptance tests and testing tools for functions of high complexity
Troubleshoot and resolve performance data integrity and pipeline reliability issues
Document architecture data flows and operational procedures
Strong hands-on experience in Data Engineering including data pipeline development and largescale data processing
Deep expertise in Snowflake architecture including Virtual warehouses Micro partitioning Clustering and performance optimization Security and access control
Proven experience with data migration projects including assessment planning execution and validation
Minimum 5 years of experience in software engineering or analytics in creating enterprise data architectures distributed and microservice software architectures and design patterns
Strong SQL skills and experience with data modeling dimensional andor data vault
Core SQL database concepts including creating DDL DML scripts normalization running and optimizing SQL queries on RDBMS
Experience working with cloud platforms AWS Azure or Google Cloud Platform
2 years of application development experience in Hadoop NoSQL databases like MongoDB Cassandra or HBase
Familiarity with orchestration and data integration tools eg Airflow dbt Informatica Fivetran or similar
Prior experience with Liquibase Git code repos like GitHub
Bachelor's degree in information technology computer science
Strong problem-solving skills and ability to work independently in a fast paced environment
Working knowledge of MapReduce or Spark
Knowledge in Java Python Bash shell scripting
Experience using Stone Branch
Experience in Tableau"
Benefits/Other Compensation

This position is a contract/temporary role where Hays offers you the opportunity to enroll in full medical benefits, dental benefits, vision benefits, 401K and Life Insurance ($20,000 benefit).

Why Hays?

You will be working with a professional recruiter who has intimate knowledge of the industry and market trends. Your Hays recruiter will lead you through a thorough screening process in order to understand your skills, experience, needs, and drivers. You will also get support on resume writing, interview tips, and career planning, so when there's a position you really want, you're fully prepared to get it.

Nervous about an upcoming interview? Unsure how to write a new resume?

Visit the Hays Career Advice section to learn top tips to help you stand out from the crowd when job hunting.

Hays is committed to building a thriving culture of diversity that embraces people with different backgrounds, perspectives, and experiences. We believe that the more inclusive we are, the better we serve our candidates, clients, and employees. We are an equal employment opportunity employer, and we comply with all applicable laws prohibiting discrimination based on race, color, creed, sex (including pregnancy, sexual orientation, or gender identity), age, national origin or ancestry, physical or mental disability, veteran status, marital status, genetic information, HIV-positive status, as well as any other characteristic protected by federal, state, or local law. One of Hays' guiding principles is 'do the right thing'.
We also believe that actions speak louder than words.
In that regard, we train our staff on ensuring inclusivity throughout the entire recruitment process and counsel our clients on these principles. If you have any questions about Hays or any of our processes, please contact us.

In accordance with applicable federal, state, and local law protecting qualified individuals with known disabilities, Hays will attempt to reasonably accommodate those individuals unless doing so would create an undue hardship on the company. Any qualified applicant or consultant with a disability who requires an accommodation in order to perform the essential functions of the job should call or text .

Drug testing may be required; please contact a recruiter for more information.

#LI-DNI