Lead Data Platform Engineer

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.