RCM Technologies, Inc. ยท 10 hours ago
Solutions Architect
NYC Metro Area
Full-time
Hybrid
Senior Level
$70/hr - $70/hr
7+ years expRCM Technologies, Inc. is a business and technology solutions provider, and they are seeking a Solutions Architect to lead the delivery of enterprise ETL and data integration solutions. The role involves technical leadership, team mentorship, and collaboration with stakeholders to design and implement scalable data solutions.
Management Consulting
Hiring Manager
Vince Girardi
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
Establish secure connections between data sources and Snowflake using appropriate security protocols
Oversee data cleansing, transformation, validation, and enrichment processes
Design and implement robust data quality checks, error handling, and monitoring frameworks
Ensure proper unit, system, and regression testing with full documentation in alignment with SDLC standards
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
Act as a hands-on leader who can step in to solve complex technical problems when required
Promote knowledge sharing, documentation, and continuous improvement across the team
Work closely with business stakeholders, data analysts, and IT teams to gather requirements and translate them into scalable data solutions
Communicate technical concepts and recommendations clearly to both technical and non-technical audiences
Serve as a trusted advisor on data integration strategy and capabilities
Research and evaluate new data integration and optimization techniques
Stay current with advancements in Snowflake, Matillion, and cloud data engineering best practices
Drive improvements in performance, scalability, and reliability of data pipelines
Qualification
Required
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
Ability to take ownership of complex data programs and drive delivery independently
Experience supporting banking, risk management, or financial reporting platforms
Preferred
Experience working in regulated, financial, or banking environments preferred
Bachelor's degree in a relevant field (Computer Science, Information Systems, Finance, or Banking preferred)
Company
RCM Technologies, Inc.
RCM Technologies, Inc. (Nasdaq: RCMT) is a business and technology solutions provider with world-class talent in key market segments.
1001-5000 employees
H1B Sponsorship
RCM Technologies, Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (9)
2024 (13)
2023 (6)
2022 (5)
2021 (21)
2020 (10)
Funding
Current Stage
Late StageLeadership Team
Samantha K. Trinh
Head of Brand, Innovation & Partnerships
Company data provided by crunchbase