As a Senior Data Engineer, you will work to solve some of the organizational data management problems, enabling the organization to become a data-driven entity. You will 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.
Key Responsibilities
- Engage clients to understand business requirements and 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, which 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 yourself in maintaining data models as well as capturing data models from existing databases and recording descriptive information.
- Use Data Modelling tools 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
- Experience: 6+ years of experience in the data space.
- SQL Skills: Decent SQL skills.
- RDBMS Experience: Significant experience in one or more RDBMS (Oracle, DB2, and SQL Server).
- Database Models: Real-time experience working in OLAP and OLTP database models (Dimensional models).
- Data Modeling Concepts: Good understanding of Star schema, Snowflake schema, and Data Vault Modelling.
- Data Tools & Concepts: Knowledge of any ETL tool, Data Governance, and Data quality.
- Methodology: An eye to analyze data and comfortable with following agile methodology.
- Cloud Services: Adept understanding of any of the cloud services is preferred (Azure, AWS, GCP).
