Forrest T. Jones & Company

Lead Data Platform Engineer

Forrest T. Jones & Company Kansas City, Missouri, United States

Insurance · 201-500 employees

Nov 10
Senior (5-10 yrs) Full-time United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

The Lead Data Platform Engineer is responsible for designing enterprise data strategies and creating centralized reporting across all business units. This role will oversee cloud migrations, optimize cloud resource utilization, and collaborate with cross-functional teams to deliver robust data solutions.

What they look for

Azure Data Factory Azure Pipelines Azure Logic Apps SQL Server Power BI ETL ELT Cloud migration Data architecture DevOps SQL SSRS SSIS Data modeling Technical documentation Mentorship

Requirements

Candidates must have a Bachelor's degree and at least 5 years of experience in Azure cloud resources and SQL development. Strong proficiency in Azure Data Factory, Power BI, and data integration methodologies is required.

Benefits

Medical insurance Short-term disability insurance Long-term disability insurance Life insurance Dental insurance Vision insurance 401(k) with company matching Paid time off

Full description

Forrest T. Jones & Company, Inc., and its affiliates (“FTJ”), provide insurance and insurance related services to clients, corporations, employers and individuals. These services include providing benefits through innovative life and health insurance plans, financial services, and customized insurance products for niche markets.

Position Summary

The Lead Data Platform Engineer is responsible for creating centralized reporting that encompasses all business units, as well as streamlining processes to develop and move new processes to Azure. This role will partner with other team members and business stakeholders to deliver cloud data solutions.

Expectations

  • Collaborate with the Data Architect to design enterprise data strategy
  • Create ELT/ELT processes to transform raw data into “gold” format, prepared for Power BI
  • Work with Power BI developers to ensure ETL/ELT processes are created and maintained
  • Oversee cloud migrations and ensure security best practices are implemented
  • Optimize cloud resource utilization and cost management strategies
  • Collaborate with DevOps, AI/ML, and security teams on cloud initiatives
  • Manage and optimize cloud costs and utilization
  • Migrate existing workloads from a local data center to the cloud.
  • Develop new applications that run in the cloud
  • Work across different teams to ensure road maps, documentation, and workflows are transparent and followed across different teams
  • Collaborate with DevOps teams to develop automated workflows, streamline deployments, and ensure infrastructure reliability Strong analytical and problem-solving skills
  • Lead cloud migration projects and modernization initiatives
  • Provide mentorship to junior engineers and participate in architectural reviews
  • Guide team members in cloud best practices and provide technical mentorship
  • Collaborate with stakeholders to align cloud initiatives with business objectives.
  • Stay up to date on the newest technologies and software.
  • Review and understand the current architecture for each line of business
  • Implement novel solutions to migrate legacy data to newer systems
  • Create and maintain technical documentation for cloud systems
  • Strong communication, presentation, and relationship management skills
  • Experience working in a team-oriented, collaborative environment
  • Ability to work with diverse teams
  • Ability to maintain confidentiality
  • Performs other related duties as assigned and required

Competencies

  • Experience creating solutions using tools such as Azure Data Factory, Azure Pipelines, and Azure Logic Apps
  • Skills and hands-on experience of the following• SQL Server Reporting Services (SSRS)
  • SQL Server Integration Services (SSIS)
  • Power BI
  • The ability to work accurately and diligently under pressure, on multiple projects within your project timeframes
  • Experience documenting and following specifications and challenging business logic where appropriate
  • Experience with the Insurance industry is a plus
  • Microsoft certifications related to SQL Server and Data are a plus

Requisites

  • Azure Data Factory – 3+ years
  • Azure ADO/ADF Pipelines – 3+ years
  • Azure Logic Apps – 2+ years
  • Bachelor’s Degree and 5+ work experience in Azure cloud resources
  • SQL development in SQL Server 2014 and above – 6+ years
  • Power BI – 2+ years
  • Developing data integration and ETL solutions – 3+ years
  • Great understanding of databases and data processing
  • General knowledge of SCRUM methodology
  • Good understanding of business requirements gathering and documentation

We offer comprehensive benefits to full-time employees including company-paid medical, STD, LTD and life insurance plus voluntary dental, vision, life/AD&D insurance, 401(k) with company matching, generous paid time off and much more.

We encourage applicants of all ages and experience, as we do not discriminate on the basis of an applicant’s age.

ALL OFFERS OF EMPLOYMENT ARE CONTINGENT UPON THE PASSING OF A DRUG SCREEN AND BACKGROUND CHECK.