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.
Skills Required
- Azure Data Factory experience
- Azure ADO/ADF Pipelines experience
- Azure Logic Apps experience
- Bachelor's degree
- Five or more years of experience with Azure cloud resources
- Six or more years of SQL development using SQL Server 2014 or newer
- Power BI experience
- Experience developing data integration and ETL solutions
- Strong understanding of databases and data processing
- General knowledge of Scrum methodology
- Business requirements gathering and documentation experience
- Experience with SQL Server Reporting Services and SQL Server Integration Services
- Microsoft certifications related to SQL Server and data
- Insurance industry experience
What We Do
Forrest T. Jones & Company (FTJ) is an insurance agency and administrator that was established in 1953 to provide insurance products and other financial services to members of associations and other affinity groups. FTJ currently provides insurance programs to more than 80 national associations and employer groups with more than 1.5 million members. We work with more than 30 of the nation’s leading insurance companies to provide members / employees with access to high quality insurance plans—many with special features and benefits not readily available elsewhere—at favorable group rates. As the flagship of an enterprise that includes two life insurance companies, a reinsurance company, and a FINRA broker/dealer, FTJ offers an exceptional level of strength and flexibility for our association and affinity group clients. Throughout the years, FTJ has worked hand-in-hand with its clients in adding value to member and customer programs through quality insurance products. FTJ has been family owned and managed since its inception, and we pride ourselves on maintaining close, personal relationships with our clients. We strive to meet their needs in a dynamic environment by applying the latest technology, marketing expertise, and our relationships in the insurance industry to attain the best possible insurance plans for their members and support those plans with old-fashioned, high-touch personal service. The company is headquartered in Kansas City, Missouri.
.png){kind=logo}
