Job Listings

MarTech ETL Developer (Hybrid)

3700 S. Stonebridge Dr., McKinney, Texas
Job number: 15336

Job Description:

MarTech ETL Developer (Hybrid)

Primary Duties & Responsibilities

JOB SUMMARY:

This position reports to the MarTech AppDev Manager. The ETL Developer is responsible for analysis, design, development, maintenance, and support for various data applications within a data-centric marketing, customer journey, business intelligence, and/or advanced analytics group.

PRIMARY DUTIES & RESPONSIBILITIES:

Overall

  • Fosters positive relationships with customers, clients, co-workers, and supervisors
  • Works towards improvement of software development acumen in order to grow professionally
  • Mentors junior developers in order to advance overall team capabilities
  • Possesses solid analytical, logic, and software engineering skills to independently solve complex business and technical problems.
  • Offers creative problem-solving and process debugging abilities.
  • Willingness and ability to adopt enterprise-level software development patterns and practices.

Development

  • Participate in scoping, requirement and specification meetings and participate in design/solution reviews
  • Write well-structured, efficient, and maintainable database and backend code per SDLC guidelines
  • Ability to work well within a Scrum team and understand business and technical requirements
  • Facilitate the conversion of legacy software systems into cloud-based platforms
  • Leverage Microsoft SQL Server Integration Services and Informatica to design and develop solutions to integrate with Internal Applications, BI and Analytics Platforms, and Marketing Operations production environments
  • Leverage data quality prototypes and mappings to operationalize as production jobs
  • Work with technical leads, architects, subject matter experts, developers, technical support groups and test teams to deliver value-added processes
  • Design, prototype, develop, test, and document ETL components
  • Perform unit testing of ETL components and document testing results
  • Support all testing, including Development Integration Testing, System Testing, User Acceptance Testing, End-to-End Testing, and Nonfunctional Requirements Testing
  • Perform troubleshooting on ETL components
  • Supports the ongoing operation of data applications and scheduled jobs
  • Provides timely response and resolution of emergency production questions, issues and defects
  • Maintains and monitors job schedules

 

Required Skills

KNOWLEDGE, SKILLS, & ABILITIES

  • Strong technical and analytical skills
  • Experience with Security frameworks (e.g., JWT, OATH2), RESTful API service consumption
  • Basic understanding of PII information and handling
  • Excellent skills in writing, maintaining, testing, and debugging software systems
  • Experience supporting Marketing, Customer Journey, or Advanced Analytic operations
  • AWS Lambda and SQS experience is a plus
  • Experience with version control software such as Azure DevOps or TFS
  • COBOL is a plus

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: 

  • Bachelor’s degree in Computer Science, MIS, or Software Engineering
  • 3+ years of software development experience using an Object-Oriented Programming language, preferably in the Microsoft tech stack (.NET, C#)
  • 5+ years of experience implementing SQL Server objects such as tables, views, parameterized stored procedures, and functions
  • 5+ years of experience with SQL Server Integration Services (SSIS) and Informatica (IICS, IDQ)
  • Excellent written and verbal communication required
  • Experience developing and designing process flows, as well as writing requirements documents and user stories
  • Experience in researching and interpreting data, with a solid understanding of relational database concepts

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

Apply Now

Current employees apply here.

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

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

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

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