Job description

Job role: Solution Architect – Data Platform Duration: 12+ months Job Type: Contract Location: Houston, TX- Onsite from day 1 Exp: 12+ Yrs Position Overview : We are looking for an experienced Data Warehouse Solution Architect with expertise in Snowflake, Azure Data Factory (ADF), and Power BI to lead solution design and delivery for a large-scale data migration and modernization program. The candidate will work closely with business stakeholders and technical teams to define, design, and implement scalable, secure, and high-performance solutions on the Azure cloud data platform. Should have work experience in Banking Domain. Primary Skills : Snowflake, Azure, ADF, ETL/ELT, Data Modelling, Devops and Power BI. (Banking Domain Exp Must) Key Responsibilities Solution Design & Architecture : • Translate business requirements into end-to-end Data Warehouse solution designs leveraging Snowflake, ADF, and Power BI. • Define integration, transformation, and reporting strategies for the migration program. • Ensure solutions meet scalability, performance, security, and compliance requirements. • Define and implement automation testing in ETL/ELT layers. • Implement Data Quality and Data controls to in ELT and reporting layer. Migration & Implementation : • Lead migration from on-prem/legacy systems to Snowflake using Azure cloud services. • Define standards for data ingestion, ELT/ETL pipelines, and reporting layers. • Oversee implementation of incremental, batch, and real-time data pipelines. • Collaboration & Leadership • Partner with architects, engineers, BI developers, and business users to deliver business-ready solutions. • Provide guidance and oversight to development teams during execution. • Act as the solution authority in design reviews and project governance forums. Governance & Best Practices : • Establish solution standards for data modelling, security, CI/CD, and monitoring. • Ensure compliance with data governance, metadata, and regulatory policies. • Promote adoption of best practices and reusable design patterns. Required Skills & Experience: • Proven experience designing Data Warehouse solutions using Snowflake, ADF, and Power BI. • Strong understanding of data modelling (Star and Snowflake Schema design) and ELT/ETL best practices. • Hands-on knowledge of Azure ecosystem (ADLS, Key Vault, Databricks/Synapse optional). • Experience in data migration projects (history loads, incremental refresh, large-scale transformations). • Expertise in security & access control (RBAC, encryption, data masking). • Familiarity with DevOps (Azure DevOps, CI/CD pipelines). • Should be able to collaborate with teams and customers across globe. • Expertise within the banking domain—especially strong knowledge of loans and deposits. Understanding of consumer & commercial banking and general ledger functions will be an added advantage

Requirements