Data Engineer (Finance Systems)

Data Engineer (Finance Systems)

Data Engineer (Finance Systems)

Our client, a leader in the insurance sector, is looking to hire five skilled professionals with expertise in ETL processes, PostgreSQL development, and data integration for financial reporting. The role involves ensuring accurate data management across various finance systems.

What is in it for you:

• Salaried: $75 to $79 per hour.
• Incorporated Business Rate: $88 to $92 per hour.
• 6-month contract.
• Full-time position: 37.50 hours per week.
• Hybrid work: in-office three days per week at the Markham office, with mandatory attendance on Tuesday and Wednesday, plus one flexible weekday.
• Opportunity to work in a dynamic and professional environment.






• Join a passionate and inclusive team of professionals.

Responsibilities:

• Design, develop, and maintain ETL processes to extract, transform, and load data from diverse sources into finance systems.
• Develop and optimize complex SQL queries and stored procedures in PostgreSQL.
• Monitor and troubleshoot daily and monthly job executions, addressing failures promptly.
• Collaborate with finance and insurance teams to understand data requirements, ensuring data integrity and accuracy.
• Build reports using Qlik and other data visualization tools.
• Conduct data analysis and troubleshooting to resolve data-related issues.
• Implement data quality checks and validation processes to uphold data standards.
• Create solutions for complex finance calculations using PostgreSQL stored procedures or ETL tools.
• Monitor and enhance the performance of ETL processes and database systems.






• Document technical specifications and maintain comprehensive records of ETL processes and database schemas.
• Stay informed on the latest industry trends and best practices in ETL and database management.

What you will need to succeed:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Proven experience as an ETL Developer, specifically with Informatica PowerCenter and Informatica BDM.
• Strong expertise in PostgreSQL and database design, with experience supporting finance systems.
• Experience with Oracle Fusion applications, including sub-modules such as accounts payable, cash management, and fixed assets.
• Experience working with Guidewire Policy, Billing, and Claims Centers.
• Experience with Snowflake and cloud-based data solutions.






• Proficiency with automation tools like Control-M and ASG ZENA, and scripting in Unix.
• Knowledge of data visualization tools, including Qlik, Python reporting, and Power BI.
• Solid understanding of accounting principles, including balance sheet and P&L; concepts.
• Understanding of underwriting data terminology within the insurance industry.
• Familiarity with data warehousing concepts and best practices.
• Experience in Agile methodology and familiarity with JIRA.
• Informatica Certified Professional (ICP) or other relevant Informatica certifications are an asset.
• Guidewire professional certifications are an asset.
• Familiarity with additional database systems such as Oracle and MySQL; SQL Associate Certification is a plus.






• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills, with the ability to work both independently and within a team.

Why Recruit Action?

Recruit Action (agency permit: AP-2000003) provides recruitment services through quality support and a personalized approach to job seekers and businesses. Only candidates who match hiring criteria will be contacted.

# AVICJP00002606, 2607, 2608, 2609 and 2610

▶️ Data Engineer (Finance Systems)
🖊️ Recrute Action
📍 Markham