Description
You will design the Enterprise Data Warehouse architecture and lead the technical direction of the data engineering team.
This role is remote.
Responsibilities
- Design the overall EDW architecture and oversee data modeling to support analytical needs.
- Lead integration of data from various source systems by designing and developing ETL/ELT processes.
- Optimize EDW performance through query tuning, index design, table partitioning, and caching strategies.
- Build scalable solutions using micro-service architecture to enable a self-service data environment.
- Collaborate with business analysts and stakeholders to define and extend the enterprise data model.
Required Skills
- 8+ years of experience in business insights, advanced analytics, data analysis, or consulting.
- 7+ years of experience as a data warehousing professional.
- 3+ years of experience as a Data Architect.
- 2+ years of experience in a project or team lead role.
- 5+ years architecting ETL data flows using at least two enterprise tools (SAP BODS, SSIS, Informatica, Ab Initio, or IBM InfoSphere DataStage).
- Proficiency with Oracle Database and Microsoft SQL Server.
- Bachelor’s degree in Computer Science, Information Systems, or Data Analytics.
- Expertise in data querying, analytics, and identifying business risks or opportunities.
Preferred Skills
- Experience with big data platforms including Hadoop, GCP, AWS, BigQuery, or Azure.
- Experience designing reporting semantic layers or using tools like IBM Cognos, SAP Business Objects, Tableau, or Microsoft Power BI.