Description

Lead ETL design, data modeling, and development for Enterprise Data Warehouse integration. Translate stakeholder requirements into technical solutions and ensure security compliance.

Responsibilities

• Lead ETL design, data modeling, and development processes while establishing best practice guidelines.
• Translate stakeholder requirements into technical designs and build solutions integrating with the EDW.
• Analyze current systems and interfaces to document functional and technical specifications.
• Develop unit and performance tests while ensuring all security requirements are met.
• Conduct design and code reviews and manage progress using Agile methodology.

Required Skills

• 5+ years of experience with Oracle.
• 5+ years of experience with Data Warehousing, including building relational databases and star schemas.
• 5+ years of experience with Data Modeling.
• 4+ years of experience with ODI (Oracle Data Integrator Tool) or Informatica IDMC.
• 3+ years of experience with Databricks Lakehouse and/or Delta tables.
• 2+ years of experience designing, implementing, and supporting Kimball method data warehouses on SQL Server or Oracle.
• Strong SQL reading and writing skills.
• Background in Data Integration (ETL), Data Security, and Enterprise Data Warehouse development.
• Experience with Change Management, Release Management, and Source Code control.

Preferred Skills

• Bachelor of Science degree in computer science, systems analysis, or a related area.

Key Skills

Education

Bachelor of Science degree