
Data Engineer
- McMahons Point, NSW
- Permanent
- Full-time
- Create flexible, scalable, and efficient data models that cater to diverse analytical and processing requirements.
- Combine data engineering with data visualisation and reporting skills to deliver insights using Power BI and other BI tools.
- Build and maintain Power BI dashboards and reports to support business decision-making.
- Translate complex datasets into clear, actionable insights through effective visualisation
- Write efficient queries, structure datasets for analytics, and troubleshoot performance issues in production environments.
- Design systems that scale and adapt to schema drift, late-arriving data, or inconsistent input format.
- Create self-service capabilities for business users while maintaining enterprise-grade security and governance standards.
- Establish standards and automated processes to ensure data maintains accuracy, completeness, and consistency throughout its lifecycle.
- Implement multi-layered security measures including encryption, access controls, and continuous monitoring to protect sensitive data.
- Apply infrastructure as code principles and tools like Terraform to manage cloud resources programmatically, ensuring reproducible deployments and consistent environments.
- Apply window functions, common table expressions, and query optimization techniques to improve performance.
- Design storage and compute strategies that balance cost, performance, and compliance, integrating cloud-native data solutions with legacy systems.
- Bachelor's degree in computer science, information technology, or a related field.
- 5+ years of experience in data engineering, with a strong focus on data modelling, aggregation, and business intelligence.
- Proven ability to design and build efficient data models within a data warehouse environment.
- Strong understanding of data warehousing principles and dimensional modelling.
- Expert-level SQL skills for complex data manipulation, querying, and aggregation.
- Excellent communication skills to translate business needs into technical data solutions.
- A proactive, detail-oriented mindset with a focus on data accuracy and integrity.
- Experience with next-generation architectures such as Vector Databases and RAG will be a plus.
- Expertise in building and maintaining reports and dashboards with Tableau.
- Experience with data loading, transformation, and performance optimization in a modern environment such as Snowflake.