Special Vendor Mark-up: 22.80%, Minimum Wage Rate: -, Maximum SRP Rate: -
Hybrid: Candidate MUST be on-site every 4th Wednesday of the month.
Roles and Responsibilities
The Senior Business Domain Data Modeler will, at minimum, perform the following:
•Implement and maintain data models that accurately represent business requirements.
•Enhance existing data models to improve efficiency, data quality and user-friendliness.
•Perform regular data reconciliation tasks to identify and resolve discrepancies between different data sources.
•Monitor, assess, and improve data quality to ensure accuracy, consistency and completeness.
•Implement and validate business rules to ensure compliance with organizational policies and objectives.
•Ensure that all business rules and logic changes are reflected accurately across the data architecture.
•Test and validate any changes made to data logic to ensure correctness and consistency using Validatar tool.
•Identify and implement opportunities for data enhancements to improve data quality and efficiency.
•Maintain thorough and accurate documentation of all data processes, changes and enhancements.
•Assist with the design and modification of the EASE Data Warehouse Solution
•Create and optimize data models to support health information analytics
•Collaborate with the Analytics Manager, Data Scientists and EASE uses to develop and design
•Information Marts to support self-service for business queries and data visualization
•Create documentation and/or training materials for new users
•Provide operational support for Business Intelligence Tools
Minimum Qualifications
•At least 5 years of Data warehouse modeling experience
•Cloud Architecture skills
•3 years of SQL experience
•2 years of WhereScape RED and 3D experience
•1 year of Snowflake experience
•BA or BS in Business Information Systems, Information Technology, Computer Science or related field.
•Extremely strong analytical, critical thinking and problem-solving skills
•Excellent speaking and writing skills
•Attention to detail
•High personal and professional integrity
•Collaborate well with a team
•Manages time well
•Familiarity with WhereScape, Validatar, Snowflake, Jira, Confluence, BOX, Amazon Web Services, Tableau.
Preferred Qualifications
•Bachelor's degree as mentioned above.
•Strong understanding of data management principles.
•Experience in creating conceptual, logical, and physical data models.
•Hands-on experience with data modeling projects.
•Business analysis experience.
•Desired Skills
•Results orientation, willingness to commit to a direction and drive operations to completion
•Demonstrated ability to manage adversity and challenging situations
•Ability to articulate vision of transformation efforts
•High personal and professional integrity
•Ability to develop cooperative and constructive relationships
•Ability to collaborate with a team
• Ability to identify and understand the existing organizational culture
• • Ability to build trust and cooperation amongst a team
| Skill | Required /Desired | Amount | of Experience |
|---|---|---|---|
| Experience in Data Modeling | Required | 5 | Years |
| Wherescape RED and 3D experience | Required | 2 | Years |
| Snowflake experience | Required | 1 | Years |
| AWS Cloud experience | Required | 1 | Years |
| SQL, Stored Procedure experience | Required | 5 | Years |
| Validatar, Jira, Confluence, BOX, Amazon Web Services, Tableau | Highly desired | 0 |
| No. | Question |
|---|---|
| Question1 | Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you agree to this requirement? |
| Question2 | What is your candidate's email address? |
| Question3 | If selected for engagement, your candidate's hourly Pay Rate must be at least -? Your candidate can be paid more; however, the hourly SRP Rate cannot exceed -? Do you agree to these requirements? |
| Question4 | The maximum mark-up for this engagement’s SRP rate is 22.80%. To be competitive on pricing, a mark-up below the 22.80% threshold is suggested. Do you agree to propose a mark-up at or below 22.80%? |
| Question5 | This assignment is contingent upon customer renewal and availability of adequate funding. Do you agree to this requirement? |
| Question6 | If selected for engagement, your candidate will be expected to start no later than 2 weeks (10 business days) after the client's selection date? Do you agree to this requirement? |
| Question7 | Hybrid: Candidate MUST be in the office every 4th Wednesday of the month. Do you and your candidate accept this requirement? |
| Question8 | What is the current location of your candidate? |