JPS Tech Solutions
Senior Data Modeler
JPS Tech Solutions
Job Location:
District of Columbia, Washington
Job Type:
Hybrid
Compensation:
Depends on Experience
W2 Status:
W2-Contract Only; applications on a C2C basis will not be considered.
This Senior Data Modeler role, supporting a key Randstad client in the D.C. area, is responsible for the design, governance, and optimization of the organization’s enterprise data assets. The ideal candidate will be a hands‑on technical leader, architecting conceptual, logical, and physical data models for various platforms including traditional RDBMS, Operational Data Stores (ODS), Data Marts, and modern Data Lakes on SQL/NoSQL platforms. They will define and enforce enterprise data modeling standards and best practices, work independently to meet business requirements, and collaborate with cross‑functional teams to ensure all data solutions are highly performant, scalable, and maintain data integrity across the entire data lifecycle.
Responsibilities
Lead development of conceptual, logical, and physical data models for all enterprise data systems.
Oversee implementation of data models on target platforms (SQL/NoSQL) and translate business requirements into structured data designs.
Define, govern, and enforce data modeling and design standards, tools, and best practices.
Oversee and govern expansion of existing data architecture, ensuring alignment with strategic data management goals.
Execute complex SQL queries for data analysis, profiling, and validation to ensure referential integrity and data quality.
Document data flows and develop detailed data models in collaboration with business and application teams.
Identify and articulate issues and challenges in data design to mitigate risks and ensure scalability and optimization.
Drive optimization of data query performance across platforms via model tuning and best practice implementation.
Qualifications
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, 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: metadata management, data warehousing, and data lineage.
Excellent communication and documentation skills; ability to translate complex data design concepts to technical and non‑technical stakeholders.
#J-18808-Ljbffr
Job Location:
District of Columbia, Washington
Job Type:
Hybrid
Compensation:
Depends on Experience
W2 Status:
W2-Contract Only; applications on a C2C basis will not be considered.
This Senior Data Modeler role, supporting a key Randstad client in the D.C. area, is responsible for the design, governance, and optimization of the organization’s enterprise data assets. The ideal candidate will be a hands‑on technical leader, architecting conceptual, logical, and physical data models for various platforms including traditional RDBMS, Operational Data Stores (ODS), Data Marts, and modern Data Lakes on SQL/NoSQL platforms. They will define and enforce enterprise data modeling standards and best practices, work independently to meet business requirements, and collaborate with cross‑functional teams to ensure all data solutions are highly performant, scalable, and maintain data integrity across the entire data lifecycle.
Responsibilities
Lead development of conceptual, logical, and physical data models for all enterprise data systems.
Oversee implementation of data models on target platforms (SQL/NoSQL) and translate business requirements into structured data designs.
Define, govern, and enforce data modeling and design standards, tools, and best practices.
Oversee and govern expansion of existing data architecture, ensuring alignment with strategic data management goals.
Execute complex SQL queries for data analysis, profiling, and validation to ensure referential integrity and data quality.
Document data flows and develop detailed data models in collaboration with business and application teams.
Identify and articulate issues and challenges in data design to mitigate risks and ensure scalability and optimization.
Drive optimization of data query performance across platforms via model tuning and best practice implementation.
Qualifications
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, 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: metadata management, data warehousing, and data lineage.
Excellent communication and documentation skills; ability to translate complex data design concepts to technical and non‑technical stakeholders.
#J-18808-Ljbffr