Senior Solution Architect - Now Hiring

Chicago 9 days agoFull-time External
Negotiable
Date Posted: 10/02/2025 Hiring Organization: Rose International Position Number: 489443 Industry: Financial Services Job Title: Senior Solution Architect Job Location: Chicago, IL, USA, 60604 Work Model: Onsite Employment Type: Temporary FT/PT: Full-Time Estimated Duration (In months): 7 Min Hourly Rate ($): 64.90 Max Hourly Rate ($): 71.42 Must Have Skills/Attributes: Airflow, Apache, Data Architecture, Databricks, Oracle, Snowflake Experience Desired : Experience in data architecture or solution architecture (7+ yrs); Experience designing data architecture on Oracle, Databricks, and Snowflake (7+ yrs); Experience with modern data orchestration and Apache, Airflow or Iceberg (7+ yrs); Experience integrating diverse data sources and designing robust data models (7+ yrs); Experience with BCBS 239 principles for risk data agrregation and reporting? (7+ yrs); Experience in implementing data lineage solutions and managing critical data elements (7+ yrs) Required Minimum Education: Bachelor’s Degree • *C2C is not available** Job Description Required Education: • Bachelor's degree in computer science, Information Technology, or a related field, or equivalent professional experience. Required Qualifications: • In-depth knowledge of data architecture principles, data modeling techniques (including dimensional modeling for regulatory reporting), and data governance frameworks compliant with BCBS 239. • 7+ years of experience in data architecture or solution architecture, with a proven track record of designing and delivering large-scale data platforms. • Deep expertise in designing data architectures on Oracle, Databricks, and Snowflake, considering performance optimization and scalability requirements for financial data. • Extensive experience with modern data orchestration and storage frameworks, such as Apache Airflow and Iceberg. • Proven ability to integrate diverse data sources and design robust data models to support business intelligence, reporting, and regulatory reporting specifically for financial risk (RDARR). • Strong understanding and direct experience with BCBS 239 principles for risk data aggregation and reporting, including governance, data quality, timeliness, and adaptability. • Hands-on experience in implementing data lineage solutions and managing critical data elements within a financial services context • Strong communication and presentation skills, with the ability to convey complex technical concepts and strategy, including regulatory requirements related to data, to both technical and executive-level stakeholders. • Expertise in data warehousing and ETL/ELT patterns, particularly within a financial risk context. • Relevant industry certifications (e.g., cloud platform architect certification) or certifications related to data management and governance are highly valued. Job Duties: • Lead the architectural strategy, design, and governance of the enterprise data ecosystem, driving the modernization and consolidation of data platforms to support business intelligence, advanced analytics, and regulatory reporting. • This includes a critical focus on Risk Data Aggregation and Risk Reporting (RDARR), ensuring compliance with BCBS 239 principles. • Provide strategic vision for data architecture, platforms, and governance, translating business objectives into effective, scalable, and secure technical solutions. • Lead the end-to-end design of complex data solutions, including data warehousing, data modeling, and reporting infrastructure, with a critical emphasis on RDARR capabilities. • Serve as a subject matter expert for data technologies and regulatory requirements, guiding the selection and implementation of platforms such as Databricks and Snowflake to meet BCBS 239 standards. • Govern architectural standards and best practices, ensuring all data initiatives align with the long-term data strategy, overall enterprise architecture, and BCBS 239 principles. • Establish and enforce data lineage protocols, with a focus on Critical Data Elements (CDEs), to ensure traceability, accuracy, and completeness for risk reporting. • Mentor and guide data engineering and BI teams, providing architectural oversight throughout the solution delivery lifecycle, particularly for RDARR implementation and data governance. • Lead technical workshops to capture business and technical requirements, particularly those related to risk data aggregation and reporting, translating them into architectural designs. • Create and document architectural designs, roadmaps, and technical specifications for data platforms and solutions, ensuring alignment with BCBS 239 principles. • Define and implement data lineage strategies to provide a clear, traceable record of how critical data elements are sourced, transformed, and aggregated for regulatory reports. • Provide architectural governance, reviewing solution designs and implementation plans from data engineering and BI teams to ensure data accuracy, completeness, and timeliness for risk reporting. • Advise on data governance, security standards, and data models to ensure a high-quality, long-term data landscape, including data lineage and transparency required by BCBS 239. • Perform technical evaluations of new data technologies and features, building proof-of-concepts to validate architectural approaches, especially for enhancing RDARR capabilities. • Collaborate with business stakeholders, risk management, and compliance teams to define data strategy and ensure alignment with BCBS 239 and RDARR requirements. • Serve as the key technical liaison between the engineering teams and executive leadership, presenting architectural decisions and roadmap updates, including compliance progress. • *Only those lawfully authorized to work in the designated country associated with the position will be considered. ** • *Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements. ** Benefits: For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website. California Pay Equity: For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here. Date Posted: 10/02/2025 Hiring Organization: Rose International Position Number: 489443 Industry: Financial Services Job Title: Senior Solution Architect Job Location: Chicago, IL, USA, 60604 Work Model: Onsite Employment Type: Temporary FT/PT: Full-Time Estimated Duration (In months): 7 Min Hourly Rate ($): 64.90 Max Hourly Rate ($): 71.42 Must Have Skills/Attributes: Airflow, Apache, Data Architecture, Databricks, Oracle, Snowflake Experience Desired : Experience in data architecture or solution architecture (7+ yrs); Experience designing data architecture on Oracle, Databricks, and Snowflake (7+ yrs); Experience with modern data orchestration and Apache, Airflow or Iceberg (7+ yrs); Experience integrating diverse data sources and designing robust data models (7+ yrs); Experience with BCBS 239 principles for risk data agrregation and reporting? (7+ yrs); Experience in implementing data lineage solutions and managing critical data elements (7+ yrs) Required Minimum Education: Bachelor’s Degree • *C2C is not available** Job Description Required Education: • Bachelor's degree in computer science, Information Technology, or a related field, or equivalent professional experience. Required Qualifications: • In-depth knowledge of data architecture principles, data modeling techniques (including dimensional modeling for regulatory reporting), and data governance frameworks compliant with BCBS 239. • 7+ years of experience in data architecture or solution architecture, with a proven track record of designing and delivering large-scale data platforms. • Deep expertise in designing data architectures on Oracle, Databricks, and Snowflake, considering performance optimization and scalability requirements for financial data. • Extensive experience with modern data orchestration and storage frameworks, such as Apache Airflow and Iceberg. • Proven ability to integrate diverse data sources and design robust data models to support business intelligence, reporting, and regulatory reporting specifically for financial risk (RDARR). • Strong understanding and direct experience with BCBS 239 principles for risk data aggregation and reporting, including governance, data quality, timeliness, and adaptability. • Hands-on experience in implementing data lineage solutions and managing critical data elements within a financial services context • Strong communication and presentation skills, with the ability to convey complex technical concepts and strategy, including regulatory requirements related to data, to both technical and executive-level stakeholders. • Expertise in data warehousing and ETL/ELT patterns, particularly within a financial risk context. • Relevant industry certifications (e.g., cloud platform architect certification) or certifications related to data management and governance are highly valued. Job Duties: • Lead the architectural strategy, design, and governance of the enterprise data ecosystem, driving the modernization and consolidation of data platforms to support business intelligence, advanced analytics, and regulatory reporting. • This includes a critical focus on Risk Data Aggregation and Risk Reporting (RDARR), ensuring compliance with BCBS 239 principles. • Provide strategic vision for data architecture, platforms, and governance, translating business objectives into effective, scalable, and secure technical solutions. • Lead the end-to-end design of complex data solutions, including data warehousing, data modeling, and reporting infrastructure, with a critical emphasis on RDARR capabilities. • Serve as a subject matter expert for data technologies and regulatory requirements, guiding the selection and implementation of platforms such as Databricks and Snowflake to meet BCBS 239 standards. • Govern architectural standards and best practices, ensuring all data initiatives align with the long-term data strategy, overall enterprise architecture, and BCBS 239 principles. • Establish and enforce data lineage protocols, with a focus on Critical Data Elements (CDEs), to ensure traceability, accuracy, and completeness for risk reporting. • Mentor and guide data engineering and BI teams, providing architectural oversight throughout the solution delivery lifecycle, particularly for RDARR implementation and data governance. • Lead technical workshops to capture business and technical requirements, particularly those related to risk data aggregation and reporting, translating them into architectural designs. • Create and document architectural designs, roadmaps, and technical specifications for data platforms and solutions, ensuring alignment with BCBS 239 principles. • Define and implement data lineage strategies to provide a clear, traceable record of how critical data elements are sourced, transformed, and aggregated for regulatory reports. • Provide architectural governance, reviewing solution designs and implementation plans from data engineering and BI teams to ensure data accuracy, completeness, and timeliness for risk reporting. • Advise on data governance, security standards, and data models to ensure a high-quality, long-term data landscape, including data lineage and transparency required by BCBS 239. • Perform technical evaluations of new data technologies and features, building proof-of-concepts to validate architectural approaches, especially for enhancing RDARR capabilities. • Collaborate with business stakeholders, risk management, and compliance teams to define data strategy and ensure alignment with BCBS 239 and RDARR requirements. • Serve as the key technical liaison between the engineering teams and executive leadership, presenting architectural decisions and roadmap updates, including compliance progress. • *Only those lawfully authorized to work in the designated country associated with the position will be considered. ** • *Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements. ** Benefits: For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website. California Pay Equity: For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.