Employment Services

We help you find the correct IT placement

Data Architect

Overland Park, KS 66211 | Fully Remote

Posted: 04/09/2024 Employment Type: Direct Placement Job Category: Database Technologies Job Number: 16524

Job Description

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.

  • 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.

Job Requirements

Data Warehouse ETL SQL

Meet Your Recruiter

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

About Overland Park, KS

Unlock exciting career opportunities in the vibrant area surrounding Overland Park, Kansas! This thriving region, part of the greater Kansas City metropolitan area, offers a delightful blend of urban amenities and natural beauty. From the renowned Nelson-Atkins Museum of Art to the lively Power & Light District, and the iconic Kauffman Stadium where the Kansas City Royals play, there is no shortage of enriching experiences to enjoy. With its famous barbecue cuisine and welcoming community spirit, Overland Park is a place where both your career and quality of life can flourish. Explore our job listings today and set your sights on a fulfilling career in this charming and dynamic location!