Brillio is forging ahead aggressively amidst the current COVID-19 situation and continues to hire for various roles globally - with all interviewing and on-boarding done virtually. Brillio has invested in the right capabilities to adapt to the new normal and empower its employees to operate seamlessly. All the new joiners, along with the Brillio family, will temporarily work remotely until it is safe to return to our offices. Read Brillios Chief Operating and Delivery Officer, Aftab Ullahs statement about Brillio's hiring plans in the leading publications - The Times of India and The Weeks latest stories about the positive hiring sentiments of tech firms. 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 Evaluate existing data models and physical databases for variances and discrepancies Experience with managing meta data for data models Experience with large-scale, Hadoop big data methods, such as Spark, Scala, NiFi, 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 MemSQL, Sybase IQ, NoSQL Provide feedback to Business Intelligence project and management team in order 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 Technical Skills Data Modeling concepts (Advanced Level) ErWin, DB/MS SQLServer, MemSQL, NoSQL experience is must. Modeling experience across large volume based (Tb/Petabytes) environments Over-All understanding of Database space (Databases, Data Warehouses, Reporting, Analytics) Open to learn new technologies in-line with organizational needs / direction Experience with the technologies in the Hadoop ecosystem like Hadoop, HDFS, Spark, and Hive. Additional skillset of MapReduce and Pig is plus Well versed with Data Modeling platforms like Erwin, ER STUDIO etc. Strong skills in Entity Relationship Modeling (ERWin modeling software preferred) Good knowledge about Database Designing / Administration, Advanced Data Modeling for Star Schema design Good understanding of Normalized / Denormalized / Star / Snowflake design concepts SQL query development for investigation and analysis