Lead Solution Architect

Job Title: Lead Solution Architect 
Location : Scottsdale AZ – Day 1 onsite
Duration : Long-Term Contract

Pay rate : $80/hr on C2C/1099.

Must have skill:
Data Architecture
Snowflake dbt
Airflow / astronomer
Azure services
Python

Responsibility for Data Solution Architect
Technical role who should understand the data solutions, landscape, connect and convince customer on regular basis. Act as SPOC for both onshore and offshore team for support as well as development work.
Must have:
Ability to establish the relation and build the rapport with customer stakeholders
Should be able to articulate the problem statement & solution
Should have excellent communication, presentation and analytical capability
Expert in Stake holder Management, Conflict management
Participate and represent in detailed architectural discussions with the Global Data team to build confidence and ensure customer success when building new solutions and migrating legacy data within the Azure Data Lake platform
Experience with Azure Cloud and Data Analytics solutions
Ability to build Azure cloud data solutions and provide technical perspective and expertise on storage, platform services, cloud architecture and RDBMS/ODS database practices (Snowflake and Databricks)
Exposure to large databases, BI applications, data quality and performance tuning
Experience with ETL processing or ETL toolset
Data Management concepts and standards (SQL Server, Oracle, Cloud, Snowflake, Azure, etc.)

Good to have:
Provide subject matter expertise and hands on delivery of data capture and consumption of legacy data via Global template pipelines and Global framework playbook protocols.
Expert, hands on experience in Azure Data Factory, Data Lake store/Blob storage, SQL DB Experience in creating Pipelines with Azure components
Expert, hands on experience in Databricks, Snowflake or similar
Strong SQL experience writing stored procedures, tuning indexes and troubleshooting performance bottlenecks
skills in Python"