Responsibilities:
- Develop solutions for advanced analytics and business insights in a cloud-based environment.
- Design cloud-based data storage systems and data pipelines for batch and real-time data processing.
- Contribute to enterprise-wide governance and data utilization as an enterprise asset.
- Integrate company data with third parties using a cloud-based data-processing architecture.
- Build data pipelines to centralize data from various sources in a data warehouse.
- Optimize data processes and architecture.
- Collaborate with stakeholders to deliver advanced data processing solutions.
- Foster a positive work environment to enable team success.
Must-have skills:
- Knowledge of ETL/ELT methods and best practices.
- Data modeling skills for analytics and data warehousing (star schema, Data Vault 2.0, Kimball model).
- Advanced SQL skills, including complex joins and semi-structured data.
- Experience with ETL tooling/platforms (e.g., Matillion or SSIS).
- Minimum of four years of ETL development experience.
- Minimum of four years of development experience with databases and data warehousing.
Added bonuses (desired skills):
- Understanding of change data capture for net change processing.
- Experience with cloud architecture and services (AWS, Azure, Google Cloud Platform).
- Knowledge of event architecture and streaming data solutions.
- Advanced Python skills.