Senior Data Warehouse Architect - MS SQL

INTELLISWIFT INC; Saint Paul (MN); On-site; USD 80,000 - 95,000; Full time

Job summary

A technology consulting firm is seeking a Senior Business Analyst in Saint Paul, MN, for a 6-month project to enhance and maintain an interagency data warehouse used for educational research. The successful candidate will manage data logistics, conduct data profiling, define data linking rules, and develop database architecture. Strong experience in data management and integration is essential for this impactful role supporting workforce employment data.

Qualifications

• Proven experience in managing data logistics and coordination.
• Ability to conduct rigorous data profiling and cleaning.
• Experience with data linking and integrating new data sets.

Responsibilities

• Coordinate and manage data set logistics and access issues.
• Conduct data profiling per MN P20W standards.
• Define data linking rules to improve quality.
• Develop program logic to link and load data.
• Create database architecture for new data storage.

Skills

Data management

Data profiling

Database architecture

Data integration

Job description

A technology consulting firm is seeking a Senior Business Analyst in Saint Paul, MN, for a 6-month project to enhance and maintain an interagency data warehouse used for educational research. The successful candidate will manage data logistics, conduct data profiling, define data linking rules, and develop database architecture. Strong experience in data management and integration is essential for this impactful role supporting workforce employment data.