Solution Architect Data Engineering & Platform Solutions

Solution Architect Data Engineering & Platform Solutions

Location: Remote (Preferably Florida)

Job Type: Full-Time

Job Overview:

We are seeking a well-rounded Solution Architect with deep experience in cloud-native data

platforms, end-to-end integration, modern front-end technologies, and AI-enhanced solutions.

The ideal candidate will also bring a strong background in data warehouse design, marketing

analytics architecture, and SaaS reporting platforms. This role requires the ability to analyze

current systems, define future-state architecture, and lead implementation roadmaps across data

engineering, integrations, and visualization layers.

Key Responsibilities:

• Lead current-state assessments and define scalable future-state architecture across data,

integration, and front-end layers.

• Design and architect cloud-based data warehouse solutions with a focus on scalability,

performance, cost-efficiency, and ease of maintenance.

• Evaluate and recommend technologies (e.g., Snowflake, Azure Synapse, Redshift)

based on client context.

• Define ETL/ELT pipelines for ingestion from various platforms including internal

systems, APIs, SaaS tools (Salesforce, HubSpot, Marketo, Google Analytics).

• Build integration strategies for sales/marketing tech stacks, aligning CRMs, analytics,

automation, and ad platforms.

• Guide implementation of dashboards and reporting in Power BI, Tableau, and Looker

aligned to KPIs and business goals.

• Lead architecture for AI-enhanced capabilities including smart agents, data Q&A

interfaces (e.g., GPT overlay), and ML-based insights.

• Create implementation roadmaps including cost models, risk analysis, and timelines.
• Collaborate with cross-functional teams including product, engineering, data science, and

business stakeholders.

Required Qualifications:

• 10+ years of experience in solution architecture, data engineering, or enterprise

application design.

• Deep expertise in designing cloud data warehouses and lakes; strong experience with

Azure (preferred), AWS.

• Proven experience in ETL pipeline development and integration with SaaS platforms

across marketing, sales, and data ecosystems.

• Strong command of SQL, Python, and orchestration tools (Airflow, dbt, etc.).
• Demonstrated success delivering BI dashboards and reporting frameworks using

Power BI, Tableau, or Looker.

• Experience designing scalable systems that handle large datasets (millions of records)

with secure access control, lineage, and logging.

• Familiarity with HIPAA/GDPR compliance and secure multi-tenant data solutions.

Preferred Experience:

• Experience modernizing legacy SQL Server/SSIS systems into cloud-native platforms.
• Hands-on architecture work involving multi-source data integration, real-time and

batch ingestion.

• Building marketing and sales funnel reporting systems and aligning them to PE or

executive dashboards.

• Experience layering AI/NLP tools (e.g., GPT-based Q&A interfaces) on top of data

models or reporting platforms.

• Familiarity with visualization standards for SaaS performance metrics (e.g., MQL to

closed-won funnels, campaign ROIs).

Soft Skills:

• Excellent communication and documentation skills; ability to simplify complex technical

concepts for non-technical stakeholders.

• Strong stakeholder engagement experience in consulting or client-facing delivery

environments.

• Ability to lead cross-functional global teams and deliver architecture under tight

timelines.