Data Engineer

About the Role:

We are seeking a technically focused Data Engineer to drive data warehouse management, invoice reconciliation automation, and process optimization. This internal-facing role emphasizes technical data analysis and system automation to enhance operational efficiency.

Key Responsibilities:

• Data Warehouse Management: Design, maintain, and optimize data warehouse architecture to support cross-departmental analytics and reporting needs
• Invoice Reconciliation: Lead automated reconciliation processes for invoices across the entire group and implementing data validation
• Process Automation: Develop and deploy automated reporting solutions and data pipelines to eliminate manual processes and improve data accuracy
• Build and maintain ETL processes to ensure data integrity and accessibility across departments
• Collaborate with cross-functional teams to identify process inefficiencies and implement data-driven solutions

Job Requirements:

Education & Experience:

• Bachelor’s degree in Computer Science, Business Administration, Economics, Finance, Mathematics, Statistics, or another related analytical field
• 3-6 years of experience in data engineering or related technical analytical roles
• Required: Hands-on experience with data warehouse design, implementation, and management
• Required: Experience with financial data automation

Technical Skills:

Core Requirements:

• Advanced SQL proficiency for complex database querying, data manipulation, and performance optimization - required
• Data warehouse management experience with dimensional modeling, ETL processes, and data architecture - required
• Process automation using scripting languages (Python, PowerShell) or automation tools - required
• Advanced proficiency in Microsoft Excel - required

Highly Preferred:

• PostgreSQL expertise including query optimization, stored procedures, and database administration
• AWS cloud services experience (RDS, S3, Lambda, Glue) for data storage and processing
• Power Query for advanced data transformation and data modelling
• API integration experience for data extraction and system connectivity
• Experience with data pipeline orchestration tools

Core Competencies:

• Proven ability to design and implement automated solutions for complex business processes
• Ability to work independently and manage multiple technical projects simultaneously in a fast-paced environment
• Strong collaborative skills for working with IT, Finance, and Operations teams
• Critical thinking skills and ability to identify optimization opportunities in large, complex datasets