Data Modeler & Architect (Remote / Quarterly travel to DC)

Job Title: Data Modeler & Architect

Location: Washington, DC

Duration: 6+ Months contract to hire

Consultant's with Public Trust clearance are encouraged to apply .

In this role, you will:

• Work with business users to understand business data needs, business processes, and challenges.
• Working with business analysts, system owners, and other stakeholders to gather requirements.
• Create and maintain conceptual, logical, and physical data models to support business requirements, reporting and analytics.
• Create and maintain source-target mappings, recommend and incorporate data standards, identify data quality issues and recommend remediations.
• Communicate with stakeholders to ensure clear understanding of models and get buy in, and support stakeholders in development of queries and reports.
• Optimize models for Azure cloud data architectures, including but not limited to data lake medallion architecture, Synapse Analytics, Azure SQL Managed Instance, NoSQL data stores, and Power BI.
• Support reengineering efforts to transition workloads from the legacy Enterprise Data Warehouse to Azure Data Lake Platform.
• Optimize data models for performance, data quality, and scalability.
• Work with data governance team, data stewards, subject matter experts to recommend and implement data standards, including for vocabulary, data formats, and reference data.
• Work with the DevOps team to support and advise on implementation.
• Provide hands on support for reporting, data requests, data calls, and other forms of data delivery.
• Ensure support for data governance frameworks, security best practices, and compliance regulations.
• Create and maintain documentation for data models and related processes.
• Implement and enforce data modeling standards and best practices.
• Assist with troubleshooting data-related issues and providing technical support.

For this position, you must possess:

• At least a BS degree in Computer Science or related field and 12+ years of relevant experience
• 6+ years of proven experience with data modeling for Microsoft enterprise data warehousing, including analytical models.
• 4+ years of experience working directly with client stakeholders and business users on data needs analysis.
• Proficiency with development and implementation of transactional/dimensional data models, source-target mapping, data transformation logic, data standards, data quality resolution.
• Experience developing conceptual, logical, and physical data models.
• Demonstrated experience with the definition, design, and development of subject specific domain data models supporting reporting and queries.
• Understanding of various database technologies (relational, dimensional, NoSQL, data lake medallion).
• Proficiency using Microsoft database and business intelligence tools, including SQL Server (e.g. stored procedures), SSIS, SSRS, SSAS, (cubes), and Power BI.
• Proficiency with more than one of the follow scripting languages: SQL, T-SQL, Python, PowerShell
• Experience with and knowledge of Azure Data Lake Services, Azure Synapse Analytics, Azure SQL MI, and other related services.
• Experience advising ETL & data engineering teams.
• Strong communication and collaboration skills.
• Experience with Agile DevOps methodology.
• Open mindset, continuous learning and ability to quickly adopt new technologies to solve customer problems.

Not required, but additional education, certifications, and/or experience are a plus:

• Microsoft certification in Azure fundamentals, data engineering, AI, data analytics.
• Data management certification (e.g. DAMA DMBOK)
• Experience working on Generative AI projects.