> Markdown version of [/jobs/ext/2590441-deltek-data-architect-data-modeler-hybrid](https://www.wearedevelopers.com/jobs/ext/2590441-deltek-data-architect-data-modeler-hybrid). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Deltek Data Architect/ Data Modeler (Hybrid) - **Company:** Frederick National Laboratory - **Location:** Frederick, MD, United States - **Experience:** Expert - **Salary:** $123,800.0 - $207,125.0 - **Contract:** Permanent contract - **Skills:** Big Data, Cloud Database, Cloud Engineering, Computer Programming, Databases, Costpoint, Data Architecture, Data Governance, Data Integration, Extract Transform Load (ETL), IBM Cognos Business Intelligence, Microsoft SQL Server, SQL Azure, Oracle Databases, Oracle (Applications), Performance Tuning, Query Optimization, Azure Data Lake, SQL Stored Procedures, SQL Databases, SQL Server Integration Services, Systems Integration, Enterprise Data Management, Data Processing, Cloud Platform System, Azure Data Factory, Database Optimization, Star Schema, Data Management, Cloud Migration, Azure Synapse Analytics, Data Pipelines - **Published:** August 31, 2026 - **Apply:** https://www.biospace.com/logon?PipelinedPage=%2Fjob%2F3071551%2Fdeltek-data-architect-data-modeler-hybrid-%3FAction%3DContinueJobApplication%23application-form ## About the Role To be considered for this position, you must minimally meet the knowledge, skills, and abilities listed below: * Possession of Bachelor's degree from an accredited college/university according to the Council for Higher Education Accreditation (CHEA) or four (4) years relevant experience in lieu of degree. Foreign degrees must be evaluated for U.S. equivalency. * In addition to the education requirement, a minimum of eight (8) years of experience in data integration, ETL, and data modeling roles. * Demonstrated experience designing enterprise analytics platforms, not just developing pipelines. * Proven ability to translate complex ERP data structures into clean, business-friendly analytical models. * Experience leading cloud migration or modernization initiatives for data platforms. * Deltek Costpoint / ERP. Extensive experience working with Deltek Costpoint (or other ERP), with strong understanding of Accounting, Projects, People, and related financial/process data flows. * Business Intelligence Integration. Familiarity integrating modeled data with Cognos and other enterprise BI platforms. * Data Modeling, Expert Level. Proven expertise in enterprise data modeling, including star/snowflake schemas, financial and project accounting models, slowly changing dimensions, and fact table design. * Database Platforms. Advanced mastery of SQL Server and/or Oracle databases, including query optimization, indexing strategies, and large-scale data transformations. * Strong communication skills with the ability to collaborate across IT, finance, and business stakeholders. * Ability to work on site in Frederick, MD a minimum of one (1) day per week. * Ability to obtain and maintain a security clearance. PREFERRED QUALIFICATIONS Candidates with these desired skills will be given preferential consideration: * Azure Data Ecosystem. Strong knowledge of Azure SQL DB, ADLS, Synapse Analytics, and modern cloud data architecture patterns. * Integration & ETL Architecture. Deep, hands-on expertise with SSIS and Azure Data Factory (or similar technologies), including complex orchestration, dependency management, error handling, and monitoring at scale. * Programming & Automation. Experience with Python for data transformation, automation, or integration enhancements. ## Description * Deltek Costpoint Data & Reporting Architecture. Serve as a subject matter expert for Deltek Costpoint data architecture, deeply understanding Admin, System, Transactional, Time & Expense, and Project schemas, and translating them into optimized analytical models. * Enterprise Data Modeling Leadership. Lead the design and governance of enterprise-grade data models (conceptual, logical, and physical), including dimensional and relational models, to support Costpoint analytics, financial reporting, and executive BI. * Enterprise BI Modernization. Lead the conversion of legacy databases, converting Oracle Stored Procedures to reduced and OOTB transformation model. * Performance & Scalability Engineering. Drive performance optimization across data models, SQL logic, and integration pipelines, ensuring solutions scale with business growth and reporting demand. * Advanced Data Integration Architecture. Architect and implement complex, high-volume data integration solutions using SSIS, Azure Data Factory, and cloud-native patterns, integrating Deltek Costpoint with downstream analytics platforms. * Cloud Data Platform Design. Design and evolve cloud-based data architectures leveraging Azure SQL Database, Azure Data Lake Storage, Azure Synapse Analytics, and related services to support scalable, future-state analytics. * Data Governance & Integrity. Establish and enforce data quality, integrity, security, and lineage standards across all integration and modeling layers. * Technical Leadership & Standards. Define and manage transformation project/tasks; Provide technical guidance and mentorship to developers and analysts; Define operational approach for ETL/ELT. ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [The Biggest German Tech Companies](https://www.wearedevelopers.com/magazine/424-the-biggest-german-tech-companies)