Data Engineer

Experience Level: 7-8 years in a technical role within Financial Reporting identifying data sources, creating data pipelines, optimizing database performance and maintaining data pipelines.

We are looking for an AI first mindset to meet the evolving needs of our business, which will require research and learning of AI tools and concepts at work and outside of work.

Core Technical Skills

• AWS Data Services:

• Amazon Athena and/or Redshift: Experience designing schemas, loading data, and optimizing performance for analytical workloads.
• Amazon S3: Working knowledge of S3 bucket structures, data organization, lifecycle management, and integration with downstream analytics platforms.
• Glue Jobs: To create Data Pipelines with ETL capabilities.

• Database Design & Development: Proven experience designing, optimizing, and maintaining relational data models to support reporting and analytics use cases in the Insurance and/or Financial Services industry.
• T SQL: Strong proficiency writing, tuning, and troubleshooting complex T SQL queries, stored procedures, and views.
• ETL & Data Integration: Hands on experience with ETL tools and frameworks to ingest, transform, and validate data from multiple source systems.
• Data Pipeline Creation: Demonstrated ability to build and maintain reliable, scalable, and automated data pipelines with appropriate monitoring and error handling.
• BI & Reporting Tools:

• Power BI: Experience developing datasets, semantic models, dashboards, and reports for business and finance stakeholders.
• Smart View: Familiarity using Smart View for financial reporting, analysis, and integration with EPM or financial systems.

AI & Advanced Analytics (1 2 Years Preferred)

• Experience leveraging AI tools and technologies to enhance data engineering or analytics workflows.
• Practical knowledge of grounding large language models (LLMs) to structured data stores, such as databases, data warehouses, or curated datasets.
• Understanding of data quality, security, and governance considerations when integrating AI solutions with enterprise data.

Domain Expertise (Strong Preference)

• Deep understanding of Financial Reporting concepts and processes.
• Insurance and/or Financial Services industry experience strongly preferred, including familiarity with:

• Oracle ERP/EPM modules
• Expense Data, Capital Data, and Sales Data
• Financial statements and regulatory reporting
• Data controls, reconciliations, and audit considerations
• Complex financial data models and hierarchies

Soft Skills & Work Style

• Strong analytical and problem solving skills with attention to detail.
• Ability to collaborate effectively with finance, reporting, and technology teams.
• Clear communication skills, especially when translating technical concepts for business stakeholders.
• Comfortable working in a fast paced, contract to hire environment with an emphasis on delivering production ready solutions.