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 world's greatest health threats.
Job Description
As Data modeler lead, you will be responsible for following
- Deliver divisional analytics initiatives with primary focus on datamodeling 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 datamodeling .
- 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 owership 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 field.
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 model 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
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 Rapid Response domain data is a plus
Current Contingent Workers apply
*A job posting is effective until 11:59:59PM on the dayBEFOREthe listed job posting end date. Please ensure you apply to a job posting no later than the dayBEFOREthe job posting end date.