Azure Data Architect

Azure Data Architect

Posted 1 day ago by 1752155578

Negotiable
Outside
Remote
USA

Summary: The Azure Data Architect role focuses on designing and developing robust data architectures using Azure and Microsoft Fabric, with a strong emphasis on data governance and integration solutions. The position requires extensive experience in data architecture, including hands-on skills in data lake and data warehouse components, and the ability to collaborate effectively with clients and teams. This is a fully remote contract position expected to last 4-6 weeks, starting tentatively from August 1st. Candidates should possess a Bachelor's degree or higher in relevant fields and have significant experience in the industry.

Key Responsibilities:

  • Act as the single point of contact for the client for technical delivery.
  • Design and develop a robust data architecture that supports the organization's data needs.
  • Define data architecture framework components including integration, data management, and data consumption.
  • Create conceptual, logical, and physical data models to ensure data integrity and consistency.
  • Establish and enforce data governance policies and standards.
  • Design and implement data integration solutions for data extraction, transformation, and loading.
  • Leverage Azure and Fabric services to build scalable and cost-effective data solutions.
  • Optimize data queries and ETL processes for efficient data access and analysis.
  • Collaborate with data engineers, analysts, and business users to translate requirements into technical solutions.
  • Clarify any doubts or assumptions proactively.
  • Work flexibly with teams in different time zones.
  • Be self-motivated and accountable for work and deadlines.
  • Set implementation paths for projects and perform effort estimations.
  • Conduct customer demos.

Key Skills:

  • Excellent verbal and written communication skills.
  • Experience working with customer Business/IT teams.
  • Expertise in designing scalable and modular data architectures.
  • Strong knowledge of Microsoft Fabric components and Azure services.
  • Experience designing and implementing data pipelines.
  • Understanding of data quality frameworks and governance policies.
  • Performance optimization skills for ETL jobs and data models.
  • Ability to translate business requirements into technical solutions.
  • Experience in modernizing legacy data warehouses to cloud-native platforms.
  • Familiarity with traditional data platforms and Power BI.
  • Exposure to CI/CD and DevOps practices.
  • Understanding of data privacy and regulatory standards.
  • Proficiency in scripting and automation tools.
  • Relevant certifications in Azure and data engineering.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Job Title: Azure Data Architect-Microsoft Fabric

Duration: Contract

Location: Columbus Ohio Remote

Fully remote

Contract

Key skills: Azure Architect with data and PoweBI skills with hands on experience on Fabric migration willing to join for 4 -6weeks. Tentatively starting from August 1st.

Educational Qualification*

Bachelor s Degree or higher in Information Systems, Computer Science, or equivalent experience

JD/Description of Role* (RNR)
(Mandatory - Minimum 500 words)

a)Acts as the Single point of the contact for the client for technical delivery
b)Design and develop a robust data architecture that supports the organization's data needs, including data lake and data warehouse components
c)Define Data Architecture framework components Integration, Data Management and Data Consumption
d)Create conceptual, logical, and physical data models to ensure data integrity and consistency
e)Establish and enforce data governance policies and standards to maintain data quality and security
f)Design and implement data integration solutions to extract, transform, and load data from various sources into the data lake and data warehouse
g)Leverage Azure and Fabric services to build scalable and cost-effective data solutions
h)Optimize data queries and ETL processes to ensure efficient data access and analysis
i)Collaborate with data engineers, analysts, and business users to understand their requirements and translate them into technical solutions
j) Should be able to understand requirement and proactively clarify any doubts/assumptuions
k) Should be team player
l) Should be flexible with working hours( collaborate with team in India , in IST timezone)
m) Should be self motivated and passionate to become technology expert
n) Should be accountable for his work and committed to deadlines
o)Should be able to set a Implementation path for projects
p)Should be able to do Effort Estimations for Projects
q)Should be able to do customer demos

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 8+ projects (18+ Yrs exp.)
Data Architecture Design:
1.Expertise in designing scalable and modular data architectures (Data Lake + Data Warehouse)
2.Experience creating conceptual, logical, and physical data models
Azure & Microsoft Fabric:
3.Strong knowledge of Microsoft Fabric components (Lakehouse, Dataflows, Pipelines, etc.)
4.Proficient with Azure services: Synapse, Data Factory, Data Lake Storage, SQL DB, etc.
ETL/ELT & Data Integration:
5.Experience designing and implementing data pipelines for extraction, transformation, and loading from diverse sources
6.Familiarity with both batch and real-time data processing
Data Governance & Management:
7.Understanding of data quality frameworks, metadata management, lineage, and access control
8.Ability to define and enforce governance policies
Performance Optimization:
9.Tuning ETL jobs, optimizing data models, and improving query performance
Stakeholder Communication:
10.Ability to translate business requirements into technical solutions
11.Experience serving as a single point of contact for clients on technical delivery
Modern Data Platforms Migration:
12.Experience in modernizing legacy data warehouses to cloud-native platforms
Well-architected Framework
13. Best design/coding practices
14. Experience in working in a challenging environment with unclear requirements and contributing collaboratively with the team to refine the requirements
15, Ability to offer innovative ideas/solutioning, that are modern and effective.

Experience Range

18 to 20 years

Secondary Skills (Good To have)*

1.Legacy DW Experience: Familiarity with traditional platforms like Teradata, Netezza, Oracle, or SQL Server.
2.Power BI: Working knowledge of Power BI for reporting, semantic model design, and DAX.
3.CI/CD & DevOps: Exposure to deploying data pipelines via Azure DevOps or GitHub Actions.
4.Security & Compliance: Understanding of data privacy, encryption, and regulatory standards (e.g., GDPR, HIPAA).
5.Data Catalogs: Experience with Microsoft Purview or other metadata management tools.
6.Agile Methodology: Comfort with Agile project delivery and sprint-based planning.
7.Scripting & Automation: Ability to use SQL, PowerShell, or Python for automation or tooling support.
8.Certifications:
Preferred: Microsoft Certified: Azure Data Engineer Associate
Additional beneficial certifications: DP-600 (Microsoft Fabric Analytics Engineer)/DP-700, DP-203 (Azure Data Engineer), Azure Solutions Architect Expert, or equivalent cloud/data certifications.

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) Should have good attitude at work