Data Architect

Data Architect || Durham, PA (Onsite) || 15+ Years || $75/hr onC2C Any Special Requests? : Must be able to work onsite in Durham, Pennsylvania. Important Skill-Set, Technologies, Certifications, and Methodologies: Data Modeling, Azure Data Factory (ADF), Azure Databricks, Apache Spark, Azure Data Lake Storage Gen2 (ADLS Gen2), ETL/ELT Pipelines, Dimensional Modeling, SQL/NoSQL, Data Governance, Performance Tuning. About the Role: We are seeking a high-level Senior Data Architect with over 15 years of experience to lead the design and implementation of enterprise-grade data solutions. This role focuses on architecting robust Conceptual, Logical, and Physical Data Models while building scalable ETL/ELT infrastructures within the Microsoft Azure ecosystem. Key Responsibilities: • Design and maintain Dimensional Models, including Fact and Dimension tables for advanced analytics. • Develop end-to-end ETL/ELT pipelines using Azure Data Factory. • Build and optimize data processing workflows and Spark jobs in Azure Databricks for cost efficiency and scalability. • Ingest and integrate data from diverse sources, including SQL/NoSQL databases, APIs, and cloud storage. • Manage data storage structures within Azure Data Lake Storage Gen2. • Implement Data Quality checks, validation rules, and automated reconciliation processes. • Ensure Data Governance, security, compliance, and detailed Metadata Management/Lineage documentation. Essential Skills: • Mastery of Data Modeling (Conceptual, Logical, Physical) and Star/Snowflake Schemas. • Extensive experience with Azure Databricks and Apache Spark optimization. • Proficiency in Azure Data Factory for complex pipeline orchestration. • Strong background in Incremental Loading strategies, error handling, and monitoring. • Expertise in SQL and familiarity with NoSQL architectures. • Solid understanding of Data Integrity, standardization, and Data Lake management. Desirable Skills: • Relevant Microsoft Azure Certifications (e.g., Azure Data Engineer Associate). • Experience collaborating with Solution Architects on high-level platform strategy. • Knowledge of DevOps practices for data (DataOps). Keywords in your resume: Data Architect, Azure Data Factory, Azure Databricks, Apache Spark, ETL, ELT, Data Modeling, ADLS Gen2, Dimensional Modeling, Fact Tables, Data Governance, Data Quality, SQL, NoSQL, Azure Cloud, Performance Tuning, Metadata Management. Please shares resumes to [Upgrade to PRO to see contact]