Have you ever felt constrained or blocked by existing data sets and reporting solutions? This is an opportunity to get in at the ground floor and help shape the future of data at one of the world's largest insurance organizations. Our team is building a data lake from scratch using AWS technology, onboarding new data vendors and internal sources, and developing AI-driven tools that expand what our stakeholders can do with data. We move fast, iterate constantly, and build things that have a real and immediate impact on our customers.
We are looking for a Senior Business Intelligence Engineer (BIE) to help us accelerate that work. In this role you will own the design and delivery of enriched datasets, scalable ETL pipelines, and automated reporting solutions built on AWS. You will be the person who brings new data vendors and sources into our data lake, builds the pipelines that make that data usable, and then puts that data in front of stakeholders through AI-enhanced dashboards and self-service analytics tools. You'll also help raise the bar on the team through mentorship and participation in hiring.
Key job responsibilities
• Data Lake & Vendor Onboarding Lead the end-to-end onboarding of new data vendors and internal data sources into the GRMC data lake, spanning scoping and ingestion design through validation, enrichment, and production delivery.
• ETL / ELT Pipeline Development Design, build, and maintain robust, scalable ETL/ELT pipelines to extract, transform, and load data from a wide variety of sources (internal systems, third-party vendors, APIs) into Redshift and S3-based data lake layers.
• Dataset Engineering & Enrichment Develop enriched, analytics-ready datasets by combining internal data with external vendor sources, applying data quality checks, and ensuring fidelity from source to consumption layer.
• AI-Enhanced Reporting & Analytics Build and expand AI-powered reporting solutions (including LLM-assisted insights, automated narrative generation, and intelligent alerting) that extend what stakeholders can do independently with data.
• Dashboard & Visualization Development Design and deliver dashboards and self-service analytics solutions using QuickSight, Tableau, or Power BI that serve Actuaries, Accountants, Legal, Finance, and senior leadership.
• Insurance Claims Analytics Develop reporting and analytics for the Insurance claims life cycle, identifying new metrics, risk signals, and actionable insights from complex claims data.
• Data Mining & Deep-Dives Manipulate and mine data from Redshift, MySQL, and other sources to perform root cause analyses, answer complex business questions, and surface new insights.
• Source of Truth & Data Quality Work with cross-functional stakeholders to define and maintain sources of truth; obsessively monitor data fidelity and own resolution when issues arise.
• Automated & Ad Hoc Solutions Automate manual data processes and complete ad hoc data retrieval and analysis requests that support Actuaries, Finance, Legal, and other partners.
• Cross-Functional Partnership Partner with engineering teams to ensure data is captured and stored correctly at the source; partner with business stakeholders to translate complex needs into clear data solutions.
• Mentorship & Bar Raising Provide technical mentorship to junior BIEs, share best practices on pipeline development and data modeling, and participate in hiring loops to help raise the team's technical bar.
A day in the life
We are building a ground-up data lake for all of Global Risk Management and Claims using AWS technology. Your day-to-day responsibilities will include one or more of the following:
• Onboarding a new data vendor by scoping the ingestion pattern, building the pipeline, and validating data quality end-to-end
• Building or extending ETL pipelines that bring new data sources into the lake and make them available for analytics
• Developing AI-assisted tools that help stakeholders explore and interpret data without needing engineering support
• Creating or iterating on QuickSight/Tableau dashboards for leadership, Actuaries, Finance, or Claims teams
• Mining claims or risk data to answer a complex business question from a senior stakeholder
• Collaborating with a product manager or actuary to define the data model behind a new reporting use case
• Reviewing a junior BIE's pipeline or dashboard design and providing technical feedback
About the team
Our team supports Global Risk Management and Claims and their internal and external stakeholders. You will work directly with Actuaries, Accountants, Legal, Finance, and other internal Amazon business teams. The solutions you build will have direct impact on the overall success of one of the world's largest insurance teams. This is a ground-floor opportunity. The data lake is being built now, the AI tooling is being developed now, and the person in this role will shape what that platform looks like for years to come.
BASIC QUALIFICATIONS
- 5+ years of SQL, ETL or Oracle experience
- 4+ years of processing large, multi-dimensional datasets from multiple sources experience
- 4+ years of performing statistical analysis experience
- 4+ years of developing automated reporting experience
- Experience programming to extract, transform and clean large (multi-TB) data sets
- Experience with theory and practice of design of experiments and statistical analysis of results
- Experience with AWS technologies
- Experience in scripting for automation (e.g. Python) and advanced SQL skills.
- Experience with theory and practice of information retrieval, data science, machine learning and data mining
PREFERRED QUALIFICATIONS
- Experience working directly with business stakeholders to translate between data and business needs
- Experience managing, analyzing and communicating results to senior leadership
