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