Data Modeler & Architect- Remote- Public Trust Clearance Needed with Security Clearance

SOC/Day & Zimmermann Federal Services • Permanent • Remote (Washington DC, United States) • $49.66 / * • 21h ago

Data Modeler & Architect needed for a contract opportunity with SOC's client to work remote. Active Public Trust required JOB DESCRIPTION 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. REQUIREMENTS 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. US Citizenship and ability to successfully obtain a government-issued Public Trust clearance. Employment Prerequisites The following requirements must be met to be eligible for this position: successful completion of a background investigation and d rug urinalysis. SOC, a Day & Zimmermann company, is an Equal Opportunity Employer,EOE AA M/F/Vet/Disability. Note: Any pay ranges displayed are estimations, which may have been provided by job boards. Actual pay is determined by an applicant's experience, technical expertise, and other qualifications as listed in the job description. All qualified applicants are welcome to apply. Estimated Min Rate: $49.66 Estimated Max Rate: $70.94

Related Jobs

Telecommunications Technician 3 - Lead Technician/Supervisor with Security Clearance

VTG • Permanent • Remote (Washington DC, United States) • $40 - $50 / * • 2d ago

Fully Remote

Overview VTG is seeking Telecommunications Technician 3 - Lead Technician/Supervisor located in Washington, D.C. What will you do? Familiar with a variety of complex installations, repairs telecommunications systems and...

2d ago

Apply

Remote - Temp Data Engineer (AWS EMR)

Addison Group • Contract • Remote (Washington, District of Columbia, United States) • 2w ago

Fully Remote

Position: Remote - Temp - Data Engineer (AWS EMR) Location: 100% Remote – U.S. only (working EST) Length: 3-5 Month Contract (Likely extension) Pay Rate: $50-$55/ hour w2 (Benefits eligible after 60 days) Work Auth: (...

2w ago

Apply

Cleared Network Engineer

Motion Recruitment • Remote (Arlington, Virginia, United States) • $70 - $90 / hour • 3w ago

Fully Remote

Cleared Network Engineer We are seeking an experienced Network Engineer with deep expertise in Cisco Nexus platforms and Cisco Identity Services Engine (ISE) to support a federal government program. This role will focus...

3w ago

Apply

Linux/VMware Engineer

Motion Recruitment • Remote (Arlington, Virginia, United States) • $70 - $90 / hour • 3w ago

Fully Remote

Cleared Linux/VMware Engineer We are seeking a VMware and Red Hat Enterprise Linux (RHEL) Systems Engineer to support a federal program. The engineer will design, implement, manage, and secure virtualized environments an...

3w ago

Apply

Copy Editor

Addison Group • Contract • Remote (Washington, District of Columbia, United States) • 1m ago

Fully Remote

Job Title: Copy Editor Industry: Nonprofit / Education / Healthcare Publishing Location (city, state): Washington, DC (Remote) Assignment Type: Contract (October 2025 – April 2026) Pay: $20 – $22/hour depending on experi...

1m ago

Apply

Project Manager- 100% Remote

Motion Recruitment • Remote (Arlington, Virginia, United States) • $60 - $75 / hour • 1m ago

Fully Remote

Project Manager This role is responsible for managing multiple customer onboarding projects and related initiatives, with a strong focus on process, analytics, and cross-functional coordination. Core tools include Servic...

1m ago

Apply

Benefits Manager

Addison Group • Contract • Remote (Reston, Virginia, United States) • 2m ago

Fully Remote

Job Title: Benefits Manager Location: Remote (must reside near a major airport) Industry: Human Resources / Professional Services Pay: $48 - $50 per/hour About Our Client: Addison Group is working with a respected nation...

2m ago

Apply

System Administrator

Addison Group • Contract • Remote (Washington, District of Columbia, United States) • 2m ago

Fully Remote

Title: System Administrator Pay: $55 - $65/ hour Location: 100% remote Overview: We are seeking a proactive and well-rounded Systems Admin to join our IT support team. This role is ideal for someone who thrives in a fast...

2m ago

Apply

Assessment Scoring Raters

Addison Group • Contract • Remote (Washington, District of Columbia, United States) • 2m ago

Fully Remote

Job Title: K–2 Literacy Assessment Scoring Rater (Remote) Location: Remote (U.S. based only; DC and NYC residents not eligible) Industry: Education / Assessment Services Pay: $14 - $15/ hour (no flexibility) Performance...

2m ago

Apply

Staff Accountant (Contract)

Addison Group • Contract • Remote (Washington, District of Columbia, United States) • 3m ago

Fully Remote

Job Title: Staff Accountant (Contract) Location: Fully Remote Duration: 4–6 Months Pay Rate: $30–$33/hour (W2) Start Date: ASAP Our client, a NPO located in Washington, DC, is looking to add on an experienced Staff...

3m ago

Apply