Senior / Data Engineer
Summary
Senior Data Engineer builds and maintains data pipelines, warehouses, and models for a government-linked agency, using cloud tech, Databricks, and Python/SQL.
About the role
As a Senior Data Engineer, you will be working on translating data requirements from business users into technical specifications, collaborating with partner agency's IT teams on technology stack, infrastructure and security alignment, and building out data products as part of a data team.
Key responsibilities
- Architect and build ingestion pipelines to collect, clean, merge, and harmonize data from different source systems
- Day-to-day monitoring of databases and ETL systems, including database capacity planning and maintenance, monitoring, and performance tuning; diagnose issues and deploy measures to prevent recurrence; ensure maximum database uptime
- Construct, test, and update useful and reusable data models based on data needs of end users
- Design and build secure mechanisms for end users and systems to access data in data warehouse
- Research, propose and develop new technologies and processes to improve agency data infrastructure
- Collaborate with data stewards to establish and enforce data governance policies, best practices and procedures
- Maintain data catalogue to document data assets, metadata and lineage
- Implement data quality checks and validation processes to ensure data accuracy and consistency
- Implement and enforce data security best practices, including access control, encryption, and data masking, to safeguard sensitive data
About you
- Bachelor's Degree, preferably in Computer Science, Software Engineering, Information Technology, or related disciplines
- Deep understanding of system design, data structure and algorithms, data modelling, data access, and data storage
- Demonstrated ability in using cloud technologies such as AWS, Azure, and Google Cloud
- Experience with Databricks
- Experience in designing, building, and maintaining batch and real-time data pipelines
- Experience with orchestration frameworks such as Airflow, Azure Data Factory
- Proficiency in working with Python, Shell Scripts, and SQL
- Familiarity with building and using CI/CD pipelines
- Familiarity with DevOps tools such as Docker, Git, Terraform
- Experience with implementing technical processes to enforce data security, data quality, and data governance
- 5 day week @ AMK area