Open since Dec 2015
MS SQL Architect
AI Summary
Coordinates and manages data logistics for an interagency data warehouse, profiling data, defining linking rules, and developing program logic to link, load, and store data in an operational data store and data warehouse.
About this role
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.
Need Locals
Skills
Explore related jobs
More jobs at INTELLISWIFT INC
Similar MS SQL jobs
- S
Database Architecture with SQL Server Database ModelingSonsoft Inc · Austin, TX - AInternship in Avionics Systems - Database ArchitectureAirbus Defence and Space GmbH · Immenstaad am Bodensee, Germany
- S
Principal Database Engineer- Architecture/EngineeringSmartDrive Systems (India) Private Limited · Hyderabad - I
Software Developer IIidexcel · Milwaukee, WI - A
SQL DBA/Oracle DBAAtria Group LLC · Chicago, IL - A
DB/ETL specialistAccionLabs · Singapore, Singapore
Jobs in Saint Paul
- D
Delivery Driver(01912) - 975 Grand AveDomino's · Saint Paul, MN - D
Delivery Driver(01914) - 1231 Pierce Butler RouteDomino's · Saint Paul, MN - D
Delivery Driver(01944) - 2620 Rice StDomino's · Saint Paul, MN - D
Delivery Driver(01946) - 242 7th Street WDomino's · Saint Paul, MN - D
Delivery Driver(01910) - 2133 Old Hudson RdDomino's · Saint Paul, MN - D
Delivery Driver(01909) - 1517 White Bear Ave NDomino's · Saint Paul, MN
Browse these categories
Market data for this role
All reports →- SeriesRole reportsOne role family at a time: how many openings, what changed this week, who is hiring, what it pays.
- SeriesSalary reportsWhat employers publish in job postings, by level and workplace. Not self-reported pay.
- Market overviewState of tech hiring, September 2026: up 4.8%Tech hiring rose 4.8% month over month in September 2026, with 411,122 new listings. Customer support and account executive roles led the growth.