Data Architect / Developer
About The Position
Forrest T. Jones & Company, Inc. and its affiliates provide insurance and related services, including life and health insurance plans, financial services, and customized insurance products. The Data Warehouse Architect/Developer designs, develops, and implements data strategy to support data-centric business decisions. The role designs, develops, and maintains the data warehouse, dashboards, reports, and prediction models to meet enterprise business analysis and reporting needs, combining architecture and design with development skills. The position works with the Director of Application Development on enterprise data strategy and roadmap development. It integrates data from diverse sources into a data lake or warehouse for business intelligence, maintains warehouse structures and ETL processes, develops dashboards, and supports analytical and reporting requirements. The role also mentors team members, enforces departmental standards, and conducts design, documentation, and code reviews.
Requirements
- Bachelor’s degree in Computer Science or equivalent experience, plus Microsoft data-related certifications.
- At least 5 years of enterprise data warehouse development, integrations, dashboards, reporting, and analytics using Microsoft technologies.
- SQL development with SQL Server 2014 or later.
- SSRS report development with SQL Server 2014 or later.
- SSIS development with SQL Server 2014 or later.
- Experience with data integration and ETL solutions.
- Experience with Power BI.
- Some knowledge, including theoretical knowledge, of prediction modeling using Microsoft Data Science tools.
- At least 3 years of experience designing and implementing data strategy.
- At least 1 year of experience with APIs and web services.
- Some application development experience using C# and .NET.
Nice To Haves
- Experience with prediction modeling using Microsoft Data Science tools.
- Experience in the insurance industry.
- Experience with Azure Cloud.
- Azure data-related certifications.
- Experience with Agile development, especially using Azure DevOps.
- Understanding of accounting.
Responsibilities
- Work with the Director of Application Development to design enterprise data strategy.
- Integrate data from diverse sources into a data lake or warehouse 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.
- Mentor other team members.
- Design and develop dashboards.
- Understand and maintain knowledge of the data warehouse architecture, data structures, and fundamental design principles.
- Modify ETL data-load processes to extract, transform, and load data from various sources into the data warehouse.
- Analyze, define, and document system requirements for data, workflow, logical processes, system interfaces, auditing, reporting, and production configuration.
- Enforce departmental standards and procedures and review programmers’ documentation for conformity to standards.
- Conduct design, documentation, and code reviews.
Benefits
- Company-paid medical insurance.
- Company-paid short-term disability insurance.
- Company-paid long-term disability insurance.
- Company-paid life insurance.
- Voluntary dental insurance.
- Voluntary vision insurance.
- Voluntary life and AD&D insurance.
- 401(k) with company matching.
- Generous paid time off.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
