Data Modeler

Description:
We have an exciting 100% remote opportunity for a Data Modeler with our industry-leading client.

Due to client requirement, applicants must be willing and able to work on a w2 basis. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance.

Rate: $70 - $75 / hr. w2

Responsibilities:

• Design and develop dimensional data models to support business intelligence, analytics, and reporting needs.
• Work alongside Business Analysts and Data Analysts to translate business requirements into effective data models and database designs for analysis and reporting purposes.
• Collaborate closely with Data Governance Analysts to ensure that data models align with data governance policies, standards, and regulatory requirements.
• Engage with ETL/Database Developers to support data integration efforts by providing detailed data mapping and transformation rules.
• Partner with Report Developers to ensure that data models support reporting and visualization needs, optimizing data structures for efficient querying and analysis.
• Conduct data profiling and analysis to assess data quality, consistency, and integrity, leveraging dimensional modeling techniques where appropriate.
• Create and maintain data mapping documents to support ETL processes and data integration efforts to ensure clarity and consistency.
• Implement and enforce data modeling standards, best practices, and guidelines across the organization, promoting consistency and reusability.
• Collaborate with cross-functional teams to integrate data from multiple sources and systems, ensuring data consistency and accuracy.
• Conduct impact analysis of proposed changes to data models and databases, evaluating potential risks and implications.
• As part of sanity check, validate the tables and views after development to ensure the developers effectively applied the logic we provided in the logical model.
• Perform performance tuning and optimization of data models and database queries, ensuring efficient data retrieval and processing.
• Analyze and resolve data modeling-related issues, addressing data quality concerns and discrepancies as they arise.

Experience Requirements:

• Bachelor's or Master's degree in Computer Science, Information Technology or any data related field of study.
• Minimum of 7 years of experience in data modeling, with a focus on dimensional modeling, data discovery, data profiling and data mapping.
• Proven track record of designing, developing, and maintaining complex logical data models in multiple subject areas.
• Proficiency in data modeling tools such as ER/Studio, ERwin or PowerDesigner.
• Strong proficiency in SQL for querying and manipulating data and experience with relational database management systems (RDBMS).
• Proven ability to work effectively with Data Governance Analysts, Business Analysts, Data Analysts, Database Developers, and Report Developers to ensure alignment and successful project delivery.
• Familiarity with data governance frameworks and regulatory requirements, ensuring data models adhere to organizational policies and standards.
• Understanding of clinical research processes, clinical trial data and regulatory requirements is not a must to have but it is a plus.
• Prior experience using Azure Synapse, Databricks is a plus.
• Ability to work collaboratively in a fast-paced and team-oriented environment.
• Understanding of Data Mesh
• Knowledge of what is a Data Product

Job ID: 386195

Skills, experience, and other compensable factors will be considered when determining pay rate. The pay range provided in this posting reflects a W2 hourly rate; other employment options may be available that may result in pay outside of the provided range.

W2 employees of Eliassen Group who are regularly scheduled to work 30 or more hours per week are eligible for the following benefits: medical (choice of 3 plans), dental, vision, pre-tax accounts, other voluntary benefits including life and disability insurance, 401(k) with match, and sick time if required by law in the worked-in state/locality.
Please be advised- If anyone reaches out to you about an open position connected with Eliassen Group, please confirm that they have an Eliassen.com email address and never provide personal or financial information to anyone who is not clearly associated with Eliassen Group. If you have any indication of fraudulent activity, please contact

About Eliassen Group:

Eliassen Group is a leading strategic consulting company for human-powered solutions. For over 30 years, Eliassen has helped thousands of companies reach further and achieve more with their technology solutions, financial, risk & compliance, and advisory solutions, and clinical solutions. With offices from coast to coast and throughout Europe, Eliassen provides a local community presence, balanced with international reach. Eliassen Group strives to positively impact the lives of their employees, clients, consultants, and the communities in which they operate.

Eliassen Group is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

Don't miss out on our referral program! If we hire a candidate that you refer us to then you can be eligible for a $1,000 referral check!

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.