What are the responsibilities and job description for the ETL Developer position at HAYS?
Job Details
ETL Developer - Permanent - Raleigh, NC - $140,000 - $170,000.
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. Visa sponsorship not available.
Our client is seeking a ETL Developer in Raleigh, NC.
Role Description
The Senior ETL developer will work with the Corporate IT team to maintain and develop data integration solutions to support our Analytics platform. The solutions must align with data vault, data mart, dimensional modeling, and ETL standards and guidelines. The data modeling and data integration solutions will be based on Matillion with Snowflake data warehouses/databases & Power BI for reporting platform.
The ideal candidate will need to understand business and technical requirements and translate this into data integration designs and deliverables by working with the Corporate Data Architect. The position also requires supporting the Agile process in terms of Development, testing, deployment and post-production support.
Handle multiple projects in parallel, participate and deliver solution design while working closely with the architecture
Design and Develop/Review ETL programs primarily using modern ETL tools like Matillion, DBT , and Python
Coach and guide the technical team in terms development of ETL jobs
Provide performance improvement and tuning of data pipeline.
Perform technical reviews, data validation, and end to end testing of ETL objects, source data analysis and data profiling
Create necessary documentation as per the standards and update the project documentation
Support QA on end-to-end testing and provide daily/weekly project status to the project manager
Work with deployment team in the code migration across the environments
Triage the Production issues and work on the code fixes
Proven experience in database administration with cloud data platforms like Snowflake
Frees up data engineers and analysts from administrative tasks
Skills & Requirements
10 years of experience in implementation of BI projects in a large-scale enterprise data warehouse environment
Hands-on experience in building large cloud data warehouses using Snowflake; including database architecture design, data transformations, stored procedures, account and security principles, performance management, etc.
Experience with cloud computing services, particularly deploying and running services in Azure
Expert-level understanding of Agile, SDCL, CI/CD, DevOps, GitOps, and ProdOps.
A team player with excellent verbal and written communication skills
Experience with other ETL tools like Matillion, ADF, and DBT
Advance SQL knowledge and familiar with relational, Vault, and dimensional modeling
knowledge of Power BI
Financial industry data fluency is preferred but not required
Required knowledge and skills would typically be a acquired through a bachelor's degree in information technology or related field
10 yoe data warehousing
At least 1 year in cloud
Snowflake is a MUST, deep understanding query, structure, security and networking piece, architecture
ETL experience to troubleshoot or help other developers (can learn Matillion on the job)
Reporting experience, not a developer but understand how PowerBI works, tech architecture, cashing, make changes to the report, how it pulls the data
Snowflake experience MUST be highlighted in the resume - detail the projects where they use Snowflake
Dimensional modeling and relational modeling experience
Finance background helps a lot - willing to learn about the balance sheet, income statement, effects rate, gains and losses - needs to know the insurance language LOB
Financial warehouse, Insurance experience preferred
Reliable, Good Comm to communicate effectively with offshore resources and finance team members
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
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. Visa sponsorship not available.
Our client is seeking a ETL Developer in Raleigh, NC.
Role Description
The Senior ETL developer will work with the Corporate IT team to maintain and develop data integration solutions to support our Analytics platform. The solutions must align with data vault, data mart, dimensional modeling, and ETL standards and guidelines. The data modeling and data integration solutions will be based on Matillion with Snowflake data warehouses/databases & Power BI for reporting platform.
The ideal candidate will need to understand business and technical requirements and translate this into data integration designs and deliverables by working with the Corporate Data Architect. The position also requires supporting the Agile process in terms of Development, testing, deployment and post-production support.
Handle multiple projects in parallel, participate and deliver solution design while working closely with the architecture
Design and Develop/Review ETL programs primarily using modern ETL tools like Matillion, DBT , and Python
Coach and guide the technical team in terms development of ETL jobs
Provide performance improvement and tuning of data pipeline.
Perform technical reviews, data validation, and end to end testing of ETL objects, source data analysis and data profiling
Create necessary documentation as per the standards and update the project documentation
Support QA on end-to-end testing and provide daily/weekly project status to the project manager
Work with deployment team in the code migration across the environments
Triage the Production issues and work on the code fixes
Proven experience in database administration with cloud data platforms like Snowflake
Frees up data engineers and analysts from administrative tasks
Skills & Requirements
10 years of experience in implementation of BI projects in a large-scale enterprise data warehouse environment
Hands-on experience in building large cloud data warehouses using Snowflake; including database architecture design, data transformations, stored procedures, account and security principles, performance management, etc.
Experience with cloud computing services, particularly deploying and running services in Azure
Expert-level understanding of Agile, SDCL, CI/CD, DevOps, GitOps, and ProdOps.
A team player with excellent verbal and written communication skills
Experience with other ETL tools like Matillion, ADF, and DBT
Advance SQL knowledge and familiar with relational, Vault, and dimensional modeling
knowledge of Power BI
Financial industry data fluency is preferred but not required
Required knowledge and skills would typically be a acquired through a bachelor's degree in information technology or related field
10 yoe data warehousing
At least 1 year in cloud
Snowflake is a MUST, deep understanding query, structure, security and networking piece, architecture
ETL experience to troubleshoot or help other developers (can learn Matillion on the job)
Reporting experience, not a developer but understand how PowerBI works, tech architecture, cashing, make changes to the report, how it pulls the data
Snowflake experience MUST be highlighted in the resume - detail the projects where they use Snowflake
Dimensional modeling and relational modeling experience
Finance background helps a lot - willing to learn about the balance sheet, income statement, effects rate, gains and losses - needs to know the insurance language LOB
Financial warehouse, Insurance experience preferred
Reliable, Good Comm to communicate effectively with offshore resources and finance team members
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
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Salary : $140,000 - $170,000
