Sr Business Intelligence Data Engineer
Springfield, MO, US, 65899
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.
Hiring Practices
The preceding job posting was designed to indicate the general nature and level of work performed by employees assigned to this position. It is not intended to be interpreted as a comprehensive list of all duties, responsibilities, and qualifications. We are dedicated to building a diverse, inclusive, and authentic workplace, so if you’re excited about this role, but your past experience doesn’t align perfectly with the job qualifications, we still encourage you to apply. You may be just the right candidate for this position or other opportunities at American National.
American National’s recruitment policies help us place individuals in a timely and efficient manner. Only the most qualified candidates will be contacted by our recruiting team. Candidates may check the status of their application(s) by logging into our Career Portal. Learn more about our company, by following us on social media: LinkedIn, Facebook, Instagram
American National is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, genetic information or any other legally protected categories. American National is committed to providing access, equal opportunity and reasonable accommodation for individuals with disabilities in employment, its services, programs, and activities.
Nearest Major Market: Springfield
Job Segment:
Business Intelligence, Data Warehouse, Database, SQL, Social Media, Technology, Marketing