Data Analyst / Data Architect
Job Title: Senior SQL BI Developer / Data Analyst / Data ArchitectLocation: Open to all client hubs in USA and remote only if the candidate talents meets and exceeds requirementsWork Module: Hybrid - if located near a hub bank location 60% in officeDuration: 3+ Months contract with possible extensionInterviews -- 2 Teams interview requiredJob can be extended, the end date is TBDJob DescriptionCRA Data Architecture & Reporting (CDAR)Position SummaryThe 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.Key ResponsibilitiesData Architecture & DesignDesign 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 creationDocumentation on procedure creationSQL Server & Database EngineeringDesign, 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 IntegrationArchitect, develop, and maintain enterprise ETL solutions using SQL Server Integration Services (SSIS).Autosys experience with scheduling ETL jobsDesign 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 & AnalyticsDevelop 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.