FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in designing and implementing data architectures, including relational, data lake, and NoSQL solutions, while ensuring data governance and quality. Proficient in SQL and cloud services, particularly Microsoft Azure, to optimize data models and support analytical queries.
Highest-signal resume keywords
Data Architecture DesignSQL Query OptimizationMicrosoft Azure Cloud ServicesData Governance ImplementationData Modeling for OLAP Cubes
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
Data ModelingSQL Query LanguageData MigrationData Quality GovernanceCloud Data ArchitectureOLAP Cube DevelopmentNoSQL Database ImplementationData Lake DesignConceptual Data ModelsPhysical Data Models
Soft Skills
Client CollaborationDocumentation SkillsCommunication Skills
Tools & Technologies
Microsoft SQL ServerAzure Data LakeAzure SQLAzure SynapseAzure Analysis ServicesAzure DevOpsPythonSparkCI/CD AutomationAgile Methodology
Certifications & Qualifications
Azure Enterprise Data Analyst CertificationPublic Trust Clearance
Industry Keywords
Data GovernanceEnterprise Data CatalogData QualityMaster Data ManagementScaled Agile Framework (SAFe)
Tech Stack
Tools & technologiesAWSAzureCloudMS SQL ServerNoSQLPythonSparkSQL.NET
About the role
Key responsibilities & impact- Work with client and Leidos functional team members and business managers to analyze and translate business needs into long-term data architectures
- Define conceptual, logical, and physical data models supporting high-performance analytical queries in multiple subject areas
- Design and implement data architectures for relational, data lake, delta lake, medallion architecture, and NoSQL data stores
- Design and deliver solutions using Microsoft Azure cloud services, including Azure Data Lake, Azure SQL, Azure Analysis Services, and Azure Synapse
- Design and implement data models for OLAP cubes, star schemas, and subject-specific data marts
- Design and implement processes, functions, and tools for data migration, conversion, or refactoring of data models
- Provide guidance on data pipeline design and implementation
- Maintain data modeling and data architecture design standards, tools, and best practices
- Assist with data management and data governance implementation, including enterprise data catalog and data quality capabilities
- Suggest ideas to improve system performance and achieve cost efficiencies
- Establish common business definitions, conformed dimensions, reusable measures, reference data, and reusable data-modeling patterns
- Design reusable SQL-based metrics and detail layers in SQL Managed Instance or comparable relational platforms
- Align architectural decisions and implementation priorities with the enterprise data and analytics roadmap and PI Planning outcomes
- Evaluate and optimize SQL Managed Instance Gold-layer structures for performance, scalability, maintainability, and reuse
- Define reusable enterprise-level dimensions, measures, business rules, reference structures, and detailed data entities within the Gold/SQL MI layer
- Lead the design and implementation approach for subject-oriented data marts using reusable Gold-layer metrics, dimensions, and business logic
- Establish reusable Gold-layer metrics and detail layers in Azure SQL Managed Instance using stored procedures, views, and materialized views
- Align technology choices and technical decisions with the enterprise data and analytics roadmap and long-term modernization objectives
Requirements
What you’ll need- BS degree in Computer Science or related field and 8+ years of experience, or Master's with 6+ years of experience
- 5+ years experience designing conceptual, logical, physical data models
- 4+ years experience in cloud data architecture, including integration, data storage, and query architectures
- 4+ years developing and implementing data models for Microsoft SQL Server, star models, data marts, and SSAS OLAP cubes
- Experience developing and implementing models for data lake, Azure SQL, and NoSQL databases
- Experience with design of data backup and retention, data migration, and data quality
- Ability to work directly with client personnel at management and functional levels
- Ability to clearly document, explain, and obtain buy-in of designs and technical roadmap
- Very strong SQL query language skills, with experience optimizing data query performance
- Knowledge and understanding of Python, Spark, and .NET-based development
- Knowledge and experience with data governance, including metadata management, enterprise data catalog, design standards, data quality governance, and data security
- Experience with Agile process methodology, CI/CD automation, and cloud-based development (Azure, AWS)
- Ability to successfully obtain a government-issued Public Trust clearance
- US Citizenship
- Candidate must be a U.S. citizen who has resided in the U.S. for at least 3 years and be able to obtain a Public Trust
- Preferred: Experience developing Master Data Management solutions
- Preferred: Scaled Agile Framework (SAFe)
- Preferred: Experience working with Azure DevOps
- Preferred: Azure Enterprise Data Analyst certification
Benefits
Comp & perks- 10% travel is estimated to be required
