Data Architect

Adaptive Solutions Group is a premier provider of information technology personnel. We provide a variety of technical professionals available for contract, contract to hire, or direct placement positions to companies in and around the Kansas City and St. Louis, areas.

We are currently looking for a Data Architect to join our team.

Responsibilities

This position will be responsible for designing and maintaining the data operations across multiple platforms, primarily Microsoft SQL. Tasked with the design and maintenance of the Data Warehouse that supports ETL processes, business analytics, and reporting.

The Data Architect collaborates with Business Intelligence and IT to support business objectives on a continuous basis.

Lead strategic oversight of all data assets including the Data Warehouse.

Collaborate with stakeholders and vendors to translate business requirements into technical specifications, including integrations, transformations, databases, and data warehouses.

Help scope project work, establish deadlines, and track progress.

Defines and manages the data architecture framework, standards, and principals including: modeling, metadata, security, and reference data.

Create and maintain varying forms of ETL implementations which include SSIS packages.

Manage and optimize daily data warehouse refresh schedules.

Develop and maintain appropriate departmental procedures to document processes, data models and data retention policies.

Proactive monitoring of database usage regarding health, performance, availability and utilization.

Observe the highest level of confidentiality and a data security first approach to all management and development activity.

Occasional after-hours availability as needed to support projects, maintenance tasks, and escalations.

Required Qualifications

Experienced in Microsoft SQL Server Business Intelligence features - SSIS,

SSRS/Power BI Reporting Server, and SSAS.

Skilled in Data Warehousing methodologies (Normalization Forms, ODS, SCD, Data Marts) and cloud-based technologies such as Azure SQL.

Ability to map, understand, and document complex data relationships.

Skilled in Visual Studio with the use of source control applications such as DevOps.

Skilled technical troubleshooting and problem-solving ability.

Self-starter with the ability to define clear objectives, collect appropriate information, and develop action plans.

Excellent interpersonal skills to include oral and written communications.

Ability to work independently without close supervision.

Ability to maintain a high level of confidentiality.

Adaptive Solutions Group offers a competitive compensation and benefits package that includes medical, dental, STD/LTD, life insurance coverage, 401k, paid vacation and holidays.

Adaptive Solutions Group is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, and veteran or disability status.