Lead Data Modeler

We are working with an exciting client looking to add a skilled Lead Data Modeler to the team to help with a cloud transformation project that will run for the next couple of years. In this role you will work with users from the business to understand requirements and create data models for a variety of business units using ER Studio. Ideally, we are looking for someone that has a background and experience with ETL tools like Informatica, DataStage, Tibco and others. This role is a long-term contract role that, approved through 1 year with likelihood to extend into 2027 & potentially beyond. Target compensation will vary depending on experience but we are targeting $65.00 - $84.00 per hour, W2. This would include medical, dental, vision insurance as well as 401k options and other benefits! Job Responsibilities for the Lead Data Modeler: • 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 Job Qualifications for the Lead Data Modeler: • 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). Location: Remote, US - Cleveland, Ohio Region Compensation Range: $60.00 - $82.00 per hour Type: Long-term contract If you are interested in this job as a Lead Data Modeler opportunity make sure to apply now for immediate consideration! Equal Opportunity Employer/Veterans/Disabled Benefit offerings include medical, dental, vision, term life insurance, short-term disability insurance, additional voluntary benefits, commuter benefits and 401K plan. Our program provides employees the flexibility to choose the type of coverage that meets their individual needs. Available paid leave may include Paid Sick Leave, where required by law; any other paid leave required by Federal, State or local law; and Holiday pay upon meeting eligibility criteria. Disclaimer: These benefit offerings do not apply to client-recruited jobs and jobs which are direct hire to a client. To read our Candidate Privacy Information Statement, which explains how we will use your information, please visit https://www.modis.com/en-us/candidate-privacy/ The Company will consider qualified applicants with arrest and conviction records.