Overview
On Site
USD 64.90 per hour
Full Time
Skills
Recruiting
Apache HTTP Server
Computer Science
Information Technology
Dimensional Modeling
Solution Architecture
Oracle
Performance Tuning
Scalability
Orchestration
Storage
Apache Airflow
Data Quality
Adaptability
Management
Financial Services
Communication
Extract
Transform
Load
ELT
Finance
Cloud Computing
Data Management
Advanced Analytics
Regulatory Reporting
Data Architecture
Data Warehouse
Data Modeling
Databricks
Snow Flake Schema
Enterprise Architecture
FOCUS
Mentorship
Specification Gathering
Data Engineering
Business Intelligence
Reporting
Data Governance
Collaboration
Risk Management
Leadership
Presentations
Roadmaps
Regulatory Compliance
Job Details
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.
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.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).
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.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.