Description
Formulate and execute ELT / ETL strategies to transfer data from internal sources to operational data stores, Azure data lake, and data warehouse.
Devise APIs, data structures, and schemas for effective data storage and retrieval.
Sustain data mappings, definitions, and architectural diagrams.
Ensure data integrity through validation and testing mechanisms.
Conduct feasibility studies to assess new processes and technologies.
Oversee code deployment across various environments.
Identify and resolve data-related issues and defects.
Enhance database performance and optimize query execution.
Participate in code reviews and offer guidance to team members.
Document code and develop templates adhering to industry standards.
Requirements
Bachelor’s Degree or equivalent experience is mandatory.
At least 5 years of professional experience in roles such as Data Engineer, ETL Engineer, Data/ETL Architect, or similar.
Skills:
Proficiency in Python with a minimum of 5 years of consistent practice.
Solid experience with Airflow spanning at least 3 years.
Demonstrated expertise with Azure Data Factory (ADF) or similar tools for at least 3 years.
Substantial hands-on experience with relational databases like Oracle, SQL Server, PostgreSQL, or equivalent platforms, totaling at least 3 years.
Practical knowledge of NoSQL databases such as MongoDB, Cosmos DB, DocumentDB, or equivalent, accumulated over at least 3 years.
Proficient in writing SQL code, with a minimum of 3 years of experience.
Familiarity with Kimball Dimensional Modeling (Star-Schema) methodology, with at least 3 years of practice.
Exposure to columnar databases like Snowflake, Azure Synapse, or equivalent platforms for a minimum of 2 years.
At least 2 years of experience with Azure or AWS cloud platforms.
Preferred, but not mandatory:
Exposure to ETL/ELT tools such as Spark, Apache NiFi, Kafka, Luigi, Prefect.
Proficiency in languages like Java, Scala, or R.
Familiarity with platforms like Databricks.
Experience working with databases such as Redis or Elasticsearch.
Knowledge of Data Orchestrators like Control-M or JAMS.
Technology Doesn't Change the World, People Do.®
Robert Half is the world’s first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app (https://www.roberthalf.com/us/en/mobile-app) and get 1-tap apply, notifications of AI-matched jobs, and much more.All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.© 2024 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking “Apply Now,” you’re agreeing to Robert Half’s Terms of Use (https:///www.roberthalf.com/us/en/terms) .