Today
Public Trust
Senior Level Career (10+ yrs experience)
Occasional travel
IT - Database
Remote/Hybrid•Washington, DC (On/Off-Site)
Data Modeler & Architect
Remote- Quarterly Travel to DC
Public Trust - Can start with it pending
Looking for an opportunity to make an impact?
Client is seeking a seeking a customer experience focused Data Modeler & Architect to bridge the gap between business needs and cutting-edge data solutions—translating customer challenges into powerful insights that drive innovation, efficiency, and strategic growth. As a Data Modeler & Architect, you will work directly with Client stakeholders to translate business needs into data models, ensuring data accuracy and efficiency for analysis and reporting. You will support a multi-functional team in creating, validating, and delivering reports, data extracts, dashboards, and other data products. Our ideal candidate is mission focused and delivery oriented, and applies critical thinking to create innovative functions and solve technical issues.
Who we are
Client is a Fortune 500® technology, engineering, and science solutions and services leader working to solve the world's toughest challenges in the defense, intelligence, civil, and health markets. Client Civil Group helps the government modernize operations with leading edge AI/ML driven data management and analytics solutions. We are a trusted partner to both government and highly-regulated commercial customers looking for transformative solutions in mission IT, security, software, engineering, and operations. We work with our customers including the FAA, DOE, DOJ, NASA, National Science Foundation, Transportation Security Administration, Custom and Border Protection, airports, and electric utilities to make the world safer, healthier, and more efficient.
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.
US Citizenship and ability to successfully obtain a government-issued Public Trust clearance.
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.
Remote- Quarterly Travel to DC
Public Trust - Can start with it pending
Looking for an opportunity to make an impact?
Client is seeking a seeking a customer experience focused Data Modeler & Architect to bridge the gap between business needs and cutting-edge data solutions—translating customer challenges into powerful insights that drive innovation, efficiency, and strategic growth. As a Data Modeler & Architect, you will work directly with Client stakeholders to translate business needs into data models, ensuring data accuracy and efficiency for analysis and reporting. You will support a multi-functional team in creating, validating, and delivering reports, data extracts, dashboards, and other data products. Our ideal candidate is mission focused and delivery oriented, and applies critical thinking to create innovative functions and solve technical issues.
Who we are
Client is a Fortune 500® technology, engineering, and science solutions and services leader working to solve the world's toughest challenges in the defense, intelligence, civil, and health markets. Client Civil Group helps the government modernize operations with leading edge AI/ML driven data management and analytics solutions. We are a trusted partner to both government and highly-regulated commercial customers looking for transformative solutions in mission IT, security, software, engineering, and operations. We work with our customers including the FAA, DOE, DOJ, NASA, National Science Foundation, Transportation Security Administration, Custom and Border Protection, airports, and electric utilities to make the world safer, healthier, and more efficient.
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.
US Citizenship and ability to successfully obtain a government-issued Public Trust clearance.
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.
group id: 10107773
