Solutions Architect

RCM Technologies, Inc.; United States; Hybrid; USD 79,556 - 113,307; Full time

Job summary

A leading technology solutions firm is seeking an experienced Solutions Architect to lead the architecture and delivery of enterprise ETL and data integration solutions. The role involves hands-on technical expertise alongside team leadership in a hybrid work setting. Candidates should have over 7 years of experience in ETL and data integration, strong skills in Snowflake and Matillion, and the ability to mentor teams. Competitive compensation up to $70/hr is offered.

Qualifications

• 7+ years of experience in ETL, data engineering, and data integration.
• Proven experience leading or mentoring a team.
• Strong hands-on experience with Snowflake, Matillion, and/or Fivetran.
• Extensive experience designing and building API-based data pipelines.
• Experience working in regulated, financial, or banking environments preferred.

Responsibilities

• Lead the architecture, design, and implementation of enterprise ETL and data integration solutions.
• Review and interpret data and ETL requirements with DBAs and Data Architects.
• Design source-to-target mappings, data models, and transformation logic.
• Create and oversee technical design documentation.

Skills

ETL

Data engineering

Data integration

Snowflake

Matillion

Fivetran

API-based data pipelines

Data profiling

Team leadership

Education

Bachelor’s degree in a relevant field

Tools

Snowflake

Matillion

Fivetran

Job description

Solutions Architect

Location: Hybrid NY, NJ, CT

Compensation: Up to $70/hr

Contract Length: 12 months +

Employment type: Full time (Right to Hire)

Position Summary: The Solutions Architect is responsible for architecting, designing, and leading the delivery of enterprise ETL and data integration solutions that support critical business and regulatory initiatives. This role combines hands‑on technical expertise with team leadership and ownership of complex data programs.

Responsibilities

• Lead the architecture, design, and implementation of enterprise ETL and data integration solutions using Snowflake, Matillion and Fivetran.
• Review and interpret data and ETL requirements; partner with DBAs and Data Architects to validate or extend data models.
• Design source‑to‑target mappings, data models, and transformation logic to support business, risk, and reporting needs.
• Create and review DDL for new database objects, attributes, and structures as required.
• Establish standards and best practices for ETL design, data quality, security, and performance.
• Optimize and configure Snowflake data environment through configuration, sizing and review and creation of views, dynamic tables and other database features as required.
• Design, develop, and optimize complex ETL workflows using Matillion ETL and API‑based data pipelines.
• Create and oversee technical design documentation and ensure alignment with SDLC standards.
• Establish secure connections between data sources and Snowflake using appropriate security protocols.
• Oversee data cleansing, transformation, validation, and enrichment processes.
• Implement robust data quality checks, error handling, and monitoring frameworks.
• Lead and mentor a team of developers, providing technical guidance and code reviews.
• Work with Project Manager to assign work, set priorities, and ensure timely delivery of ETL initiatives.
• Serve as a trusted advisor on data integration strategy and capabilities.
• Research and evaluate new data integration and optimization techniques, staying current with advancements in Snowflake, Matillion, and cloud data engineering best practices.

Qualifications

• 7+ years of experience in ETL, data engineering, and data integration, with a focus on architecture and design.
• Proven experience leading or mentoring a team.
• Strong hands‑on experience with Snowflake, Matillion, and/or Fivetran.
• Extensive experience designing and building API‑based data pipelines.
• Strong understanding of data modeling, source‑to‑target mapping, and data profiling.
• Experience working in regulated, financial, or banking environments preferred.
• Ability to take ownership of complex data programs and drive delivery independently.
• Experience supporting banking, risk management, or financial reporting platforms.

Education & Certifications

• Bachelor’s degree in a relevant field (Computer Science, Information Systems, Finance, or Banking preferred).

Pay Transparency

RCM believes in transparency and fairness in compensation. We are committed to providing our employees with competitive salaries that reflect their skills, experience, and contributions to our organization.

Equal Opportunity Employer

RCM is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.