Data Architect

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Architect with over 15 years of experience, focusing on retail/automotive domains. It is a remote contract position for U.S. citizens/Green Card holders, requiring expertise in Azure, data modeling tools, and database design. Expected duration is more than 6 months.
🌎 - Country
United States
💱 - Currency
$ USD
💰 - Day rate
Unknown
Unknown
🗓️ - Date discovered
April 25, 2025
🕒 - Project duration
More than 6 months
🏝️ - Location type
Remote
📄 - Contract type
Unknown
🔒 - Security clearance
Unknown
📍 - Location detailed
United States
🧠 - Skills detailed
#"ETL (Extract #Transform #Load)" #ADF (Azure Data Factory) #Data Modeling #Azure ADLS (Azure Data Lake Storage) #Kafka (Apache Kafka) #Azure Data Factory #Metadata #RDBMS (Relational Database Management System) #SQL Server #Compliance #SQL (Structured Query Language) #Storage #Data Integration #Data Architecture #Azure #ERWin #PostgreSQL #Synapse #MySQL #Physical Data Model #Data Lineage #Data Governance #Oracle #Database Performance #Documentation #NoSQL #Data Lake #BI (Business Intelligence) #Data Science #Data Profiling #Scala #Computer Science #Database Design #ADLS (Azure Data Lake Storage) #Data Processing
Role description

Data Architect

Full Time Position / Contract

Remote (travel required as per need)

U.S. Citizens/Green Card ONLY due to legal or government contract requirement

Experience: 15 years Plus

Domain – Retail/ Automotive

Key Skills:

   • Proficiency in data modeling tools (e.g., Erwin, PowerDesigner, ER/Studio).

   • Expertise in Azure ecosystem (Azure Data Lake Storage, Azure Data Factory, Synapse Analytics, Event Hub, Kafka).

Required Skills & Experience:

   • 15+ years of professional experience in Data Architecture/Data Modeler .

   • Bachelor’s degree in computer science, Information Systems, Data Science, or a related field.

   • Experience in data modeling and database design.

   • Proficiency in data modeling tools (e.g., Erwin, PowerDesigner, ER/Studio).

   • Strong understanding of relational, dimensional, and NoSQL data modeling techniques.

   • Experience with SQL and at least one major RDBMS (e.g., Oracle, SQL Server, PostgreSQL, MySQL).

   • Familiarity with data warehousing, ETL processes, and data lake architectures.

   • Excellent analytical and communication skills.

   • Expertise in Azure ecosystem (Azure Data Lake Storage, Azure Data Factory, Synapse Analytics, Event Hub, Kafka).

   • Knowledge of structured streaming and real-time data processing.

Responsibilities:

   • Design and maintain conceptual, logical, and physical data models to support business intelligence, analytics, and operational systems.

   • Collaborate with stakeholders, data architects, and engineering teams to gather data requirements and translate them into effective models.

   • Develop and enforce data modeling standards and best practices to ensure data consistency and integrity across systems.

   • Conduct data profiling and analysis to understand source systems and support accurate modeling.

   • Create and manage data dictionaries, entity relationship diagrams (ERDs), and metadata repositories.

   • Ensure models align with enterprise architecture principles, business goals, and compliance requirements.

   • Support data integration and transformation processes by providing clear documentation and data flow guidance.

   • Partner with development teams and DBAs to implement models, optimize queries, and improve database performance.

   • Participate in code and design reviews to ensure model quality, scalability, and maintainability.

   • Assist in establishing and maintaining data governance frameworks, including data lineage, stewardship, and quality metrics.

Kindly reply with your resume to Email- jnehru@nam-it.com