Data Warehouse & BI – Data Modeler (Contract – Onsite – Menands, NY)

A prominent client in the Health and Human Services industry is actively seeking a highly skilled Data Warehouse & BI – Data Modeler (Contract – Onsite – Menands, NY) to join their EIM/Data Warehouse & BI team. This contract position, based onsite in Menands, New York, is crucial for supporting the Office of Mental Health. The ideal candidate will possess robust analytical skills, meticulous attention to detail, and a strong ability to collaborate with business owners, all of which are essential for improving the overall data quality of enterprise systems and making a tangible impact on public health initiatives.

Data Warehouse & BI – Data Modeler (Contract – Onsite – Menands, NY)

Location: Menands, New York – This is an Onsite role, requiring daily presence at the designated facility.

Employment Type: Contract

Pay Range: Competitive

Industry: Computer and Mathematical / Health and Human Services

What’s the Job? Architecting Data for Health and Human Services

As a Data Warehouse & BI – Data Modeler, you’ll be a foundational architect of information, directly shaping how data is organized, understood, and utilized to support the Office of Mental Health. Your expertise will ensure data quality, enhance reporting capabilities, and drive informed decision-making for critical public services.

• Review Existing Data Models and Recommend Changes: You will meticulously review existing data models to assess their current effectiveness, scalability, and alignment with evolving business requirements. Based on this comprehensive analysis, you will then recommend strategic changes to support both new and existing data requirements. This involves identifying areas for optimization, simplification, or expansion to ensure the data models can efficiently support evolving reporting, analytics, and application needs within the Health and Human Services domain.
• Analyze Source System Data for Redundancy and Duplication: A critical responsibility involves deeply analyzing source system data to proactively uncover instances of data redundancy and duplication. This requires a keen eye for detail and the ability to use data profiling tools and techniques to identify inconsistencies, inefficiencies, and potential data quality issues at their origin. Your work here directly contributes to improving data integrity and reducing storage overhead within enterprise systems.
• Maintain Conceptual, Logical, and Physical Data Models with Metadata: You will be responsible for the comprehensive maintenance of conceptual, logical, and physical data models, ensuring they accurately reflect the organization’s data landscape. This includes:
  • Conceptual Models: High-level representations of key business entities and their relationships.
  • Logical Models: Detailed, platform-independent designs defining entities, attributes, relationships, and primary/foreign keys.
  • Physical Models: Implementation-specific designs tailored to a particular database technology (e.g., Oracle), including tables, columns, data types, indexes, and constraints. Alongside these models, you will maintain corresponding metadata, which describes the data (e.g., definitions, sources, transformations, lineage), ensuring data governance and understanding across the organization.
• Perform Data Analysis, Discovery, Profiling, and Issue Resolution: You will actively perform data analysis, data discovery, and data profiling to gain deep insights into data characteristics, quality, and structure. Through this process, you will identify the root cause of data issues, such as inaccuracies, inconsistencies, or missing values. Crucially, you will then work collaboratively with the business team to resolve these data quality challenges, translating technical findings into business impacts and implementing solutions that improve the overall reliability of enterprise data.
• Review Models Created by Peer Data Modelers: To ensure adherence to best practices and consistency across the team, you will regularly review models created by peer data modelers. This involves conducting thorough peer reviews to verify that implementation standards are consistently applied, data modeling principles are followed, and the models meet the specified business and technical requirements. Your constructive feedback will contribute to the continuous improvement of the team’s data modeling capabilities.

What’s Needed? Essential Qualifications for an Expert Data Modeler

To excel as an Expert-level Data Modeler in this critical Health and Human Services environment, you’ll need extensive, specialized experience in data modeling tools, concepts, and database technologies.

• Expert-Level Data Modeling Experience (84+ Months): You must possess expert-level experience, totaling 84 months (7 years) or more, specifically with developing and maintaining logical and physical dimensional data models. This includes a deep understanding and practical application of sound data modeling concepts such as star schema, snowflake schema, and other dimensional modeling techniques crucial for efficient data warehousing and BI reporting. Your experience should also include building robust data migration strategies that ensure data integrity and consistency during system transitions.
• ER/Studio Data Architect Proficiency (66 Months): You must have a minimum of 66 months (5.5 years) of hands-on experience specifically with the ER/Studio Data Architect data modeling tool. This signifies your proficiency in using this industry-standard tool for creating, managing, and documenting complex data models, including reverse engineering databases and forward engineering schema changes.
• Relational Data Management and Oracle Technologies (66 Months): A minimum of 66 months (5.5 years) of experience in relational data management disciplines is required. This includes a strong understanding of relational database theory, database normalization, and query optimization. Furthermore, you must possess significant design and development experience using Oracle technologies, demonstrating your ability to work with one of the most widely used enterprise database platforms.
• SQL Programming Expertise (66 Months): You must have a minimum of 66 months (5.5 years) of expert-level experience with SQL programming. This includes writing highly complex queries, performing data manipulation (DML), defining data structures (DDL), optimizing query performance for large datasets, and potentially developing stored procedures or functions. Your SQL proficiency will be critical for data analysis, transformation, and validation tasks.

What’s In It For You: Impact, Growth, and Meaningful Contributions

This contract position as a Data Warehouse & BI – Data Modeler in Menands, NY, offers a compelling environment for professional growth and the chance to make a substantial, positive impact within the Health and Human Services sector.

• Opportunity to Work with a Leading Organization in Health and Human Services: You will have the invaluable opportunity to work with a leading organization in the Health and Human Services industry. This provides a unique chance to contribute your data modeling expertise to initiatives that directly benefit public health, mental health services, and community well-being, offering a profound sense of purpose.
• Chance to Collaborate and Improve Enterprise Data Quality: You’ll have the distinct chance to work with a collaborative team dedicated to improving the overall data quality of enterprise systems. Your contributions will directly impact the reliability, accuracy, and consistency of data used for critical decision-making, ensuring that insights are trustworthy and actionable.
• Opportunity to Develop and Maintain Critical Data Models: The role offers a continuous opportunity to develop and maintain crucial logical and physical dimensional data models. This hands-on experience will allow you to deepen your expertise in data architecture, schema design, and data governance, working with complex datasets that support vital public services.
• Experience with HIPAA and NYS Accessibility Standards: You will gain valuable experience with HIPAA (Health Insurance Portability and Accountability Act) requirements or similar industry-specific data privacy and security standards. Furthermore, you’ll work with NYS Accessibility Standards, ensuring that data solutions are compliant and accessible. This specialized knowledge is highly sought after in the healthcare and public sector domains.

If this Data Warehouse & BI – Data Modeler role in Menands, NY, aligns with your expert-level data modeling experience, particularly with dimensional modeling and Oracle technologies, and your desire to make a tangible difference in the Health and Human Services industry, we encourage you to learn more about this exciting contract opportunity. This is a chance to shape how critical health data is managed and utilized.

To take the next step in your career and potentially contribute to vital public health initiatives, click “Apply Now.” A recruiter will be in touch with you promptly to discuss this great opportunity in detail, answer any questions you may have, and guide you through the application process. We look forward to connecting with you and exploring how your expertise can contribute to improving data quality and public services!