Home › Database Architect jobs in Kansas City, MO › Forrest T. Jones & Company
Data Architect / Developer
Forrest T. Jones & Company · Kansas City, Missouri · Posted October 29, 2026 (18 days ago)
- Kansas City, Missouri
- Full time
Job 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.
About the role
The Data Warehouse Architect/Developer is responsible for design, development, and implementation of data strategy for making data centric business decisions. They design, develop, and maintain our data warehouse, dashboards, reports and prediction models to meet an enterprise business analysis and reporting needs. This position requires both architecture/design as well as development skills.
Expectations
- Work with the Director of Application Development to design enterprise data strategy
- Integrate data from diverse sources into a Data Lake/Warehouse that could be used for business intelligence
- Work with the Director of Application Development to develop a roadmap
- Design, develop and modify relational and multidimensional database structures, relationships, data flows and data interfaces within the data warehouse as needed.
- Mentor other team members
- Design and develop dashboards
- Understand thoroughly the architecture, data structures, and fundamental design principles of the data warehouse
- Modify the data load ETL processes as needed to extract, transform, and load data from various data sources into the data warehouse.
- Analyze, define, and document system requirements for data, workflow, logical processes, interfaces with other systems, auditing, reporting requirements, and production configuration
- Enforces uniform adherence to established standards and procedures for the department. Reviews documentation submitted by programmers to ensure conformity to standards.
- Conduct design, documentation, and code review
Qualifications - Requisites
- Bachelor's degree in Computer Science or equivalent experience plus Microsoft Data related certifications
- Enterprise Data Warehouse Development, Integrations, Dashboard, Reporting, Analytics using Microsoft technologies – 5 + years
- SQL development in SQL Server 2014 and above
- SSRS reports in SQL Server 2014 and above
- SSIS development in SQL Server 2014 and above
- Data integration and ETL solutions
- PowerBI
- Some idea (even theoretical) with prediction modeling using Microsoft Data Science tools
- Design and implementation of data strategy - 3+ years
- APIs and Web services - 1+ years
- Some application development experience using C# and .NET
Qualifications – Pluses
- Experience with prediction modeling using Microsoft Data Science tools
- Experience with the Insurance industry
- Experience with Azure Cloud
- Azure Data-related certifications
- Experience with Agile Development, especially using Azure DevOps
- Experience with the Insurance industry
- Understanding of Accounting
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.
Posting 2439881402 on adp. Source: the employer’s listing. Valid through December 13, 2026 unless closed earlier.