American National Insurance - Springfield, MO
posted 3 months ago
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. This role is crucial in supporting strategic, tactical, and operational data warehousing to ensure that data is acquired from the correct source system and transformed with the correct logic, allowing for meaningful information to be delivered in a timely manner. In this position, you will develop and deploy the extraction, transformation, and loading (ETL) routines for the data warehouse environment. This involves sourcing data from operational systems, applying business transformation rules, and loading it into the data warehouse and data mart environments. You will analyze and develop strategies for data acquisitions, archives, recovery, and implementation of the ETL repository and load jobs. Determining the optimal approach for obtaining data from diverse source system platforms and moving it to the data warehouse will be a key responsibility. Additionally, you will implement and execute strategies for change data capture, create testing methodologies and criteria, and perform detailed data analysis, including monitoring performance production data for quality and consistency. Investigating, analyzing, documenting, and correcting reported defects will also be part of your duties. You will develop specifications for data cleansing, data scrubbing, ETL, and data migration processes, and maintain standards, common processes, and best practices for ETL architecture. Your role will also involve designing and implementing automation of data loading and cleansing processes, modifying ETL processes/pipelines to accommodate source system changes, and populating the data warehouse using data modeling techniques such as Star schemas, Snowflake schemas, and highly normalized data models. You will interpret written business requirements and transform them into technical specifications, creating and maintaining technical specification documentation throughout the process.