ETL Developer

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.