Data Warehouse Developer

American National Springfield , MO 65802

Posted 4 weeks ago

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

Responsibilities:

  • 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 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

Qualifications:

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

Personal Characteristics:

  • 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.

Hiring Practices

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


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Pharmacy Technician Data Entry Springfield MO

Guardian Pharmacy

Posted Yesterday

VIEW JOBS 12/13/2019 12:00:00 AM 2020-03-12T00:00 Overview Guardian Pharmacy of Missouri is part of the Guardian Pharmacy Services network and prides itself on its customer service. Each team member plays an integral part in the success of the pharmacy. Job Objective: Evaluates/triages incoming fax prescriptions to ensure timely and accurate entry into pharmacy operations system. Routes incoming calls to appropriate department/individual. Receives, processes, and follows-up on all prescription requests. Attributes: * Work Ethic/Integrity – must possess intrinsic drive to excel coupled with values in line with company philosophy * Strategy and Planning – ability to think ahead, plan and manage time efficiently * Problem Solving – ability to analyze causes and solve problems at both a strategic and functional level * Team Oriented – ability to work effectively and collaboratively with all team members Responsibilities: * Perform all functions related to the preparation and dispensing of prescriptions and over the counter medications * Access, input, and retrieve information on the pharmacy computer system, and maintain and process medical records * Accurately enter prescriptions/orders and process refills in a timely manner to ensure orders are completed on time for delivery * Communicate professionally with nursing staff regularly to clarify orders * Evaluate/triage incoming faxed orders and prescriptions to ensure timely and accurate entry in pharmacy operations system * Courteously answer phone and provide customer service * Process prescriptions to appropriate third parties for payment * Resolve rejected claims and unbilled claims * Work collaboratively with other team members to ensure smooth workflow in order entry department * Other essential functions and duties may be assigned as needed Education: High School Diploma or GED Requirements: * Missouri Pharmacy Technician license * 3+ years of related experience as a pharmacy technician, preferably in LTC/Long Term Care, Hospital, Closed Door, Hospice, Behavioral Health, Retail, Mail-Order, or high-volume pharmacy * Advanced computer skills; pharmacy operations system experience preferred/required * Ability to work independently and deliver to deadlines * Ability to solve problems with minimal direction * Great attention to detail and accuracy * Ability to excel in a fast-paced, team-oriented environment working on multiple tasks simultaneously, while adhering to strict deadlines * Quality minded; motivated to seek out errors and inquire when something appears inaccurate Work Environment: 8 hour shift Ability to work flexible hours; hours of operation are subject to change based on the needs of the pharmacy Full-Time employees working 30+ hours per week are eligible to enroll in our comprehensive benefits package, which includes medical, dental, vision, short and long-term disability, life and supplemental life insurance, and PTO. All employees are eligible to enroll in our company matched 401(k) plan. Guardian Pharmacy Springfield MO

Data Warehouse Developer

American National