Facebook LinkedIn Twitter Email
Back to Jobs

Database Architect

Advantage Tech is looking for a Database Architect/Developer for our Kansas City client.  This is a role that you will be going into the office one day a week.  

Position Summary

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, repots and prediction models to meet an enterprise business analysis and reporting needs. This is a hybrid position that 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
  1. SQL development in SQL Server 2014 and above
    • SSRS reports in SQL Server 2014 and above
    • SSIS development in SQL Server 2014 and above
  1. Data integration and ETL solutions 
  2. PowerBI
  • Some idea (even theoretical) with prediction modeling using Microsoft Data Science tools
  • Design and Implementation of data strategy – 3+ years

 

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

 

Submit Resume