Sr. ETL Developer at Globe Life Inc. in McKinney, Texas

Job Description:

Job Description:



Sr. ETL Developer


Primary Duties & Responsibilities



JOB SUMMARY:


Experience what being part of the Globe Life family feels like. Be inspired by your leaders, encouraged, and cheered on by your teammates to excel and be supported in your career while working with us. We offer a competitive salary with a great benefits package, including 401(K) match, medical, dental, and vision health plans, short - term and long-term disability, paid time off, tuition reimbursement and other career development opportunities.

The Sr. ETL Developer is responsible for analysis, design, development, maintenance and support for various data applications. The person in this role must understand business requirements and translate them into detailed technical documents that will serve as the blueprint for ETL Developers and other knowledge workers. The Sr. ETL Developer is likely to be tasked with the creation of key software components and is likely to work directly with various groups within the company to architect and build proof of concept modules that can later be incorporated into solutions or built out as needed to perform various business processes. The Sr. ETL Developer will perform code reviews and provide guidance to team members.


PRIMARY DUTIES & REPONSIBILITIES:




Application Development


• Perform key tasks within the SDLC including gathering requirements, creating technical design documents, developing code, leading code reviews, performing testing and implementation support

• Create and refine technical documents that will guide the developers as they build code

• Design, prototype, develop, and document ETL components

• Perform code reviews, document issues and communicate action items

• Assist with project planning and scheduling

• Work with technical leads, other Sr. ETL Developers, system architects, subject matter experts, product owners, project managers, developers, technical support groups and test teams to deliver value to the business

• Build ETL components that meet the functional requirements of the business, within established budget, while meeting time and quality standards

• Perform unit testing of ETL components and document test results

• Support all testing activities including Development Integration Testing, System Testing, User Acceptance Testing, End-to-End Testing and Performance Testing

• Document processes within operational runbooks

• Participate in code reviews and documentation reviews for ETL components

• Support and verify code implementations

• Create schema and data modification scripts as required

• Perform troubleshooting support on ETL components



Production Support


• Supports the operations of existing applications

• When on call, provides timely response and resolution of emergency production questions, issues and defects

• Adheres to a production support process



Application Maintenance


• Works on periodic maintenance releases of applications, including enhancements and defects

• Looks for ways to enhance design of application for better maintainability and software reuse

• Looks for ways to incrementally improve the architecture of legacy systems



Business Alignment


• Involves users in the development/maintenance of applications (e.g., requirements, testing)

• Understands how users use their applications

• Anticipates users' future needs when architecting solutions



Required Skills



KNOWLEDGE, SKILLS, & ABILITIES:



Required Skills

• Highly organized and able to efficiently coordinate multiple tasks
• Self-starter and able to deliver on your assignments on-time
• Excellent communication skills
• Ability to create detailed technical design specifications that when the software is developed it will meet the business requirements
• Willingness to guide and mentor others
• Strong ETL Development experience using ETL tools including Informatica PowerCenter and Informatica IICS
• Strong Hands on Experience with complex SQL and relational databases like SQL Server, MySQL and Postgres
• Excellent skills in writing, maintaining, testing and debugging code in T-SQL
• Hands-on experience including design and implementation across broad range services on Amazon Web Services (AWS).
• Experience with migrating RDBMS (SQL Server/Oracle) from On-prem to AWS (Aurora/Redshift).
• Solid understanding of various Data Management and Data Pipeline tools available in AWS.
• Working knowledge with primary AWS Services like S3, Lambda, Batch, Glue, Athena, EC2, EBS, CloudWatch, CloudTrail, ECS, ECR, EMR, IAM, SNS etc.mm
• Good understanding of implementing data warehouse in Cloud.
• Able to develop and deliver quality code while meeting deadlines
• Excellent data analysis abilities
• Possess great attention to detail while also being flexible to adapt to a dynamic environment and changing priorities

Managing Work

• Manages workload to deliver quality deliverables that meet requirements and timelines
• Communicates status of assignments to Manager
• Notifies Manager of issues that impact productivity or ability to meet expectations
• Assists Manager in tracking progress, prioritizing work, developing time estimates and work plans and assisting less experienced team members
• Resolves issues or escalates to Manager, if necessary
• Checks work in to central repositories

Managing Employees/SME Work

• Reports to the Application Development Manager and/or Project Manager
• 
  No direct reports
  
• Coaches less experienced teammates
• Creates documentation to aid in others' learning
• If applicable, provides project supervision and ensures quality and timeliness of others' deliverables

Applicable to all employees of Globe Life & Accident and its subsidiaries:

• Reliable and predictable attendance of your assigned shift
• Ability to work full time and/or part time based on the position specifications.

Required Knowledge & Experience



EDUCATION & WORK EXPERIENCE REQUIRED:



Education

• Bachelor's degree in Computer Science or Business Administration

Required Competencies and Experience

• 5+ years of experience with SQL and ETL.
• Create technical documentation
• Perform code reviews and provide feedback
• Motivated, organized self-starter who can meet commitments
• Ability to mentor others
• Develop, maintain, and support company's ETL processes and documentation
• Demonstrate clear, concise, accurate, and timely communication to management, peers, and customers; in written and oral form
• Follows established standards regarding coding and naming practice
• Possess a very good understanding of Life Insurance industry
• Follow established team, program and product policies and procedures
• Demonstrated high level of attention to detail, professional attitude and ability to consistently produce a quality product

Hybrid Working Conditions

• 
  
  Onsite or Hybrid (WFH/Remote - Monday and Friday) & (In Office - Tuesday thru Thursday)
• Must be able to collaborate as required with teammates using tools such as Webex, Zoom and others

Location: 3700 S. Stonebridge Dr., McKinney, Texas

Apply Now Current employees
apply here.



Featured Categories



Agent Careers


Accounting


Customer Care


Operations


Marketing


Technology


Legal


Human Resources


Clerical & Admin


Our Benefits


Savings and Investment Plan (401K) - Eligible employees may begin participating in the plan on the first day of employment.


Pension Plan - Eligible employees who complete one year of service with the Company become participants in the Pension.* (Not available to Cleveland Employees)


Medical - Benefits are available to all eligible employees and qualified dependents the first of the month following 30 days of continuous service.


Dental** and Vision - Eligible employees and qualified dependents are able to enroll the first of the month following 30 days of continuous service.


Flexible Spending Accounts (FSA) - Our FSA has two components, Health Care and Dependent Care Accounts. These accounts allow employees to set aside a portion of their earnings on a pre-tax basis to cover out-of-pocket medical and dependent care expenses. Participation is elected on a calendar year basis and is available to all eligible employees the first of the month following the completion of 30 days of continuous service.


Health Savings Accounts (HSA) - A pre-tax Health Spending Account (HSA) is offered to those who enroll in the High Deductible Plan. It allows you to pay for health care expenses. Participation is elected on a calendar year basis and is available to all eligible employees the first of the month following the completion of 30 days of continuous service. Company contributes to HSA.


Short-Term Disability - Eligible employees may be entitled to salary continuance during periods of temporary disability. Benefits are based on employee status and years of service.*


Group Life and Long-Term Disability** - Eligible employees may elect life insurance and long-term disability coverage the first of the month following 30 days of continuous service.


Vacation and Paid Holidays - Employees are eligible for vacation upon the completion of six months of employment. In addition, the Company offers eight paid holidays.


Education Assistance - The Company supports employees who wish to continue their education to secure increased responsibility and growth within their professional careers. We offer a reimbursement program for expenses incurred through approved institutions of learning. In addition, Fellow, Life Management Institute (FLMI) and International Claim Association (ICA) program courses are offered after the completion of six months of services at no cost to the employee.


Fitness Reimbursement - Eligible employees are able to receive up to 100% reimbursement for monthly dues (employee only).


Supplemental Plans** - Cancer, Heart/Stroke, Accident.

*Please note, some benefits may vary by subsidiary. Please be sure to clarify with the Human Resources Department. **Company paid benefit


FAQ


Do I have to apply for every job that I am interested in? - Yes. Though our Talent Acquisition Team searches our database for qualified candidates, the only way to ensure that we know what position is of interest to you is if you apply for it directly.


Now that I've applied, what happens? - You will receive an immediate response from our system. Someone from our Talent Acquisition Team will review your qualifications and skills. If you're a good fit, we'll contact you to conduct an initial interview by phone, followed by assessment testing and an in person interview(s).


How do I get the contact information of the hiring manager for the job I am interested in? - It is our policy not to give contact information to external applicants. If, after you apply, it is determined that your skills and qualifications match our hiring needs, you will be contacted directly for an interview by someone on our Talent Acquisition Team.


I've been interviewed, what's next? - If selected, we'll extend a conditional offer. Then, pending a successful background check and drug screen, we'll confirm a start date.



The Whole Globe


Not only is it in our name, it's in our hearts. Our Company thrives off of diversity and has created a culture focused on inclusivity. These two components are the pillars of our foundation and the guiding principles that build our employees and leaders.



No Ceiling


The insurance industry may be traditional, but Globe Life has been, is, and always will be dedicated to building an inclusive, sustainable, and inspiring environment that does not have a ceiling on growth.


Globe Life Inc. is committed to helping families make tomorrow better. That's why more people choose life insurance from Globe Life than any other insurance provider, according to S&P Global Market Intelligence. A.M. Best Company, an independent insurance analyst since 1899, awarded Globe Life an A (Excellent) rating (as of 8/23) based on their latest analysis of financial strength, management skills and integrity. For the latest rating, access www.ambest.com.


copyright ©2024. Globe Life Inc. All Rights Reserved.


Enable Accessibility View


Accessibility | Privacy | Terms of Use | Fraud Alert | COVID-19 FAQ Apply Now