Who we are.
American National is a successful and stable corporation guided by five core values: Financial Strength, Integrity, Respect, Service and Teamwork. We are among America's Most Trustworthy Financial Companies according to Forbes. We've spent the last 110+ years earning this reputation and we work each day to expand this legacy. We know we're not just selling insurance, we're providing security and peace of mind to our 5 million policyholders.
The growth, innovation and success of American National are driven by our incredible employees who thrive on delivering exceptional service to our clients. Success begins and ends with our people. Their loyalty and dedication to American National is why we're successful.
If you share our values and can contribute to our mission of providing the highest quality service to our clients, we want to hear from you!
Why join us?
We know that our employees' lives encompass much more than the time they spend at work. To help them maintain a healthy work/life balance, we've compiled a generous benefits package, including: medical, dental, vision, short and long-term disability, life insurance, flexible spending account, matching 401(k), paid time off, paid holidays, tuition reimbursement and referral bonuses.
We've also incorporated unique benefits like our volunteer program where employees are provided PTO for giving their time to a non-profit of their choice. Healthy employees are productive employees so we also have a comprehensive wellness program that includes onsite fitness centers and classes or discounted gym memberships, free health screenings, free flu shots, and more.
Data Warehouse Developer
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
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 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 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 intotechnical specifications
Create and maintain technical specification documentation
Other Duties as Assigned
First and foremost, we require individuals with outstanding communication skills and the ability to explain complex technical ideas to non-technical people.Additionally, they should also possess as many of the following as possible:
Minimum 3 and preferably 5+ years of experience in SQL query development.
Extensive Hands on Experience in SQL Server Integration Services (SSIS)
Full understanding of the processes of data quality, data cleansing and data transformation
Full understanding of Extract Transform Load (ETL) concepts and technologies
Knowledge of Data Warehousing tools, patterns and processes
Experience Database design and well versed with SQL Server best practices
Experience working in a team-oriented and collaborative environment
Excellent Interpersonal, Written, and Verbal Communication Skills
Excellent Technical Documentation Skills
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 SQL Server 2008/2012
Experience in Netezza is a plus
Ability to present and deliver analytical/conceptual ideas in a professional manner
Ability to function, prioritize, and execute tasks in high-pressure altering environment
Ability to Self-Direct with keen attention to detail
Ability to Conceptually understand the direction for the organization's objectives and goals
Perform any other delegated duties considered appropriate in order to maintain the efficient running of the department
DB2 experience a plus
Other ETL tools a plus
Ability to work effectively in a dynamic team
A real passion for creating leading edge solutions to complex business problems
The ability to achieve a balance between the right technical and business solution
Flexible attitude, ability to perform under pressure.
A commitment to quality and a thorough approach to the work.
A 'can do' attitude.
The preceding job posting has been designed to indicate the general nature and level of work performed by employees assigned to this role. It is not intended to be interpreted as a comprehensive list of all duties, responsibilities and qualifications.
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 always have the ability to determine their application status by logging into our Career Portal.
Learn more about our culture by following us on social media: LinkedIn, Facebook, Instagram, Twitter: @CareerswithAN
American National is an Equal Opportunity Employer. We provide equal opportunity to all qualified individuals regardless of race, color, religion, age, gender, gender expression, national origin, veteran status, disability or any other legally protected categories.
Get Jobs Emailed to You
Sign up to receive new job alerts by email.
JOIN OUR TALENT COMMUNITY
"If you believe you can make a difference in the lives of our clients, if you're willing to work hard, if you want a fulfilling career, and if your values match ours, then I want you to work for American National. " James Pozzi, President and CEO.
Nearest Major Market: Springfield
Job Segment: Data Warehouse, Database, Social Media, SQL, Developer, Technology, Marketing