Talent.com
American National
Sr Business Intelligence Data EngineerAmerican National • Springfield, MO, US
Sr Business Intelligence Data Engineer

Sr Business Intelligence Data Engineer

American National • Springfield, MO, US
30+ days ago
Job type
  • Full-time
Job description

Job Posting

American National is seeking a Sr Business Intelligence Data Engineer for our League City, TX location. The Sr Business Intelligence Data Engineer is responsible for the delivery of the corporate data warehouse and the overall execution of the data integration solutions. The Sr Business Intelligence Data engineer will support strategic, tactical, and operational data warehousing to ensure data is acquired from the correct source system and transformed with the correct logic so meaningful information is delivered in a timely manner.

Your Impact:

  • Develop and deploy the extraction, transformation, and loading routine for the data warehouse environment by sourcing the data from the operational systems, applying the business transformation rules, and loading it to the data warehouse and data mart environments
  • Analyze and develop strategies for data acquisitions, archives, recovery, and implementation of the ETL repository and load jobs
  • Determine the optimal approach for obtaining data from diverse source system platforms and moving it to the data warehouse
  • Implement and execute strategy for change data capture
  • Create testing methodology and criteria
  • Perform detailed data analysis including data quality and consistency by monitoring performance production data
  • Investigate, analyze, document, and correct reported defects.
  • Develop specifications for data cleansing, data scrubbing, ETL and data migration processes
  • Develop and maintain standards, common processes and best practices for ETL architecture including batch jobs auditing and balancing
  • Design and implements automation of data loading and cleansing processes
  • Modify ETL processes/pipelines to accommodate source system changes with new business user requirements
  • Populate the data warehouse using data modeling techniques for target structures such as Star schemas, Snowflake schemas, and highly normalized data models
  • Interpret written business requirements and transform into technical specifications
  • Create and maintain technical specification documentation


What You Will Need to be Successful in this Role:

  • Extensive hands-on experience with SQL query language development
  • 4+ years of experience in an ETL tool such as SSIS, Azure Data Factory, Informatica, DataStage
  • 4+ years of experience in developing data warehouses/data marts
  • 3+ years of experience in developing cloud-based pipelines in Azure Data Factory / AWS Glue
  • Excellent knowledge of data warehouse concepts, technologies, and best business practices to include data sourcing, data transformation, data loading, data cleansing, data integrity checking, and end-user tools
  • Hands on experience with at least 1 massive parallel platform Netezza, Teradata, Synapse
  • Knowledge of data warehousing tools, patterns, and processes
  • Experience Database design and well versed with SQL Server best practices
  • Excellent interpersonal, written, and verbal communication skills


Our Preferences:

  • Mainframe DB2 experience
  • Familiarity with Agile methodology

American National offers eligible employees and their families medical, dental, vision, and basic life insurance. Employees are able to enroll in our company’s 401k plan. Employees also receive annually a bank of paid time off and paid holidays. We aspire to see people for what they bring to our corporate culture by supporting an inclusive work environment, including an emphasis on a healthy work-life balance, development opportunities, and a casual dress code.

American National is an established, stable, and successful multi-line insurance corporation that has provided financial strength and a sense of security to employees, customers and business partners since 1905. With focus on our organization’s values and cultural richness: Financial Strength, Integrity, Respect, Service and Teamwork (FIRST) and Agility, Collaboration, and Engagement (ACE) we continue to pursue our vision to be a leading provider of financial products and services for current and future generations.

Create a job alert for this search

Sr Business Intelligence Data Engineer • Springfield, MO, US

Similar jobs

Physician (MD/DO) - Family Practice - $275,000 to $325,000 per year in Bolivar, MO

LocumJobsOnlineBolivar, MO, US
Full-time +1

Doctor of Medicine | Family Practice.LocumJobsOnline is working with CompHealth to find a qualified Family Practice MD in Bolivar, Missouri, 65613!.One of the most popular sailing destinations in t... Show more

 • Promoted

Test Products from Home – $25-$45/hr + Freebies

OCPABolivar, Missouri, us
$15.00 hourly
Part-time +1

Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet... Show more

 • Promoted

Sr Business Intelligence Developer - Onsite

Bass Pro ShopsSpringfield, MO, United States
Full-time

Senior Business Intelligence Developer.Reporting to the Senior Manager of AI & Business Intelligence, the Senior Business Intelligence Developer will play a critical role in establishing and scalin... Show more

 • Promoted • New!

Physician (MD/DO) - Family Practice - $220,000 to $260,000 per year in Bolivar, MO

LocumJobsOnlineBolivar, MO, US
$220,000.00 yearly
Full-time +1

Doctor of Medicine | Family Practice.LocumJobsOnline is working with CompHealth to find a qualified Family Practice MD in Bolivar, Missouri, 65613!.One of the most popular sailing destinations in t... Show more

 • Promoted

Extra Income Online – Remote Survey Taker Job Up to $25 Per Survey

Earn HausNixa, MO, US
Remote
Full-time +1

We are urgently looking for people interested in taking online surveys for Fortune 500 brands.If you are a self-starter, looking for flexible hours throughout the week, this may be for you! Earn up... Show more

 • Promoted

Remote Product Tester – $45/hr + Free Products – Start Now!

OCPABolivar, Missouri, us
$15.00 hourly
Remote
Part-time +1

Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet... Show more

 • Promoted

Principal AI Engineer

BrightlitalentSpringfield, MO, United States
Full-time

Location: Springfield, Missouri.Join a compassionate, collaborative team making a measurable difference by building enterprise AI capabilities that empower better decisions and faster insights.Five... Show more

 • Promoted • New!

Online Survey Participant: Work Remote and Earn Up To $25 Per Survey

Earn HausNixa, MO, US
Remote
Full-time +1

Looking for people to participate in taking online surveys for Fortune 500 brands.All you need to do is complete online surveys by sharing your opinion.You will help influence brand decisions on se... Show more

 • Promoted

Survey Taker: Earn up to $25 per survey (Remote)

Earn HausNixa, MO, US
Remote
Full-time +1

Looking for people to participate in taking online surveys for Fortune 500 brands.All you need to do is complete online surveys by sharing your opinion.You will help influence brand decisions on se... Show more

 • Promoted

OB/GYN Total Package Position in Missouri; 4-day Work Week; $400k Base Guarantee

CHG HealthcareBolivar, MO, US
Full-time

One of the most popular sailing destinations in the country is in Bolivar.There are lots of lakes, and it is family-friendly with a low cost of living and great schools.As industry leaders and Join... Show more

 • Promoted

Physician (MD/DO) - Otolaryngology - $350,000 to $400,000 per year in Bolivar, MO

LocumJobsOnlineBolivar, MO, US
Full-time +1

Doctor of Medicine | Otolaryngology.LocumJobsOnline is working with CompHealth to find a qualified Otolaryngology MD in Bolivar, Missouri, 65613!.One of the most popular sailing destinations in the... Show more

 • Promoted

Surveillance Investigator

Allied UniversalSpringfield, Missouri, United States
Full-time

Advance Your Career in Insurance Claims with Allied Universal Compliance and Investigation Services.Allied Universal Compliance and Investigation Services is the premier destination for a career in... Show more

 • Promoted

EMS Medical Director Opportunity | Step into Leadership | Bolivar MO

Citizens Memorial HealthcareBolivar, MO, US
Full-time

Citizens Memorial Hospital (CMH).Bolivar, Missouri, is recruiting a .Board-Certified or Board-Eligible Emergency Medicine Physician.This is a rare opportunity to step into leadership as well as pra... Show more

 • Promoted

Product Tester (Work From Home) – Keep Free Products + Weekly Pay

OCPABolivar, Missouri, us
$15.00 hourly
Remote
Part-time +1

Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet... Show more

 • Promoted

P&C Data Scientist II

Argonaut Management Services, IncSpringfield, Missouri, United States
Full-time

Argo Group and Farm Family are specialty property and casualty insurance brands whose underwriting companies are wholly owned subsidiaries of Brookfield Wealth Solutions, a leading provider of weal... Show more

 • Promoted

Surveillance Investigator - Part-Time

Allied UniversalSpringfield, Missouri, United States
Part-time

Surveillance Investigator - Part-Time.Advance Your Career in Insurance Claims with Allied Universal Compliance and Investigation Services.Allied Universal Compliance and Investigation Services is t... Show more

 • Promoted

Teller I

Great Southern BankNixa, Missouri, United States
Full-time

Come be a part of something greater! Great Southern Bank is committed to fostering an environment where everyone can contribute and succeed at every level.By embracing diversity, we celebrate and v... Show more

 • Promoted

Sr. Web Developer II

American IndemnitySpringfield, MO, United States
Full-time

Farm Family specializes in farm and ranch protection with a wide range of products including flexible farm packages, business owner policies, commercial package, workers compensation, commercial au... Show more

 • Promoted • New!

Travel Registered Nurse - Medical-Surgical - $2,071 per week in Bolivar, MO

TravelNurseSourceBolivar, MO, US
$2,071.00 weekly
Full-time

Registered Nurse (RN) | Medical-Surgical.TravelNurseSource is working with Medical Solutions to find a qualified Med/Surg RN in Bolivar, Missouri, 65613!.A facility in Bolivar, MO is seeking its ne... Show more

 • Promoted • New!

Surrogates Start at $55K–$75K+ — Includes $1,200 Bonus + $11K Pre-Pregnancy Payout

Physician's SurrogacyBolivar, MO, US
Full-time +2

Surrogates Start at $60K$75K+ $1,250 Bonus + $11K Pre-Pregnancy Payout.Looking for a high-paying opportunity with real support and no upfront costs?.Become a Surrogate and earn up to.All expenses ... Show more