Senior Data Modeler

Job Summary 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 the 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. This role requires defining and enforcing enterprise data modeling standards and best practices, working independently to meet business requirements, and collaborating with cross-functional teams to ensure all data solutions are highly performant, scalable, and maintain data integrity across the entire data lifecycle. location: Washington, Washington, D.C. job type: Contract salary: $65 - 75 per hour work hours: 9am to 5pm education: Bachelors Responsibilities • Design and Model Development: Lead the development of the conceptual, logical, and physical data models for all enterprise data systems, including RDBMS, ODS, Data Marts, and Data Lakes. • Platform Implementation: Oversee the successful implementation of data models on target platforms (SQL/NoSQL) and ensure the translation of business requirements into structured data designs. • Governance and Standards: Define, govern, and enforce data modeling and design standards, tools, and best practices for the enterprise data models. • Architecture Oversight: Oversee and govern the expansion of existing data architecture, ensuring alignment with strategic data management goals. • Data Quality & Analysis: Execute complex SQL queries for data analysis, data profiling, and validation to ensure referential integrity and data quality are consistently maintained. • Collaboration: Work with business and application/solution teams to document data flows and develop detailed data models that support analytical and operational needs. • Risk Mitigation: Proactively identify and articulate issues and challenges in data design to reduce risks and ensure data structure scalability and optimization. • Optimization: Drive the optimization of data query performance across platforms via model tuning and best practices 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, 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. Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status. At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility). This posting is open for thirty (30) days.