MS SQL Architect

Reposted One Month Ago
Be an Early Applicant
Saint Paul, MN, USA
In-Office
Senior level
Information Technology • Software • Big Data Analytics
The Role
The role involves enhancing and maintaining an interagency data warehouse, managing data logistics, conducting data profiling, defining data linking rules, and developing database architecture.
Summary Generated by Built In
Job Description

Job Role: Job Role: Senior Business Analyst

Location: Saint Paul, MN

Duration: 6 Months+

Enhance and maintain an interagency data warehouse. The interagency warehouse contains anonymized unit record data for individuals from birth to workforce employment that will support education research.


Project Deliverables

• Coordinate and manage data set “logistics” (e.g. issues, access to data, coordination of subject matter experts, etc.).

• Conduct data profiling, using MN P20W standards practices to iteratively work with the data provider to define, document, and clean the data.

• Define the data linking rules to be exercised on the personally identifying information available in each data set. Use this definition to evaluate existing data linking rules and integrate the new data set in a way that maintains or improves the quality of data linking results.

• Develop the program logic to link and load each data set into the operational data store (ODS).

• Create the database architecture required to support the linking, loading, and storage of the new data in the ODS, consistent with the existing architecture.

• Create and populate a data warehouse from the ODS.

• Evaluate and possibly refine the data operations to accommodate the data frequency and business needs.

Additional Information

Need Locals

Skills Required

  • Experience with data warehousing and database architecture
  • Ability to coordinate and manage data logistics
  • Familiarity with MN P20W standards

Intelliswift Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Intelliswift and has not been reviewed or approved by Intelliswift.

  • Fair & Transparent Compensation — Pay is considered okay to good, with some technical roles (e.g., QA/engineering) seen as market‑aligned and showing stronger sentiment by role and geography. Feedback suggests perceptions of fairness are stronger in U.S. contexts than India‑focused data.
  • Career-Linked Recognition & Rewards — Recognition and rewards programs are highlighted alongside competitive pay and learning and development. Feedback suggests these elements are positioned as part of the total rewards offering.
  • Wellbeing & Lifestyle Benefits — An Employee Assistance Program and wellness reimbursement are called out among company‑listed perks. Flexible work environments are also emphasized as part of the overall benefits narrative.

Intelliswift Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Santa Clara, CA
1,411 Employees
Year Founded: 2001

What We Do

What do we do? Intelliswift delivers world-class Product Engineering, Data Management and Analytics, Digital Enterprise, Digital Integration, Salesforce, and Talent Solutions to businesses across the globe. We empower companies to embrace new technologies and strategies along their digital transformation journey through data-rich modern platforms, innovation-led engineering, and people-centric solutions. Strong customer-centricity makes us a trusted ally to several Fortune 500 companies, SMBs, ISVs, and fast-growing startups. To whom do we cater? Industries: Technology, Media, Telecom, Pharma, Healthcare, Banking, Financial Services & Insurance, Retail. Where are we headed? We are driven to leverage our innovation and deep expertise to create a long-lasting impact for our customers and stakeholders. What drives us? • We believe in delivering sustainable and future-driven solutions. • We believe in enabling everyone that works with us – from clients to partners to employees. • We believe that the future belongs to those who Love the New – which is why we are constantly reinventing and innovating NEW solutions to enable businesses to stay ahead of the competition.

Similar Jobs

Cox Enterprises Logo Cox Enterprises

Technical Customer Care Specialist II (HomeNet)

Artificial Intelligence • Automotive • Greentech • Information Technology • Machine Learning • Software • Cybersecurity
Remote or Hybrid
United States
30000 Employees
20-30 Hourly

BAE Systems, Inc. Logo BAE Systems, Inc.

Engineering Planning Specialist II

Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
Hybrid
Maple Grove, MN, USA
40000 Employees
67K-115K Annually

Samsara Logo Samsara

Senior Product Manager

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
United States
4000 Employees
131K-220K Annually

The Aerospace Corporation Logo The Aerospace Corporation

Senior R&D Navigation Analyst

Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Hybrid
2 Locations
4600 Employees
137K-197K Annually

Similar Companies Hiring

Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees
Revel Thumbnail
Aerospace • Hardware • Robotics • Software
Marina Del Rey, California
60 Employees
Blee Thumbnail
Artificial Intelligence • Marketing Tech • Software
New York, New York
30 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account