22 Oct
VStream Labs
Markham
About Us:
We are seeking a talented Finance Systems Data Engineer with expertise in ETL and PostgreSQL development, along with strong experience in the insurance industry, to join our dynamic team.
Job Profile Summary
Responsibilities:
- Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into our finance systems.
- Develop and optimize complex SQL queries and stored procedures in PostgreSQL.
- Monitor daily/monthly jobs and resolve any failures.
- Collaborate with finance and insurance teams to understand data requirements and ensure data integrity and accuracy.
- Build Qlik reports.
- Perform data analysis and troubleshoot data-related issues.
- Implement data quality checks and validation processes.
- Provide solutions by building complex financial calculations using Postgres stored procedures or ETL.
- Monitor and improve the performance of ETL processes and database systems.
- Document technical specifications and maintain comprehensive documentation of ETL processes and database schemas.
- Stay up to date with the latest industry trends and best practices in ETL and database management.
Requirements:
- Experience in the insurance industry and the ability to understand underwriting data terminology.
- Experience in supporting finance systems.
- Knowledge of Oracle Fusion applications, including sub-modules such as accounts payable, cash management, and fixed assets.
- Proven experience as an ETL Developer (Informatica PowerCenter and Informatica BDM).
- Proven experience as a PostgreSQL Developer.
- Experience with Guidewire Policy, Billing & Claims Centers.
- Experience with automation tools like Control-M and ASG ZENA, and writing Unix scripts.
- Experience in Qlik and Python reporting.
- Experience with Snowflake.
- Solid understanding of accounting principles (Balance sheet/P&L; concepts).
- Expertise in ETL tools, especially Informatica, and PostgreSQL.
- Strong proficiency in Postgres and database design.
- Knowledge of data warehousing concepts and best practices.
- Excellent problem-solving skills and attention to detail.
- Experience in Agile methodology and JIRA.
- Strong communication and collaboration skills.
- Ability to work both independently and as part of a team.
Guidewire Components Relevant to the Role:
1. BillingCenter:
Handles billing and receivables management. As a Finance Systems Data Engineer,
you will work with data from BillingCenter to ensure accurate financial reporting and analysis, including revenue recognition, tracking premium payments, and managing receivables.
2. PolicyCenter:
Manages policy administration, including underwriting and the policy lifecycle. You will analyze underwriting performance, loss ratios, and expense ratios using data from PolicyCenter for comprehensive financial reports.
3. ClaimsCenter:
Handles the claims process. ClaimsCenter data is crucial for understanding claims reserves, payouts, and financial analysis, impacting the company's liabilities and profitability.
Relevance to the Role:
- Data Integration: You will design ETL processes to extract, transform, and load data from Guidewire systems into finance systems.
- Data Analysis:
Understanding data structures and terminology used in Guidewire applications is essential for accurate data analysis.
- Financial Reporting: You will use Guidewire data for financial reporting and complex financial calculations.
- Collaboration: Work closely with teams using Guidewire applications to maintain data integrity and meet data requirements.
Preferred Qualifications:
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- Informatica Certified Professional (ICP) and/or Informatica Foundation Level Certifications (IDMC, CDCG, MDM, etc.).
- Experience with database systems (e.g., Oracle, Postgres, MySQL). SQL Associate Certification is an asset.
- Guidewire professional certifications are an asset.
- Familiarity with cloud-based data solutions (e.g., AWS, Snowflake).
- Knowledge of data visualization tools (e.g., Qlik, Python, Power BI).
▶️ Finance Systems - Data Engineer (ETL & Guidewire Specialist)
🖊️ VStream Labs
📍 Markham