Data & Integration Solution Architect

Fipsar Inc; Hillsborough Township (NJ); On-site; USD 120,000 - 190,000; Full time

Job summary

Fipsar Inc. is seeking a Data & Integration Solution Architect to design and deliver modern enterprise data, integration, analytics, and AI solutions. The role suits a data engineer or architect ready to lead technical architecture and stakeholder discussions.

You will translate business needs into scalable architectures, collaborate with Snowflake and BI teams, and drive end-to-end solutions across cloud services and enterprise applications.

Qualifications

• Experience in data engineering and enterprise integration.
• Ability to translate business requirements into scalable data architectures.
• Hands-on with SQL, data modeling, ETL/ELT, APIs, and modern data platforms.

Responsibilities

• Lead solution design for enterprise data, integration, analytics, and modernization initiatives.
• Translate business requirements into scalable data and integration architectures.
• Design solutions involving Snowflake, ETL/ELT platforms, APIs, cloud services, enterprise applications, and BI/analytics platforms.
• Assess source systems, data flows, interfaces, dependencies, data quality, security, and integration requirements.
• Design reusable patterns for batch, API, file-based, and event-driven integrations.
• Collaborate with Snowflake, Talend, BI/Qlik, Salesforce/Veeva, AI, and application teams to develop end-to-end solutions.
• Lead technical discovery sessions and architecture discussions with client and internal stakeholders.
• Develop solution architecture diagrams, data flows, integration designs, technical approaches, assumptions, and implementation roadmaps.
• Support project estimation, resource planning, proposals, and SOW development.
• Provide architecture oversight throughout development, testing, deployment, and production transition.
• Identify opportunities to modernize data and integration platforms using cloud-native technologies, automation, and AI.

Skills

Data engineering

Data architecture

Enterprise integration

SQL

Data modeling

ETL/ELT

APIs

Cloud platforms

Snowflake

BI/Analytics

REST APIs

Tools

Talend

Snowflake

Qlik

Power BI

Tableau

Job description

We are looking for a highly motivated Data & Integration Solution Architect to join our growing Data & AI practice and help design and deliver modern enterprise data, integration, analytics, and AI solutions for our clients.

This is an excellent opportunity for an experienced Data Engineer, Technical Lead, Data Architect, or Integration Architect who has strong technical fundamentals and is ready to grow into broader solution architecture and technical leadership responsibilities.

What You'll Do

• Lead solution design for enterprise data, integration, analytics, and modernization initiatives.
• Translate business requirements into scalable data and integration architectures.
• Design solutions involving Snowflake, ETL/ELT platforms, APIs, cloud services, enterprise applications, and BI/analytics platforms.
• Assess source systems, data flows, interfaces, dependencies, data quality, security, and integration requirements.
• Design reusable patterns for batch, API, file-based, and event-driven integrations.
• Collaborate with Snowflake, Talend, BI/Qlik, Salesforce/Veeva, AI, and application teams to develop end-to-end solutions.
• Lead technical discovery sessions and architecture discussions with client and internal stakeholders.
• Develop solution architecture diagrams, data flows, integration designs, technical approaches, assumptions, and implementation roadmaps.
• Support project estimation, resource planning, proposals, and SOW development.
• Provide architecture oversight throughout development, testing, deployment, and production transition.
• Identify opportunities to modernize data and integration platforms using cloud-native technologies, automation, and AI.

What We're Looking For

• Strong foundation in data engineering, data architecture, and enterprise integration.
• Hands-on experience with SQL, data modeling, ETL/ELT, APIs, and modern data platforms.
• Experience with a cloud data platform such as Snowflake is highly preferred.
• Understanding of enterprise integration patterns, REST APIs, batch/file integrations, orchestration, data quality, and security.
• Experience with ETL/integration technologies such as Talend or comparable platforms.
• Exposure to BI/analytics platforms such as Qlik, Power BI, or Tableau.
• Ability to understand unfamiliar enterprise applications and integration landscapes quickly.
• Experience creating architecture diagrams, technical designs, data flows, and implementation plans.
• Strong analytical and problem-solving skills with the ability to work through ambiguous requirements.
• Good communication skills and the ability to explain technical solutions clearly to both technical and business stakeholders.

Who Will Succeed in This Role

We are especially interested in candidates who are curious, hands-on, accountable, and eager to grow.

You do not need to know every technology in our clients' ecosystems. We are looking for someone with strong fundamentals who can quickly understand a new business problem, ask the right questions, collaborate with platform specialists, and develop a practical end-to-end solution.

This role is ideal for someone ready to make the transition from:

Senior Data Engineer / Technical Lead -> Solution Architect -> Enterprise Data & Integration Architect

• You will have the opportunity to work directly on strategic enterprise transformation initiatives and grow into broader architecture and technical leadership responsibilities.