Data Architect

Job Title: Data Architect

Location: Santa Clara, CA

Job Description of Role:

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

Secondary Skills (Good To have):

a) DP-203 Certified and DP-700 Certified

b) Experience with Power BI

c) Experience with Databricks with scala or python

e) Experience with Big Data technologies (Spark, Scala, Kafka, HIVE, HBase etc.)

f) Experience with Stream Analytics and IoT

g) Experience with Machine Learning, R/Python

h) Experience with C# development web and services

i) Exposure to Reporting/Dashboard applications using Power BI or any other BI reporting tool

j) Exposure to Machine Learning techniques, R/Python in a Data Engineering context is preferable

k) Exposure to any Data Governance processes and tools is preferable

l) Should have decent knowledge of the Azure Cloud Infrastructure and Environment

m) Proven experience working in Agile and Waterfall development methodologies is preferable

n) Experience working in DevOps environments is preferable

Soft skills/other skills (If any)

1) Should have good oral and written communication.

2) Should be a good team player.

3) Should be proactive and adaptive.

4) Good experience with working with customer teams

5) Neutral accent

6) Positive atttitude, positive body language

EOE: Our client is an Equal Opportunity Employer, committed to a workplace free from discrimination and harassment. Employment decisions are based on business needs, job requirements, and individual qualifications without regard to race, color, religion, gender, age, disability, sexual orientation, gender identity, marital status, military service, genetic information, or any other status protected by law.