Sr Business Intelligence Data Engineer

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.