Job DescriptionJob DescriptionJob 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
Click on the below icons to share this job to Linkedin, Twitter!
Job DescriptionJob DescriptionJob 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
yes
Send Us Your Feedback
Sign
In
Please check your email. We have sent you a password reset link.
This link will expire in one hour.
Please input your account's email
Apply to Data Modeler & Architect
System One • Washington, District of Columbia
✓
Application Started!
Redirecting you to complete your application...
Get $5 added to your wallet for registering an account. Refer others and get $1 for each successful referral. Earn while you search for jobs and redeem in gift cards!Register to search from millions of jobs across the United States. Upload your resume and get matched with top employers today!
Welcome to SnapRecruit! Your account has been created via Google.
Get $5.00 Added to Your Wallet!
Upload your resume below and apply to this job to have $5.00 added directly to your wallet, activate your account, and qualify for high-priority employer matches.
Perks & Rewards You Receive with SnapRecruit:
$5.00 Resume Bonus
Added automatically to your wallet when you apply with your resume.
$1.00 Per Referral
Earn $1.00 cash rewards for every friend who joins SnapRecruit in the US.
Earn While You Search
Get credited $0.02 - $0.05 every time you explore sponsored job listings.
Amazon eGift Cards
Redeem your earned wallet funds for Amazon eGift Cards delivered to your email.
Get $5 added to your wallet for registering anRegister to search from millions of jobs across the United States. Upload your resume and get matched with top employers today!
account.
Refers others and get $1 for each successful referral.
Earn while you search for jobs and redeem in
gift cards!
Upload your resume for a free professional assessment
Loading, Please wait..!!
Send this job to my email
Please wait..!!
Confirmation
Are you sure?
List of resumes
Confirmation
It is working for Chrome Mozilla only for now
We use essential cookies to keep SnapRecruit secure and reliable. With your permission, we also use optional analytics, AI support chat, and push-alert cookies to improve your job search experience. You can change or withdraw your choice anytime.
Privacy Policy •
Cookie Policy •
Your Privacy Rights