Solution Architect leading client-facing data migration projects for Enterprise Data Platform. Working on AWS and Snowflake to drive successful end-to-end migration.
Responsibilities
Lead the technical discovery, design, and planning phases, effectively translating complex client business needs and requirements into detailed architectural blueprints and robust technical specifications.
Design and document the end-to-end data flow and pipeline orchestration, from various source system ingestion patterns (batch and streaming) to the final curated Gold Layer models, primarily utilizing **AWS Redshift**.
Define the **canonical data models** for the Silver Layer and establish the optimal **dimensional models** for the Gold Layer, leveraging data modeling tools like **Erwin**.
Provide clear technical leadership and oversight to the engineering and development teams, ensuring alignment with the established architectural vision.
Requirements
15+ years of progressive experience in data engineering, data warehousing, and cloud architecture roles.
Minimum of 10 years specifically in a client-facing or leadership role designing and implementing large-scale data migration projects.
Candidates must demonstrate deep, hands-on experience and architectural proficiency across the following technologies:
**Data Processing:** Expert knowledge in **PySpark** for large-scale data transformation and processing.
**Data Warehousing:** Proven experience designing and managing scalable data warehouse solutions, specifically using **Redshift**.
**Data Streaming:** Kafka and/or Amazon Kinesis.
**Data Warehouse:** Hands-on experience with **Snowflake**.
**Data Governance & Quality:** Experience with tools like DataHub and data quality frameworks such as **Great Expectations**.
**Modeling:** Advanced data modeling techniques and methodologies.
Participate in fast iteration cycles, adapting to evolving project requirements.
Collaborate as part of a cross-functional Agile team to create and enhance software that enables state-of-the-art big data and ML applications.
Collaborate with Data scientists, software engineers, data engineers, and other stakeholders to develop and implement best practices for MLOps, including CI/CD pipelines, version control, model versioning, monitoring, alerting and automated model deployment.
Ability to work with a global team, playing a key role in communicating problem context to the remote teams
Excellent communication and teamwork skills
Benefits
Significant career development opportunities exist as the company grows. The position offers a unique opportunity to be part of a small, fast-growing, challenging and entrepreneurial environment, with a high degree of individual responsibility.
Junior Solutions Engineer providing technical qualification and support for automotive SaaS solutions. Collaborating with commercial and client services teams in Milan, Italy.
Solutions Architect transforming businesses through Generative AI applications and strategies. Engaging with customers to ensure value realization from their investment in OpenAI's technologies.
Solutions Architect designing and implementing solutions for complex business problems. Collaborating with stakeholders and leading a team while ensuring adherence to governance processes.
Solutions Architect at INTEGRIS Health shaping application technologies through design and implementation. Mentoring project teams and advancing strategic goals in clinical or business systems.
Senior Weapons Systems Integration Engineer in charge of military aircraft systems integration and modernization efforts. Focusing on weapons integration and logistics readiness at Wright - Patterson AFB.
Solutions Architect driving API standards and integration patterns for Zantech's DoD projects. Involving multi - cloud architecture and cross - domain solutions, ensuring secure data flows.
Anaplan Solutions Architect managing and optimizing financial planning models for OpenAI's growth. Collaborating with finance and tech teams to ensure data integrity and scalability.
Principal Solutions Architect at Paramount improving media platforms through design and AI technology. Overseeing MAM/PAM ecosystems and architecture for media supply chains.
Senior Elastic Stack Data Integration Engineer designing and maintaining data ingestion pipelines for Missile Defense Agency. Focused on building resilient and scalable Logstash architectures.
Senior Security Integration Engineer supporting Missile Defense Agency through Elastic Stack integration and optimization of security data. Leading customer engagements and technical discussions while mentoring junior team members.