Senior Data Engineer - Data Modeling

EXPERTISE AND QUALIFICATIONS

As a Senior Data Engineer you will work to solve some of the organizational data management problems that would enable them

as a datadriven organization; Seamlessly switch between roles of an Individual Contributor team member and Data Modeling lead

as demanded by each project to define design and deliver actionable insights.

On a typical day you might

Engage the clients & understand the business requirements to translate those into data models.

Create and maintain a Logical Data Model (LDM) and Physical Data Model (PDM) by applying best practices to provide business

insights.

Contribute to Data Modeling accelerators

Create and maintain the Source to Target Data Mapping document that includes documentation of all entities attributes data

relationships primary and foreign key structures allowed values codes business rules glossary terms etc.

Gather and publish Data Dictionaries.

Involve in maintaining data models as well as capturing data models from existing databases and recording descriptive

information.

Use the Data Modelling tool to create appropriate data models.

Contribute to building data warehouse & data marts (on Cloud) while performing data profiling and quality analysis.

Use version control to maintain versions of data models.

Collaborate with Data Engineers to design and develop data extraction and integration code modules.

Partner with the data engineers to strategize ingestion logic and consumption patterns.

Expertise and Qualifications

What do we expect

6 years of experience in Data space.

Decent SQL skills.

Significant experience in one or more RDBMS (Oracle DB2 and SQL Server)

Realtime experience working in OLAP & OLTP database models (Dimensional models).

Good understanding of Star schema Snowflake schema and Data Vault Modelling. Also on any ETL tool Data Governance and

Data quality.

Eye to analyze data & comfortable with following agile methodology.

Adept understanding of any of the cloud services is preferred (Azure AWS & GCP).

Remote Work :

No