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.
Don't want to miss the next one?
Subscribe to daily email alerts for roles matching your interests.
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
Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.
Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.
The base salary range for this position is listed below. Your Amazon package will include sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience, qualifications, and location. Amazon also offers comprehensive benefits including health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and option for Supplemental life plans, EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage), 401(k) matching, paid time off, and parental leave. Learn more about our benefits at https://amazon.jobs/en/benefits.
USA, WA, Seattle - 130,400.00 - 176,300.00 USD annually
Similar roles you might like
More openings like this one — take a look before you go.
