Data Modeler

The Data Modeler is responsible for designing, developing and managing the data models that support operational, real-time and analytical applications. The Data Modeler will work in a collaborative team environment to assess requirements, define data modelling strategy and deliver solutions. The Data Modeler must also have a strong hands-on experience in designing data model and mapping with strong Healthcare domain and Operational Insights knowledge., * Design/Develop/Maintain data models (including Business/Conceptual, Logical and Physical models) that support operational, real-time and analytical applications

• Create optimized data designs that facilitate consistency, reuse and ensure efficient storage and retrieval and limit data duplications
• Developing models in IBM IDA, ERStudio, ERWin tools
• Use data modeling to create a common language with visual references to describe data and its relationships across business domains
• Design and map business entities/attributes across Operational Insights Hub
• Design and map logical/physical entities/attributes for Operational Insights Hub
• Conduct data profiling and analysis to identify data quality issues and propose solutions for data cleansing and enrichment
• Establishes team operational plans, develops/implements new processes, standards, and operational plans that impact results, develops technical roadmaps
• Collaborates with internal and external teams to ensure timely, high-quality solutions
• Model/fine tune data models for relational, columnar and no-sql databases
• Perform Source to Target mapping (covering conceptual, logical and physical models)
• Influences others in technical decision-making / technology adoption in assigned domain
• Arrive at solutions including data flow diagrams, process diagrams, use case models as required

• Bachelor’s or Master’s degree preferably in Computer Science or Information Technology or related field
• 10+ years of experience in data and analytical engagements with at least 5 years in data modeling role
• Healthcare domain experience required
• Advanced knowledge in data modeling techniques such as Business process Model, Entity Relationship, dimensional modeling, data vault, etc
• Implementation experience in cloud architecture patterns particularly in Google Cloud Platform
• Strong SQL and programming language experience
• Experience in Git, Jira and Confluence tools
• Comprehensive knowledge of agile development methodologies
• Hands on experience in IBM IDA, ER/Studio, ERWin tools
• Demonstrated experience modelling for Data warehousing, operational store and real time applications
• Strong Data Architecture experience
• Exposure to Solar Winds, Tanium/Forescout, Market Ops tracker ServiceNow systems and underlying data
• Ability to collaborate across multiple work locations/teams
• Ability to deliver on ambiguous projects with incomplete information Advanced verbal / written / presentation skills

Education

• Bachelors or Masters in Information Technology, Computer Science or relevant field.

Apptad offers strategic consulting, enterprise information management and digital transformation services. With globally connected offices in US and India along with a team of trained and certified IT resources, Apptad ensures quick and effective delivery to its customers.Apptad is relentlessly reinventing the outlook of how companies leverage data.

With an effort to enable our customers the ability to solve biggest problems within their organization.We perceive our clients problems and respond with custom solutions instead of handing over boilerplate responses.

OUR MISSION

Customer Focus: We listen carefully to the needs of our clients so that we know what s important for their business and can design a customized solution for their business.

Innovation: As a firm, we believe in constantly upgrading ourselves and improving our solutions to adapt to the changing landscape of technology.

Accountability and Ethics: We believe in taking our commitments as seriously as our customers and living up to them while building trust for a long term business relationship.