Senior Data Modeler | Remotive.com

Job Description:

Qualifications:

•      Significant proven experience in applying rigorous data management principles and industry standard development approach to model complex and high-volume data assets to build, maintain conceptual, logical, and physical data models 

•         Demonstrable experience using data modeling tools – e.g., ErWin , SQLDBM

•         Evaluate existing data models and physical databases for variances and discrepancies 

•         Experience with managing meta data for data models 

•         Demonstrable experience in developing, publishing, and maintaining all documentation for data models 

•         Work with Business Analysts, Data Architects, Software developers, DBAs to achieve project objectives – delivery dates, cost objectives, quality objectives, business customer satisfaction objectives, etc. 

•         Create entity-relationship diagrams for relational systems and dimensional diagrams for the existing and proposed Data Warehouse, Data Marts, and data cubes 

•         Define ownership, obtain approvals, and communicate data models to Technology teams. Ensure consistent enterprise view and usage of data assets across the global functions and standards 

•         Provide architectural expertise in Data warehouse construction and engineering, data source identification, engineering, and migration on latest DB technologies – Snowflake

•         Provide feedback to Business Intelligence project and management team to improve data acquisition (structured and unstructured), warehousing methodologies and tools 

•         Experience in Agile development processes 

•         Ability to independently learn new technologies and data related approaches 

•         Effective writing and presentation skills 

•         Excellent problem solving skills, should possess a consulting mindset

•         Cross industry experience is preferred

Technical Skills

•         Data Modeling concepts (Advanced Level) 

•         ErWin, Snowflake, DB/MS SQLServer 

•         Modeling experience across large volume based environments 

•         Over-All understanding of Database space (Databases, Data Warehouses, Reporting, Analytics) 

•         Open to learn new technologies in-line with organizational needs / direction 

•         Well versed with Data Modeling platforms like Erwin, ER STUDIO etc. 

•         Good knowledge about Database Designing / Administration, Advanced Data Modeling for Star Schema design 

•         SQL query development for investigation and analysis 

•         Experience with the technologies in the Hadoop ecosystem like Hadoop, HDFS, Spark, and Hive is a plus 

•         Experience in working with modern cloud data platforms in AWS is a plus

•         Experience with Data Profiling Tools and BI tools like MicroStrategy will be plus