You will own the Enterprise Data Warehouse and ODS builds, developing scalable ETL components and managing model extensions. You will build data integration processes that ensure accuracy and timely delivery to downstream systems.
Responsibilities
- Develop ETL code addressing performance, dependency, auditing, error handling, and data quality.
- Build and optimize data integration processes for consistency and reliability.
- Create reports, dashboard pages, and metrics aligned with business requirements.
- Participate in code reviews to ensure alignment with architectural specifications.
- Write functional requirements, technical designs, and comprehensive documentation for all code changes.
Required Skills
- 10+ years of Enterprise Data Warehouse experience.
- 5+ years of ETL development using SSIS or Ab Initio.
- Strong ANSI SQL expertise with the latest SQL Server releases.
- Proficiency in C#, Python, or Java.
- Experience with REST APIs development.
- 3+ years of experience with Unix and Shell Scripting.
- Hands-on experience with data modeling and Star Schema.
- Experience using Azure DevOps and at least one job scheduler.
- Bachelor's Degree in Computer Science or a related field.