Sr. ETL Developer at HAYS in Raleigh, North Carolina

Job Description:

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 Sr. ETL Developer in Remote opportunity.


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.


Benefits/Other Compensation:


Health and Wellness, Medical, Dental, Vision, 401k, Pretax Savings Accounts, PTO.


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 813.336.5570.


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


#LI-DNI
#1164569 - Cindy Martinez