Genesis10
Overview
Genesis10 is seeking a Data Modeler for a contract position with a leading client in Orrville, OH. This is a hybrid position. Compensation: $75.00-80.00 per hour W2. Responsibilities
Apply Kimball methodology to translate business requirements into dimensional models, focusing on user-friendly, business-driven views of data in ER Studio. Design and maintain star schemas, ensuring optimal query performance and ease of use for analytics and Data Science. Identify and define fact tables, dimension tables, surrogate keys, and conformed dimensions for cross-functional analysis. Develop conceptual, logical, and physical data models using ER Studio. Reverse engineer existing databases and create entity-relationship diagrams (ERDs) to document data structures and relationships. Maintain metadata, data dictionaries, and business process flow documents for all models. Translate business requirements and data constraints into robust dimensional models that support actionable insights and business-friendly scalable analytics. Work closely with business analysts, data owners, data producers, data engineers, data governance analysts and subject matter experts to fully understand objectives, decision making processes, gathering requirements and validating models. Engage with technical experts to assess the realities of source system data via high-level profiling and data validation for feasibility and integrity. Participate in sprint planning, backlog reviews, and hand-offs with data engineering and governance teams. Collaborate with other data modelers to create consistency in conformed dimensions across all analytics data. Ensure models adhere to data governance, security, and compliance standards. Validate data flows, enforce best practices, and review new requirements and changes to data pipelines. Support data quality initiatives and audit table requirements. Use ER Studio for model creation, documentation, and version control. Reimagine current state models on platforms such as Oracle, SQL Server, Informatica, Spotfire and Tibco TDV as needed. Requirements
Bachelor\'s degree in Computer Science, Information Systems, or related field. 7+ years of experience in data modeling for analytics or data warehousing with strong expertise in Kimball methodology, dimensional modeling, and star schema design. Proficiency with ER Studio or similar data modeling tools. 3+ years of Data Engineering experience with relational databases (Oracle Exadata, SQL Server, Informatica, Tibco Data Virtualization, Databricks or similar tools). Solid understanding of data governance, metadata management, and data quality principles. Preferred Experience
Experience with agile methodologies and sprint-based project delivery. Familiarity with business intelligence platforms and reporting tools. Ability to translate complex business requirements into scalable data models. Knowledge of data integration, ETL/ELT pipelines, and master data management. Excellent communication and collaboration skills. About Genesis10
Ranked a Top Staffing Firm in the U.S. by Staffing Industry Analysts for six consecutive years, Genesis10 puts thousands of consultants and employees to work across the United States every year in contract, contract-for-hire, and permanent placement roles. With more than 300 active clients, Genesis10 provides access to many of the Fortune 100 firms and a variety of mid-market organizations across the full spectrum of industry verticals. Benefits of Working with Genesis10
Access to hundreds of clients, most who have been working with Genesis10 for 5-20+ years. The opportunity to have a career-home in Genesis10; many of our consultants have been working exclusively with Genesis10 for years. Access to an experienced, caring recruiting team (more than 7 years of experience, on average). Behavioral Health Platform Medical, Dental, Vision Health Savings Account Voluntary Hospital Indemnity (Critical Illness & Accident) Voluntary Term Life Insurance 401K Sick Pay (for applicable states/municipalities) Commuter Benefits (Dallas, NYC, SF) Genesis10 is an Equal Opportunity Employer. Candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
#J-18808-Ljbffr
Genesis10 is seeking a Data Modeler for a contract position with a leading client in Orrville, OH. This is a hybrid position. Compensation: $75.00-80.00 per hour W2. Responsibilities
Apply Kimball methodology to translate business requirements into dimensional models, focusing on user-friendly, business-driven views of data in ER Studio. Design and maintain star schemas, ensuring optimal query performance and ease of use for analytics and Data Science. Identify and define fact tables, dimension tables, surrogate keys, and conformed dimensions for cross-functional analysis. Develop conceptual, logical, and physical data models using ER Studio. Reverse engineer existing databases and create entity-relationship diagrams (ERDs) to document data structures and relationships. Maintain metadata, data dictionaries, and business process flow documents for all models. Translate business requirements and data constraints into robust dimensional models that support actionable insights and business-friendly scalable analytics. Work closely with business analysts, data owners, data producers, data engineers, data governance analysts and subject matter experts to fully understand objectives, decision making processes, gathering requirements and validating models. Engage with technical experts to assess the realities of source system data via high-level profiling and data validation for feasibility and integrity. Participate in sprint planning, backlog reviews, and hand-offs with data engineering and governance teams. Collaborate with other data modelers to create consistency in conformed dimensions across all analytics data. Ensure models adhere to data governance, security, and compliance standards. Validate data flows, enforce best practices, and review new requirements and changes to data pipelines. Support data quality initiatives and audit table requirements. Use ER Studio for model creation, documentation, and version control. Reimagine current state models on platforms such as Oracle, SQL Server, Informatica, Spotfire and Tibco TDV as needed. Requirements
Bachelor\'s degree in Computer Science, Information Systems, or related field. 7+ years of experience in data modeling for analytics or data warehousing with strong expertise in Kimball methodology, dimensional modeling, and star schema design. Proficiency with ER Studio or similar data modeling tools. 3+ years of Data Engineering experience with relational databases (Oracle Exadata, SQL Server, Informatica, Tibco Data Virtualization, Databricks or similar tools). Solid understanding of data governance, metadata management, and data quality principles. Preferred Experience
Experience with agile methodologies and sprint-based project delivery. Familiarity with business intelligence platforms and reporting tools. Ability to translate complex business requirements into scalable data models. Knowledge of data integration, ETL/ELT pipelines, and master data management. Excellent communication and collaboration skills. About Genesis10
Ranked a Top Staffing Firm in the U.S. by Staffing Industry Analysts for six consecutive years, Genesis10 puts thousands of consultants and employees to work across the United States every year in contract, contract-for-hire, and permanent placement roles. With more than 300 active clients, Genesis10 provides access to many of the Fortune 100 firms and a variety of mid-market organizations across the full spectrum of industry verticals. Benefits of Working with Genesis10
Access to hundreds of clients, most who have been working with Genesis10 for 5-20+ years. The opportunity to have a career-home in Genesis10; many of our consultants have been working exclusively with Genesis10 for years. Access to an experienced, caring recruiting team (more than 7 years of experience, on average). Behavioral Health Platform Medical, Dental, Vision Health Savings Account Voluntary Hospital Indemnity (Critical Illness & Accident) Voluntary Term Life Insurance 401K Sick Pay (for applicable states/municipalities) Commuter Benefits (Dallas, NYC, SF) Genesis10 is an Equal Opportunity Employer. Candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
#J-18808-Ljbffr