Job Description
job summary:
The CRA Data Architect is responsible for the design, development, optimization, and governance of data solutions supporting Community Reinvestment Act (CRA) reporting and analytics. This role serves as the technical lead for the CDAR platform, overseeing enterprise data architecture, ETL processes, SQL Server environments, reporting solutions, and data integration strategies.
The ideal candidate possesses deep expertise in Microsoft SQL Server, SSIS, ETL architecture, and SSRS reporting development. This individual will partner with business stakeholders, analysts, developers, and technology teams to ensure high-quality, scalable, and compliant data solutions that support regulatory reporting, executive analytics, and operational decision-making.
The role requires strong problem-solving abilities, a passion for data architecture, and an understanding of enterprise data management practices within a highly regulated environment.
location: Minneapolis, Minnesota
job type: Contract
salary: $48.62 - 58.62 per hour
work hours: 9am to 5pm
education: Bachelors
responsibilities:
Data Architecture & Design
* Design and maintain enterprise data models supporting CRA reporting, regulatory compliance, and business analytics.
* Define data architecture standards, patterns, and best practices across the CDAR ecosystem.
* Analyze source systems and design scalable solutions for integrating new data assets.
* Establish data governance, lineage, metadata, and data quality frameworks.
* Lead architecture reviews and provide technical guidance on database and reporting initiatives.
* Kadince Software experience with data migration, import, export and report creation
* Documentation on procedure creation
SQL Server & Database Engineering
* Design, develop, and optimize Microsoft SQL Server and Azure SQL Managed Instance solutions.
* Create and maintain complex stored procedures, views, functions, and database objects.
* Perform performance tuning, indexing strategies, query optimization, and capacity planning.
* Support database upgrades, security controls, and disaster recovery planning.
* Ensure platform stability, availability, and compliance with enterprise technology standards.
* Rest API and Graph QL experience (data migration high recommended)
ETL & Data Integration
* Architect, develop, and maintain enterprise ETL solutions using SQL Server Integration Services (SSIS).
* Autosys experience with scheduling ETL jobs
* Design and optimize data ingestion processes integrating internal and external data sources.
* Build automated workflows supporting monthly, quarterly, and annual reporting cycles.
* Monitor data movement pipelines and implement controls to ensure data integrity and completeness.
* Partner with upstream and downstream application teams to resolve integration issues.
Reporting & Analytics
qualifications:
Develop and support SQL Server Reporting Services (SSRS) reporting solutions.
* Design scalable reporting architectures supporting regulatory, operational, and executive reporting needs.
* Collaborate with business partners to translate reporting requirements into technical solutions.
* Support report automation, distribution, and performance optimization.
skills:
Autosys,Data Architect,enterprise data architecture,data architecture,data governance,data quality frameworks,data ingestion,data integration,data integrity,data migration,data solutions,indexing strategies,database,disaster recovery,enterprise data management,ETL processes,ETL,ETL solutions,data movement,SQL Server,Microsoft SQL Server,performance tuning,query optimization,Rest API,Azure SQL,SSIS,SQL Server Integration Services,SSRS,SQL Server Reporting Services,stored procedures,reporting solutions,passion,strong problem-solving abilities,operational decision-making,architecture,architecture reviews,business analytics,capacity planning,Community Reinvestment Act,reporting development,report creation,Reporting & Analytics,scalable reporting,Database Engineering,governance,regulatory reporting,regulatory compliance,executive reporting,scheduling,security controls,design scalable solutions
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).
This posting is open for thirty (30) days.
Job Tags
Hourly pay, Contract work, Temporary work, Work experience placement