JPS Tech Solutions · 1 month ago
Senior Data Modeler
District of Columbia, United States
Full-time
Hybrid
Senior LevelJPS Tech Solutions is seeking a Senior Data Modeler to support a key client in the D.C. area. This role is responsible for the design, governance, and optimization of the organization’s enterprise data assets, requiring collaboration with cross-functional teams to ensure data solutions are performant and maintain integrity across the data lifecycle.
Information TechnologyIT InfrastructureSoftware Engineering
Responsibilities
Lead the development of the conceptual, logical, and physical data models for all enterprise data systems, including RDBMS, ODS, Data Marts, and Data Lakes
Oversee the successful implementation of data models on target platforms (SQL/NoSQL) and ensure the translation of business requirements into structured data designs
Define, govern, and enforce data modeling and design standards, tools, and best practices for the enterprise data models
Oversee and govern the expansion of existing data architecture, ensuring alignment with strategic data management goals
Execute complex SQL queries for data analysis, data profiling, and validation to ensure referential integrity and data quality are consistently maintained
Work with business and application/solution teams to document data flows and develop detailed data models that support analytical and operational needs
Proactively identify and articulate issues and challenges in data design to reduce risks and ensure data structure scalability and optimization
Drive the optimization of data query performance across platforms via model tuning and best practices implementation
Qualification
Required
Extensive experience in developing and implementing conceptual, logical, and physical data models
Proven ability to work independently and collaboratively in a fast-paced environment, taking ownership of complex data initiatives
Expert-level experience in writing and optimizing SQL queries for data analysis, profiling, and integrity checks
In-depth knowledge of various data platforms, including RDBMS, Operational Data Stores (ODS), Data Marts, and Data Lakes
Experience with dimensional modeling (e.g., star schema, snowflake schema) and techniques for both relational and NoSQL platforms
Strong understanding of core data management concepts, including metadata management, data warehousing, and data lineage
Excellent communication and documentation skills, with the ability to translate complex data design concepts to both technical and non-technical stakeholders
Company
JPS Tech Solutions
JPS Tech Solutions offers software engineering, cloud, mobile development, and IT infrastructure solutions.
201-500 employees
H1B Sponsorship
JPS Tech Solutions has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (7)
2024 (17)
2023 (9)
2022 (5)
Funding
Current Stage
Growth StageCompany data provided by crunchbase