Specialist Digital Supply Chain Datamodeler / Data Engineer
- Merck Sharp
- 5 - 10 years
- Hyderabad
- 6 days ago
- Email to a friend
- Report this job
Job Description
As a Digital Supply Chain Data Modeler/Engineer, you will work as a member of the Digital Manufacturing Division team supporting Enterprise Orchestration Platform. You will be responsible for identifying, assessing, and solving complex business problems related to manufacturing and supply chain. You will receive training to achieve this, and you'll be amazed at the diversity of opportunities to develop your potential and grow professionally. You will collaborate with business stakeholders and determine analytical capabilities that will enable the creation of Insights-focused solutions that align to business needs and ensure that delivery of these solutions meet quality requirements.
The Opportunity
- Based in Hyderabad, joining a global healthcare biopharma company and be part of a 130- year legacy of success backed by ethical integrity, forward momentum, and an inspiring mission to achieve new milestones in global healthcare.
- Be part of an organization driven by digital technology and data-backed approaches that support a diversified portfolio of prescription medicines, vaccines, and animal health products.
- Drive innovation and execution excellence. Be a part of a team with passion for using data, analytics, and insights to drive decision-making, and which creates custom software, allowing us to tackle some of the worlds greatest health threats.
Our Technology Centers focus on creating a space where teams can come together to deliver business solutions that save and improve lives. An integral part of our company s IT operating model, Tech Centers are globally distributed locations where each IT division has employees to enable our digital transformation journey and drive business outcomes. These locations, in addition to the other sites, are essential to supporting our business and strategy.
A focused group of leaders in each Tech Centre helps to ensure we can manage and improve each location, from investing in growth, success, and we'll-being of our people, to making sure colleagues from each IT division feel a sense of belonging to managing critical emergencies. And together, we must leverage the strength of our team to collaborate globally to optimize connections and share best practices across the Tech Centers.
As Data modeler lead, you will be responsible for following but not limited to,
- Deliver divisional analytics initiatives with primary focus on data modeling for all analytics, advanced analytics and AI/ML uses cases e,g Self Services, Business Intelligence & Analytics, Data exploration, Data Wrangling etc
- Host and lead requirement/process workshop to understand the requirements of data modeling.
- Analysis of business requirements and work with architecture team to deliver & contribute to feasibility analysis, implementation plans and high-level estimates.
- Based on business process and analysis of data sources, deliver detailed ETL design with mapping of data model covering all areas of Data warehousing for all analytics use cases.
- Creation of data model & transformation mapping in modeling tool and deploy in databases including creation of schedule orchestration jobs.
- Deployment of Data modeling configuration to Target systems (SIT, UAT & Prod) .
- Understanding of Product ownership and management.
- Lead Data model as a product for focus areas of Digital supply chain domain.
- Creation of required SDLC documentation as per project requirements.
- Optimization/industrialization of existing database and data transformation solution
- Prepare and update Data modeling and Data warehousing best practices along with foundational platforms.
- Work very closely with foundational product teams, Business, vendors, and technology support teams to build team to deliver business initiatives
Position Qualifications :
Education Minimum Requirement: - B.S. or M.S. in IT, Engineering, Computer Science, or related fields.
Required Experience and Skills**:
- 5+ years of relevant work experience, with demonstrated expertise in Data modeling in DWH, Data Mesh or any analytics related implementation; experience in implementing end to end DWH solutions involving creating design of DWH and deploying the solution
- 3+ years of experience in creating logical & Physical data models in any modeling tool (SAP Power designer, WhereScape etc ).
- Experience in creating data modeling standards, best practices and Implementation process.
- High Proficiency in Information Management, Data Analysis and Reporting Requirement Elicitation
- Experience working with extracting business rules to develop transformations, data lineage, and dimension data modeling
- Experience working with validating legacy and developed data model outputs
- Development experience using WhereScape and various similar ETL/Data Modeling tools
- Exposure to Qlik or similar BI dashboarding applications
- Has advanced knowledge of SQL and data transformation practices
- Has deep understanding of data modelling and preparation of optimal data structures
- Is able to communicate with business, data transformation team and reporting team
- Has knowledge of ETL methods, and a willingness to learn ETL technologies
- Can fluently communicate in English
- Experience in Redshift or similar databases using DDL, DML, Query optimization, Schema management, Security, etc
- Experience with Airflow or similar various orchestration tools
- Exposure to CI/CD tools
- Exposure to AWS modules such as S3, AWS Console, Glue, Spectrum, etc management
- Independently support business discussions, analyze, and develop/deliver code
- Work during and with the US and European team with the overlap work hours.
Preferred Experience and Skills:
- Experience working on projects where Agile methodology is leveraged
- Understanding of data management best practices and data analytics
- Ability to lead requirements sessions with clients and project teams
- Strong leadership, verbal and written communication skills with ability to articulate results and issues to internal and client teams
- Demonstrated experience in the Life Science space
- Exposure to SAP and RapidResponse domain data is a plus
Job Classification
Industry: Pharmaceutical & Life SciencesFunctional Area / Department: Data Science & AnalyticsRole Category: Business Intelligence & AnalyticsRole: Data AnalystEmployement Type: Full timeContact Details:
Company: Merck SharpLocation(s): Hyderabad+ View Contact
Keyskills: CVS Data analysis SAP Database administration Data structures Healthcare Business intelligence Information technology SDLC SQL
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Merck Sharp
MSD operates its human health business in India through three separate legal entities: MSD Pharmaceuticals Private Limited, Organon (India) Private Limited, and Fulford (India) Limited. Since its existence in India, the company has moved quickly in laying the foundation for a business that is differ...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in