Sr. ETL Developer

6 days ago

McKinney, United States Globe Life Full time
Job Description:

Sr. ETL Developer (AWS) - Interoperability (Hybrid) 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 & RESPONSIBILITIES 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


#DICE

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 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, Event Bridge etc.
  • Good understanding of implementing data warehouse in Cloud.
  • Good to have ETL Development experience using Informatica IICS.
  • 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 and years of experience
  • Bachelor's degree in computer science/engineering, Information Systems, or equivalent work experience in a technical position.
  • 8+ years of experience in Information Technology.
  • 4+ years of experience in Database Engineering primarily in AWS RDS/Aurora/Redshift, DynamoDB, DMS, Glue.
  • 1-2 years of product management or related experience OR a strong track record of customer-centric thinking that indicates future success in this role.
  • 6+ years of experience with SQL and ETL


Required Competencies and Experience
  • 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
  • Hybrid (WFH/Remote - Monday and Friday) & (In Office - Tuesday thru Thursday)
  • Ability to work from the office or from home
  • Must be able to collaborate as required with teammates using tools such as Teams, Webex, Zoom, and others

  • Sr. ETL Developer

    1 month ago

    McKinney, United States Globe Life Inc. Full time

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

  • Sr. ETL Developer

    1 month ago

    McKinney, United States Globe Life Inc. Full time

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

  • Sr. ETL Developer – Interoperability

    1 month ago

    McKinney, United States Globe Life Inc. Full time

    Sr. ETL Developer – Interoperability (Hybrid) 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...

  • Sr. ETL Developer

    1 month ago

    McKinney, United States Globe Life Full time

    Sr. ETL Developer – Interoperability (Hybrid) 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,...

  • Sr. ETL Developer – Interoperability

    2 weeks ago

    McKinney, United States Globe Life Inc. Full time

    Sr. ETL Developer – Interoperability (Hybrid) 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...

  • Sr. ETL Developer

    1 week ago

    McKinney, United States Globe Life Inc. Full time

    Sr. ETL Developer (AWS) – Interoperability (Hybrid) 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...

  • Sr Java Fullstack Developer

    17 hours ago

    McKinney, United States GBIT (Global Bridge InfoTech Inc) Full time

    Sr Java Fullstack Developer - local to Dallas TX neededDIRECT CLIENT ROLEKey SkillsJava,Springboot and AngularWe are looking for a highly skilled Full Stack Developer with expertise in Java, Angular, Spring, and Spring Boot to join our dynamic team.The ideal candidate will have a strong technical background and be able to work collaboratively to develop,...

  • Sr Java Fullstack Developer

    4 hours ago

    McKinney, United States GBIT (Global Bridge InfoTech Inc) Full time

    Sr Java Fullstack Developer - local to Dallas TX neededDIRECT CLIENT ROLEKey SkillsJava,Springboot and AngularWe are looking for a highly skilled Full Stack Developer with expertise in Java, Angular, Spring, and Spring Boot to join our dynamic team.The ideal candidate will have a strong technical background and be able to work collaboratively to develop,...

  • Sr Business Intelligence Developer and Analyst ERP

    6 days ago

    McKinney, United States Globe Life Full time

    Sr Business Intelligence Developer and Analyst ERP (Hybrid)Primary Duties & ResponsibilitiesAt Globe Life, we are committed to empowering our employees with the support and opportunities they need to succeed at every stage of their career. Our thriving and dynamic community offers ample room for professional development, increased earning potential, and a...

  • Sr. Salesforce Developer

    2 weeks ago

    McKinney, United States Globe Life Inc. Full time

    Sr. Salesforce Developer (Hybrid) Primary Duties & Responsibilities At Globe Life, we are committed to empowering our employees with the support and opportunities they need to succeed at every stage of their career. Our thriving and dynamic community offers ample room for professional development, increased earning potential, and a secure work...

  • Sr BI Developer and Analyst

    1 week ago

    McKinney, United States Globe Life Inc. Full time

    At Globe Life, we are committed to empowering our employees with the support and opportunities they need to succeed at every stage of their career. Our thriving and dynamic community offers ample room for professional development, increased earning potential, and a secure work environment.We take pride in fostering a caring and innovative culture that...

  • Sr BI Developer and Analyst

    6 days ago

    McKinney, United States Globe Life Full time

    At Globe Life, we are committed to empowering our employees with the support and opportunities they need to succeed at every stage of their career. Our thriving and dynamic community offers ample room for professional development, increased earning potential, and a secure work environment.We take pride in fostering a caring and innovative culture that...

  • Sr Business Intelligence Analyst

    10 hours ago

    McKinney, United States Globe Life Inc. Full time

    Sr Business Intelligence Analyst (Hybrid) Primary Duties & Responsibilities At Globe Life, we are committed to empowering our employees with the support and opportunities they need to succeed at every stage of their career. Our thriving and dynamic community offers ample room for professional development, increased earning potential, and a secure...

  • Sr Data Modeler

    1 month ago

    McKinney, United States Globe Life Inc. Full time

    Sr Data Modeler (Hybrid) Primary Duties & Responsibilities At Globe Life, we are committed to empowering our employees with the support and opportunities they need to succeed at every stage of their career. Our thriving and dynamic community offers ample room for professional development, increased earning potential, and a secure work environment. We...

  • Sr Data Modeler

    1 week ago

    McKinney, United States Globe Life Inc. Full time

    Sr Data Modeler (Hybrid) Primary Duties & Responsibilities At Globe Life, we are committed to empowering our employees with the support and opportunities they need to succeed at every stage of their career. Our thriving and dynamic community offers ample room for professional development, increased earning potential, and a secure work environment. We...

  • Sr Data Modeler

    2 weeks ago

    McKinney, Texas, United States Globe Life Family of Companies Full time

    Job Description At Globe Life, we are committed to empowering our employees with the support and opportunities they need to succeed at every stage of their career. Our thriving and dynamic community offers ample room for professional development, increased earning potential, and a secure work environment. We take pride in fostering a caring and innovative...

  • Magento Developer/Architect

    2 days ago

    McKinney, United States GBIT (Global Bridge InfoTech Inc) Full time

    Role: Sr Magento/Ecommerce Engineer (FTE)Location: McKinney, TX (Onsite)Full Time positionPrimary Skills: AUTOMATION TOOLS, HTML, EMAIL MARKETING, JSON, CONTENT MANAGEMENT, CI/CD, CSS, SEM, WEB TECHNOLOGIES, AZURE, GRAPHQL, JIRA, ADOBE ANALYTICS, GOOGLE ANALYTICSJob Description: We are seeking an experienced Senior Application Engineer with a strong...

  • Magento Developer/Architect

    2 days ago

    McKinney, United States GBIT (Global Bridge InfoTech Inc) Full time

    Role: Sr Magento/Ecommerce Engineer (FTE)Location: McKinney, TX (Onsite)Full Time positionPrimary Skills: AUTOMATION TOOLS, HTML, EMAIL MARKETING, JSON, CONTENT MANAGEMENT, CI/CD, CSS, SEM, WEB TECHNOLOGIES, AZURE, GRAPHQL, JIRA, ADOBE ANALYTICS, GOOGLE ANALYTICSJob Description: We are seeking an experienced Senior Application Engineer with a strong...

  • Sr Data Modeler

    3 weeks ago

    McKinney, United States Globe Life Family of Companies Full time

    Job Description At Globe Life, we are committed to empowering our employees with the support and opportunities they need to succeed at every stage of their career. Our thriving and dynamic community offers ample room for professional development, increased earning potential, and a secure work environment. We take pride in fostering a caring and innovative...

  • Senior Dotnet Developer with Azure

    2 weeks ago

    McKinney, United States GBIT (Global Bridge InfoTech Inc) Full time

    Lead Dotnet Developer with AzureAzure Developer- full time opportunity with a client in McKinney TX (onsite). There is no visa sponsorship available for this role.2 roles open"Lead Azure DeveloperSr Azure DeveloperWe need resources from .net dev background and moved to Azure. Resource should be skilled in Azure Functions and .Net functions. Overall- resource...