Data Scientist
View all Jobs from Mphasis
- Location
- Bangalore, State of Karnataka, India
- Salary
- TBD
- Job type
- Full Time
- Category
- Other
Job Description
Job Summary
The role of Data Designer is to understand business requirements, create data definitions, business rules, data quality requirements, and logical and physical models. He/she will adhere to the DM practise within the team. The Data Designer brings technical expertise to ensure the quality and accuracy of data, then process, design and present it in ways to help people, businesses, and organizations make better decisions. The role ensures data integrity and normalization, and oversees and designs the reporting environment, including data sources, security, and metadata.
Main Responsibilities
• Build conceptual, logical and physical data models using Erwin.
• Build source to target mapping documents to describe data transformations.
• Design and develop curated data assets in Data Lake and Data Warehouse to support operational reporting, data science and self-service analytics.
• Define, document and maintain standards and best practices around data modeling.
• Performs profiling and analyze data using SQL / Python on multiple sources: Oracle, Netezza, SQL-Server, Databricks, etc.
• Assess and design data architecture components (data model, mapping, data flows, and transformations) to make sure they are well integrated and aligned with the data and technical architecture.
• Troubleshoots data issues within the business and presents solutions and recommendations.
• Define unit testing to ensure Data Engineers followed specifications.
• Participate in the delivery and support of data quality and data consolidation initiatives.
• Propose simplification initiatives to allow for more effective data design, and management.
• Work with stakeholders including Architecture, Data Engineers, Product Management, DBAs, Infrastructure, Data & Design Teams to assist with data-related technical issues and support their data infrastructure needs.
Requirements
Experience
• Between 5-7 years overall work experience.
• Minimum 4 years of analysis, data design and data modeling experience.
• Strong experience in process analysis and workflow modeling.
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
Education/Certification/Designation
• Bachelor's degree specializing in Mathematics and Statistics / Computer Science / Business Analytics / or other quantitative field, related degree or equivalent experience
General Skills and Competencies
• Expert ability to identify data gaps and assess end-to-end data requirements.
• Excellent Communication skills to build alliances and gain consensus with key stakeholders.
Technical Skills/Knowledge
• Advanced experience with Erwin Data Modeler r9.8 or similar version.
• Advanced experience with dimensional modeling techniques.
• Exposure to Data modeling experience, and data architecture best practices.
• Experience with relational database modeling techniques.
• Advanced SQL skills to support data profiling, unit testing and data extraction.
• Experience in Data Lake, Data Warehouse/Business Intelligence or relevant data environment; in either a development or a support role.
• Experience using Azure Data Lake (ADLS), Azure Data Factory and Databricks.
• Excellent verbal and written communication skills and the ability to interact professionally with a diverse group.
• Experience working with DevOps CI/CD. Azure DevOps or GitHub
Assets
• Experience in real time data streaming and loading.
• Experience modelling data for data science projects.
• Experience working with Scale Agile Methodology (SAFe).
• Experience working with Tableau or Power BI.
• Experience with semi-structured and unstructured data.
• Familiar with Data Lakehouse architecture.
• Written presentation experience; presenting insights in plain language and images.
• The ability to learn quickly, problem solve/troubleshoot, work independently and in a team.
• Experience in leading and participating in business workshops
• Ability to promote business intelligence, analytics, and reporting vision
• Willingness to work on multiple projects at one time
Skills
PRIMARY COMPETENCY : Analytics PRIMARY SKILL : Data Modeler / Architect PRIMARY SKILL PERCENTAGE : 70 SECONDARY COMPETENCY : Analytics SECONDARY SKILL : BI/DW / ETL SECONDARY SKILL PERCENTAGE : 20 TERTIARY COMPETENCY : Data Engineering TERTIARY SKILL : Microsoft SSIS/SSRS/T-SQL TERTIARY SKILL PERCENTAGE : 10
Job Summary
The role of Data Designer is to understand business requirements, create data definitions, business rules, data quality requirements, and logical and physical models. He/she will adhere to the DM practise within the team. The Data Designer brings technical expertise to ensure the quality and accuracy of data, then process, design and present it in ways to help people, businesses, and organizations make better decisions. The role ensures data integrity and normalization, and oversees and designs the reporting environment, including data sources, security, and metadata.
Main Responsibilities
• Build conceptual, logical and physical data models using Erwin.
• Build source to target mapping documents to describe data transformations.
• Design and develop curated data assets in Data Lake and Data Warehouse to support operational reporting, data science and self-service analytics.
• Define, document and maintain standards and best practices around data modeling.
• Performs profiling and analyze data using SQL / Python on multiple sources: Oracle, Netezza, SQL-Server, Databricks, etc.
• Assess and design data architecture components (data model, mapping, data flows, and transformations) to make sure they are well integrated and aligned with the data and technical architecture.
• Troubleshoots data issues within the business and presents solutions and recommendations.
• Define unit testing to ensure Data Engineers followed specifications.
• Participate in the delivery and support of data quality and data consolidation initiatives.
• Propose simplification initiatives to allow for more effective data design, and management.
• Work with stakeholders including Architecture, Data Engineers, Product Management, DBAs, Infrastructure, Data & Design Teams to assist with data-related technical issues and support their data infrastructure needs.
Requirements
Experience
• Between 5-7 years overall work experience.
• Minimum 4 years of analysis, data design and data modeling experience.
• Strong experience in process analysis and workflow modeling.
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
Education/Certification/Designation
• Bachelor's degree specializing in Mathematics and Statistics / Computer Science / Business Analytics / or other quantitative field, related degree or equivalent experience
General Skills and Competencies
• Expert ability to identify data gaps and assess end-to-end data requirements.
• Excellent Communication skills to build alliances and gain consensus with key stakeholders.
Technical Skills/Knowledge
• Advanced experience with Erwin Data Modeler r9.8 or similar version.
• Advanced experience with dimensional modeling techniques.
• Exposure to Data modeling experience, and data architecture best practices.
• Experience with relational database modeling techniques.
• Advanced SQL skills to support data profiling, unit testing and data extraction.
• Experience in Data Lake, Data Warehouse/Business Intelligence or relevant data environment; in either a development or a support role.
• Experience using Azure Data Lake (ADLS), Azure Data Factory and Databricks.
• Excellent verbal and written communication skills and the ability to interact professionally with a diverse group.
• Experience working with DevOps CI/CD. Azure DevOps or GitHub
Assets
• Experience in real time data streaming and loading.
• Experience modelling data for data science projects.
• Experience working with Scale Agile Methodology (SAFe).
• Experience working with Tableau or Power BI.
• Experience with semi-structured and unstructured data.
• Familiar with Data Lakehouse architecture.
• Written presentation experience; presenting insights in plain language and images.
• The ability to learn quickly, problem solve/troubleshoot, work independently and in a team.
• Experience in leading and participating in business workshops
• Ability to promote business intelligence, analytics, and reporting vision
• Willingness to work on multiple projects at one time
Skills
PRIMARY COMPETENCY : Analytics PRIMARY SKILL : Data Modeler / Architect PRIMARY SKILL PERCENTAGE : 70 SECONDARY COMPETENCY : Analytics SECONDARY SKILL : BI/DW / ETL SECONDARY SKILL PERCENTAGE : 20 TERTIARY COMPETENCY : Data Engineering TERTIARY SKILL : Microsoft SSIS/SSRS/T-SQL TERTIARY SKILL PERCENTAGE : 10
