Careers · Full time
Data Modeler
Siddhi TechSoft & Management · Ahmedabad, Gujarat
Posted on 01/03/2022
Responsibilities
What you will do
✓
Profile source system data with business and data SMEs and map it into target data warehouse models
✓
Create conceptual and logical data models, extending 3NF or conformed dimensional models, and define custom data marts
✓
Drive data analysis and modeling efforts (conceptual, logical and physical), as lead, sole or team modeler
✓
Assist in the architecture, design and development of the overall data warehouse and ETL architecture
✓
Establish, communicate and enforce best practices and standards
✓
Mentor and provide oversight to less senior members of the team
Job information
Industry
Computer
City
Ahmedabad
State/Province
Gujarat
Country
India
Zip/Postal code
382480
Requirements
✓
7+ years as a data analyst and modeler in a data warehouse, data lake, or operational data store environment
✓
5+ years recent experience creating complex relational (3NF) and dimensional models (Star, Snowflake)
✓
4+ years with healthcare payer (preferred) or provider data: claims, membership, enrollment and clinical data
✓
Experience performing data discovery, analysis and profiling
✓
Experience creating logical source-to-target mappings for batch and service-based data pipelines
✓
Very strong SQL query language skills
✓
Business and technical requirements elicitation, analysis and elaboration a plus
✓
Excellent verbal and written communication skills
✓
Author architecture and design documents, data flow diagrams and system run books, and drive their reviews
✓
Define and ensure compliance to best practices, including design and code reviews
✓
Participate in QA strategy, planning, and defect triage and prioritization
✓
Train and mentor team and customer resources throughout project execution
✓
Play a technical SME/lead role for architectural assessment, strategy and roadmap projects
TOOLS
Erwin or IBM InfoSphere Data ArchitectIBM Information Analyzer or equivalentToad, Embarcadero or equivalent SQL interpretersInterested in this role?
Contact us with your details. Call +91-8849481968 or email info@siddhitechsoft.com.
