Overview
On Site
$160,000 - $180,000
Full Time
Skills
ADF
Data Engineering
Data Warehouse
SQL Azure
Microsoft Azure
Microsoft SQL Server
RDBMS
Data Quality
Data Marts
Data Lake
Databricks
Extract
Transform
Load
Job Details
We are in Critical need of Data Architect for Fulltime Hire in Santa Clara, CA.
Role : Data Architect
Location : Santa Clara, CA
Duration : Fulltime Hire
Job Description :
a) Should be able to work independently as the overall Technical in-charge for the project
b) Should be able to understand requirements, proactively clarify any doubts/assumptions with the team members and also proficient in client interactions
c) Should be able to guide Leads and developers
d) Should be team player
e) Should be flexible with working hours (sometimes during deployments, customer calls)
f) Should be self motivated and passionate to become technology expert
Primary (Must have skills )
Excellent verbal and written communication. Should be able to speak confidently throughout the conversation
Experience working with customer Business/IT team Expertise with minimum 6+ projects (10+ Yrs exp.)
a) SQL Server and Azure SQL Database
b) ADF , Databricks, PySpark
c) Knowledge and experience in ETL architectures, designing ETL pipelines, Database schema designs, Data modeling techniques, Data Quality stages in various data environments like Data Lake, Data warehouse, Data Marts leveraging the Medallion Architecture
d) Designing DB schema, data models on RDBMS and DW leveraging the Medallion Architecture on RDBMS and Azure Data Platform
e) Programming and optimizing DB objects Views, Stored Procs, Functions
f) Databricks Unity Catalog, Lakehouse Experience with minimum 2+ projects (3+ Yrs. exp.)
a) Azure SQL DW/Synapse
b) Azure Data Lake or Blob storage
c) Experience working with high volume data, large objects
d) Deep knowledge of the various Data Engineering components within Microsoft Fabric is preferable (including Lakehouse)
e) Designing storage and data pipeline solution using Azure Data Services Other must have skills:
a) Experience working with high volume data, large objects and variety of data types
b) Experience leveraging the Azure Well-architected Framework (WAF) for Assessments is preferable
c) Following the design/coding best practices
d) Experience of working in a challenging environment with unclear requirements and contributing collaboratively with the team to refine the requirements
e) Ability to offer innovative ideas/solutioning, that are modern and effective
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.