Data Modeler

Akkodis is seeking a Data Modeler role is a Contract with a client located in Ohio (Remote 100%). Ideally looking for applicants to have a solid background in ER Studio/ ERWIN, Informatica code, Tibco Data Virtualization (TDV), Kimball, Informatica, Azure, Datastage, Databricks would come as a big plus. Pay Range: $60-$75/hr. W2, The pay may be negotiable based on experience, education, geographic location, and other factors. DETAILED REQUIREMENTS: • Dimensional Modeling (Kimball Methodology): • 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. • Data Model Design & Documentation: • 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 supporting actionable insights and business friendly scalable analytics • Collaboration & Stakeholder Engagement: • 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. • Data Quality & Governance: • 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. DETAILED REQUIREMENTS: • Dimensional Modeling (Kimball Methodology): • 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. • Data Model Design & Documentation: • 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 supporting actionable insights and business friendly scalable analytics • Collaboration & Stakeholder Engagement: • 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. • Data Quality & Governance: • 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. • Tool & Platform Expertise: • 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. REQUIRED SKILLS: (Please BOLD top 3 required skills) • 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. • Excellent communication and collaboration skills. NICE TO HAVE SKILLS: • 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. If you are interested in this role, then please click APPLY NOW. For other opportunities available at Akkodis, or any questions, feel free to contact me at govind.choudhary@akkodisgroup.com. Equal Opportunity Employer/Veterans/Disabled Benefits offerings include but are not limited to: • 401(k) with match • Medical insurance • Dental Insurance • Vision assistance • Paid Holidays Off To read our Candidate Privacy Information Statement, which explains how we will use your information, please visit https://www.akkodis.com/en/privacy-policy. The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable: · The California Fair Chance Act · Los Angeles City Fair Chance Ordinance · Los Angeles County Fair Chance Ordinance for Employers · San Francisco Fair Chance Ordinance