Vassar Labs

Job Title : Data Modeler

Vassar Labs IT Solutions Private Limited is a technology company focusing on delivering solutions into Primary sectors like Water, Agriculture, Smart City and Education by using emerging technologies like IoT, GIS, Telemetry Sensors, Crowdsourcing, Big Data, Machine Learning, Satellite Data, Drone Data etc. We provide real-time visibility into last mile processes & actionable insights through Decision Support systems.

- Vision - Enable Customers & Partners to bring new solutions and differentiated service offerings to the market, based on IoT and Big Data by Connecting "People", Processes", "Products" and "Peripherals" to the cloud.

- Line of business Providing End Mile visibility and Decision Support Systems for Higher Administrative Officers and Policy Makers of the Government in the primary sectors such as Water, Agriculture, Smart Cities etc.

Job Description :

The data modeler designs, implements, and documents data architecture and data modeling solutions, which include the use of relational, dimensional, and NoSQL databases. These solutions support enterprise information management, business intelligence, machine learning, data science, and other business interests.

The successful candidate will :

- Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).

- Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and :

- Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL) and data tools (reporting, visualization, analytics, and machine learning).

- Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models

- Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.

- Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.

- Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.

Skills :

- Bachelor's or master's degree in computer/data science technical or related experience.

- 5+ years of hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, ETL and data ingestion protocols).

- Experience with data warehouse, data lake, and enterprise big data platforms in multi-data-center contexts required.

- Experience with ETL/ELT pipelines is required

- Good knowledge of metadata management, data modeling, and related tools is required.

- Experience in team management, communication, and presentation.

- Experience in SQL, Schema normalization, and Schema design is required

- Proficiency in any programming language like (Java, C++, C#, ..etc.,.) is a plus.