What you'll do:

📍ETL Development: Design, develop, and maintain ETL processes using Matillion to extract, transform, and load data from various source systems into our data warehouse. 📍Data Ingestion and Integration: Integrate data from diverse sources such as databases, APIs, flat files, and cloud storage into a centralized data repository. Use AWS Glue to automate data extraction and transformation from various sources like S3, databases, and streaming services for real-time data ingestion, leverage Amazon Kinesis streams or AWS Data Pipeline. 📍Data Transformation: Transform and clean data to ensure accuracy, consistency, and quality, while also optimizing performance for analytical queries. 📍Performance Optimisation: Monitor and optimise Matillion ETL jobs for efficiency, scalability, and performance to meet business needs. 📍Data Modelling: Collaborate with data analysts and data scientists to design and implement data models that support analytical reporting and data visualization. 📍Data Governance: Ensure data governance best practices are followed, including data lineage, data quality, and data security. 📍Troubleshooting: Identify and resolve ETL job failures, data issues, and performance bottlenecks in a timely manner. 📍Scalability and Automation: Plan for scalability as data volumes grow and automate repetitive tasks.

What you'll bring:

📍Bachelor's degree in Computer Science, Information Systems, or a related field (Master's degree preferred). 📍Proven experience in data engineering or a related role, with a strong background in data modeling, ETL, and database management. 📍Proficiency in programming languages such as SQL, Python, or Java. 📍Familiarity with data warehousing solutions (e.g., Snowflake, Redshift) and big data technologies (e.g., Hadoop, Spark). 📍Knowledge of data visualization tools (e.g., Tableau, Power BI) is a plus. 📍Solid understanding of data governance, data security, and compliance standards