Lead Data Platform Engineer

Forrest T. Jones & Company•Kansas City, MO

About The Position

The Lead Data Platform Engineer creates centralized reporting across all business units and streamlines processes for developing and moving workloads to Azure. The role partners with team members and business stakeholders to deliver cloud data solutions, lead migrations and modernization, and align cloud initiatives with business objectives. The engineer collaborates on enterprise data strategy, creates and maintains data transformation and integration processes, and works with Power BI developers to prepare data for reporting. The role also supports cloud security, resource and cost optimization, application development, DevOps automation, technical documentation, and infrastructure reliability. It includes reviewing existing architectures, migrating legacy data, mentoring junior engineers, participating in architectural reviews, and keeping current with technologies and software.

Requirements

At least 3 years of experience with Azure Data Factory.
At least 3 years of experience with Azure ADO/ADF Pipelines.
At least 2 years of experience with Azure Logic Apps.
Bachelor’s degree and at least 5 years of work experience in Azure cloud resources.
At least 6 years of SQL development experience with SQL Server 2014 or later.
At least 2 years of Power BI experience.
At least 3 years of experience developing data integration and ETL solutions.
Strong understanding of databases and data processing.
General knowledge of SCRUM methodology.
Understanding of business requirements gathering and documentation.
Hands-on experience with SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and Power BI.
Ability to work accurately and diligently under pressure on multiple projects within project timeframes.
Experience documenting and following specifications and challenging business logic when appropriate.
Strong analytical and problem-solving skills.
Strong communication, presentation, and relationship-management skills.
Experience working in a team-oriented, collaborative environment and ability to work with diverse teams.
Ability to maintain confidentiality.

Nice To Haves

Experience in the insurance industry.
Microsoft certifications related to SQL Server and Data.

Responsibilities

Collaborate with the Data Architect to design enterprise data strategy.
Create ELT/ETL processes that transform raw data into a gold format prepared for Power BI.
Work with Power BI developers to ensure ETL/ELT processes are created and maintained.
Oversee cloud migrations and implement security best practices.
Optimize cloud resource utilization and cost management.
Collaborate with DevOps, AI/ML, and security teams on cloud initiatives.
Migrate existing workloads from a local data center to the cloud and develop new cloud applications.
Coordinate across teams to ensure road maps, documentation, and workflows are transparent and followed.
Work with DevOps teams to automate workflows, streamline deployments, and ensure infrastructure reliability.
Lead cloud migration projects and modernization initiatives.
Mentor junior engineers and guide team members in cloud best practices.
Participate in architectural reviews.
Collaborate with stakeholders to align cloud initiatives with business objectives.
Stay current on new technologies and software.
Review and understand the current architecture for each line of business.
Implement solutions to migrate legacy data to newer systems.
Create and maintain technical documentation for cloud systems.
Perform other related duties as assigned and required.