Data Modeler & Architect
Washington, DC
Experience: 12
Education: BS
Category: Information Technology
Contractor Work Model: Hybrid
Brand: System One
Compensation Range: 66.20 Per Hour
Job ID: 380077
Date Posted: 09/14/2026
Shortcut: http://jobs.systemone.com/Tv2iJo
Job Title: Data Modeler & Architect
Location: Washington, DC (hybrid)
Type: Contract To Hire
Compensation: $66.20/HR on W2
Security Clearance: US Citizenship and ability to successfully obtain a government-issued Public Trust clearance
Responsibilities
- 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.
System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.
System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.
#M-M2
#LI-RF1
Ref: #851-Rockville-S1
-
Business Systems Analyst – FX Trading Platform Modernization
Salt Lake City, Utah
Job Title: Business Systems Analyst – FX Trading Platform Modernization Location: Salt Lake City, Utah Responsibilities Lead business analysis, strategic planning, and migration initiatives supporting the transition from legacy FX trading platforms, su...
Date Posted: 08/06/2026 Recommended
-
Business Systems Analyst – FX Trading Platform Modernization
Salt Lake City, Utah
Job Title: Business Systems Analyst – FX Trading Platform Modernization Location: Salt Lake City, Utah Work Mode : 5 Days Onsite Duration : Contract to Hire Responsibilities Lead business analysis, strategic planning, and migration initiatives supporti...
Date Posted: 08/06/2026 Recommended
-
Platform Engineer (DevOps)
Salt Lake City, Utah
Job Title: Platform Engineer (DevOps) Location: Salt Lake City, UT Responsibilities • Design, build, and optimize enterprise CI/CD pipelines using GitHub Actions and other modern DevOps platforms • Administer enterprise Source Code Management (SCM) rep...
Date Posted: 08/06/2026 Recommended
-
Mainframe Developer (COBOL, CICS, DB2)
Salt Lake City, UT
Job Title: Mainframe Developer (COBOL, CICS, DB2) Description: Mainframe Developer (COBOL, CICS, DB2) Position Description Are you an experienced Mainframe Developer (COBOL, CICS, DB2) looking to work on mission critical enterprise systems that support...
Date Posted: 07/28/2026 Recommended
-
Senior Construction Electrical Engineer
Lake Mary, FL
Job Title: Senior Construction Electrical Engineer Location: Lake Mary, FL 32809 Type: Direct Hire Compensation: $115,000 - $135,000/yr Work Model: Onsite Hours: 40.0 Security Clearance: Not specified Overview System One is seeking a Senior Constructio...
Date Posted: 07/22/2026 Recommended
-
Network Engineer
Salt Lake City, Utah
Job Title: Network Engineer Location: Salt Lake City UT Type: Contract to Hire Work Model: Onsite – onsite Hours: 40.0 Security Clearance: Not specified Responsibilities • Design, implement, and maintain scalable, secure, resilient, and highly availabl...
Date Posted: 08/26/2026 Recommended
-
Data Management Specialist II
Washington, DC
Job Title: Data Management Specialist II Location: Washington, DC Type: Contract Compensation: Not specified Work Model: onsite Hours: 40 hours per week Clearance: Public Trust $52.09/hr Responsibilities Administer and support Azure cloud resources, in...
Date Posted: 08/31/2026 Recommended
-
Mainframe Developer (COBOL, CICS, DB2)
Salt Lake City, UT
Mainframe Developer – COBOL, CICS, DB2 6 Months Contract-to-Hire Midvale, UT and Salt Lake City, Utah Position Overview Seeking an experienced Mainframe Developer to develop, maintain, enhance, and support mission-critical enterprise applications. The ...
Date Posted: 07/30/2026 Recommended
-
Energy Storage Pre-Construction Manager
Lake Mary, FL
Job Title: Energy Storage Pre-Construction Manager Location: Lake Mary, FL Type: Direct Hire Work Model: Onsite – onsite Overview System One is seeking a storage pre-construction manager for a full-time position in Lake Mary, FL. The Manager of Constru...
Date Posted: 08/06/2026 Recommended
-
Mechanical Designer
Salt lake City, Utah
Job Title: Mechanical Designer Location: Salt lake City, Utah Type: Contract To Hire Compensation: $38.46 - $57.69 Work Model: Hybrid – onsite and remote Hours: 40.0 Responsibilities Execute mechanical and piping design activities for infrastructure, i...
Date Posted: 07/09/2026 Recommended
-
Business Intelligence Analyst – Power BI
Washington, DC
Job Title: Business Intelligence Analyst – Power BI Location: Washington, DC Type: Contract Compensation: $45.92 - $55.00 per hour Work Model: Onsite – onsite Hours: 40.0 hours per week Security Clearance: Ability to obtain Public Trust Clearance Respo...
Date Posted: 08/31/2026 Recommended
-
Electrical Engineer II
Lake Mary, FL
Job Title: Electrical Engineer Location: Lake Mary, FL Type: Direct Hire Work Model: Hybrid – onsite Overview System One is seeking an Electrical Engineer for a full-time position in Lake Mary, FL. This position is responsible for designing the electri...
Date Posted: 07/23/2026 Recommended
-
Platform Engineer (DevOps)
Salt Lake City, Utah
Job Title: Platform Engineer (DevOps) Location: Salt Lake City, UT Work Mode : 5 Days Onsite Duration : Contract to Hire Responsibilities • Design, build, and optimize enterprise CI/CD pipelines using GitHub Actions and other modern DevOps platforms • ...
Date Posted: 08/06/2026 Recommended
-
Data & Systems Analyst
McLean, VA
Job Title: Data & Systems Analyst - Modernization Location: McLean, VA – can be Remote (EST) Type: Contract to Hire Clearance: Ability to obtain a Federal/DoD Public Trust. Active Public Trust preferred About the Role The Data Analyst will support the ...
Date Posted: 08/25/2026 Recommended
-
Technical Systems Analyst
Arlington, VA
Senior Technical Systems Analyst 6 Month Contract to Hire Active Secret Clearance or higher 4 days a week on-site, Arlington, VA Hourly Rate: $75/hr to $80/hr. W2. Benefits available Overview System One is seeking an experienced Technical Systems Analy...
Date Posted: 08/28/2026 Recommended
-
PL/SQL Developer
McLean, VA
Job Title: PL/SQL Developer Responsibilities • Support application development, database engineering, data integration, analytics enablement, and operational database activities for the GrantSolutions platform. • Design, develop, test, maintain, and op...
Date Posted: 08/25/2026 Recommended
-
Electrical Engineer III
Lake Mary, FL
Job Title: Electrical Engineer Location: Lake Mary, FL Type: Direct Hire Work Model: Onsite – onsite Overview System One is seeking an Electrical Engineer for a full-time position in Lake Mary, FL. This position is responsible for leading and designing...
Date Posted: 07/23/2026 Recommended
-
Senior Mechanical Engineer
Salt lake city, Utah
Job Title: Senior Mechanical Engineer Location: Salt Lake City, Utah Type: Contract To Hire Compensation: $67.30 - $79.32 per hour Work Model: Hybrid – onsite and remote Hours: 40.0 Responsibilities Lead the mechanical design and technical execution of...
Date Posted: 07/08/2026 Recommended
-
Design Manager
Salt Lake City, UT
Job Title: Design Manager Location: Salt Lake City, UT Type: Direct Hire Compensation: $120,000.00 - $153,000.00 Work Model: Onsite Overview The IS Design Manager is responsible for the design production throughout the life cycle of a project from deve...
Date Posted: 07/21/2026 Recommended
-
Welding Inspector
Salt Lake City, UT
Job Title: Welding Inspector Location: Salt Lake City, UT Type: Direct Hire Compensation: $66,000.00 - $93,000.00 Work Model: Onsite – onsite Responsibilities Inspect, test, and verify welded car bodies to confirm they meet quality standards and indust...
Date Posted: 09/14/2026 Recommended
-
Mechanical Engineer
Salt lake city, Utah
Job Title: Mechanical Engineer Location: Salt lake city, UT Type: Contract To Hire Compensation: $52.88 - $67.3 Work Model: Hybrid – onsite and remote Hours: 40.0 Responsibilities Lead the mechanical engineering and design execution of industrial proje...
Date Posted: 07/08/2026 Recommended
-
Quality Control Associate Technician
Salt Lake City, UT
Job Title: Quality Control Associate Technician Location: Salt Lake City, UT Type: Contract Work Model: Onsite Hours: 4x10s, Monday-Thursday, 5:00am-3:30pm Responsibilities: Performs functions associated with quality control and quality assurance opera...
Date Posted: 09/04/2026 Recommended
-
Cloud Developer
35801, Alabama
Cloud Developer – Active Top Secret Required Onsite – Huntsville, Alabama Open Systems Technologies Corporation is seeking a Cloud Developer to support BAE Systems and a large SOC enterprise environment in Huntsville, Alabama. This is an onsite positio...
Date Posted: 07/28/2026 Recommended
-
Senior Solution Architect
Salt Lake City, Utah
Job Title: Senior Solution Architect Client Location: Salt Lake City, Utah Type: Contract To Hire Work Model: Onsite Experience * 8+ years of progressive experience in software engineering, solution architecture, or enterprise application development *...
Date Posted: 08/06/2026 Recommended
-
Senior Solution Architect
Salt Lake City, Utah
Job Title: Senior Solution Architect Client Location: Salt Lake City, Utah Type: Contract To Hire Work Model: Onsite Experience * 8+ years of progressive experience in software engineering, solution architecture, or enterprise application development *...
Date Posted: 08/06/2026 Recommended
-
Senior IT Data Engineer (onsite)
Washington , DC
Senior IT Data Engineer Washington, DC – onsite US citizenship required per government contact Must be able to obtain Public Trust clearance Type: Multi-Year Contract supporting Federal Reserve Board Open to W2 and C2C Must apply by 12pm on July 2nd Th...
Date Posted: 06/30/2026 Recommended
-
Data Architect- Wealth Management
Naperville, Illinois
Job Title: Data Architect- Wealth Management Location: Naperville, IL Type: Direct Hire Compensation: Open Work Model: Onsite Hours: 40.0 Security Clearance: N/A Responsibilities Design and maintain the end to end data architecture for the Wealth Manag...
Date Posted: 07/15/2026 Recommended
-
Mechanical Assembler
Salt Lake City, Utah
Job Title: Mechanical Assembler Location: Salt Lake City, Utah Type: Contract To Hire Contractor Work Model: Onsite Position Summary: The Mechanical Final Assembler is responsible for the mechanical and structural assembly of rail vehicles in accordanc...
Date Posted: 08/26/2026 Recommended
-
Senior Solution Architect
Pittsburgh , Pennsylvania
Job Title: Senior Solution Architect Client: Client Location: Salt Lake City, Utah, United States Type: Contract To Hire Work Model: Onsite – onsite Hours: 40.0 Security Clearance: Not specified in the provided information Overview Responsibilities * S...
Date Posted: 08/06/2026 Recommended
-
Field Designer
Rice Lake, Wisconsin
Job Title: Field Designer Location: Rice Lake, Wisconsin Type: 6 month Contract Compensation: $30.00 - $31.50 hourly Contractor Work Model: Hybrid Hours: Monday and Friday remote, Tues - Thurs office or on-site (30% field work) System One is currently ...
Date Posted: 08/28/2026 Recommended