Job Title: Data Architect/Modeler
Location: Chennai & Hyderabad
Experience: 5 to 6 Years
Must Skills: Data Lakes, Data Migration, Data Modelling, Erwin, CI/CD & Azure/AWS, ADF, ADLS, (largely Azure).
Job Reference ID:BT/F23/SG
Job Responsibilities:
➢ 5 years’ experience in designing and implementing data technology e.g., data bricks, HVR, MuleSoft etc.
➢ Experience with data modelling solutions, including tools, industry data models, data warehouse approaches, data modelling approaches (relational, dimensional, and NOSQL) or equivalent knowledge is required.
➢ Experience with data modelling tools such as ERWIN data modeler or equivalent knowledge is required.
➢ Define and apply standards, tools, best practices, and related development methodologies for data modelling and design.
➢ Creates, reviews, and updates data models.
➢ Perform preliminary analysis and collaborate with the project team and delivery team to develop a business solution.
➢ Gathering and analysing business requirements, as well as being able to translate business requirements into technical requirements.
➢ Carry out data analysis tasks to capture data requirements and represent them in data model visualization.
➢ Identify areas for improvement in the data model to improve business operations.
➢ Data extraction, analysis, interpretation, and pattern recognition from various tables and reports.
➢ Assess data quality and filter/clean data by reviewing the business rules or requirements.
Data Architect & Modelling:
➢ Experience in developing data flow diagram and data architecture for a specific biz e.g., sustainability, Downstream manufacturing, or New Energy.
➢ Experience with operational aspect of data management i.e., delivery & support.
➢ Strong experience in building data model based on industry-based accord standards, preferably Insurance Domain.
➢ Strong experience in mapping attributes, data profiling, data cleansing, and technical data quality etc.
➢ Strong experience in Ansi SQL and in-depth knowledge with structured, semi-structured & unstructured data.
➢ Strong experience on Star Schema, Snowflake, Data Vault & Domain based data models & should have clear understanding on the levels of data normalization, de-normalization etc.
➢ Experience in data Modelling tools such as Erwin, ER/Toad Studio or equivalent.
➢ Data Warehousing and Big Data Tools.
➢ Must have good knowledge of data lake and working experience of migration projects in cloud with providers like AWS or AZURE or GCP.
➢ Good to have experience in working with No SQL, Spark SQL using AWS Glue, and columnar data store.
➢ Good to understand data security features like data masking, data encryption, role based & fine grain access control mechanisms etc.
Salary: Commensurate with experience and demonstrated competence Contact: hr@bigtappanalytics.com
Contact: hr@bigtappanalytics.com