Consultant – Data Warehouse (ARMADA Delivery)
beghou consulting
Job Summary
This position involves leading client projects from conception to delivery of Commercial Data Warehouse (CDW) and Master Data Management (MDM). The role involves working with the US business team as the main point of contact, researching technical and business requests to provide efficient solutions, and guiding team members. Responsibilities include overseeing and developing approaches and solution components for Data Warehouse projects, advising on strategy and team resources, synthesizing findings, developing recommendations, and communicating results to clients. The candidate will also provide project leadership, coordinate with diverse teams, and ensure seamless communication with US-based project managers and clients. The role also includes designing, building, and maintaining efficient code, identifying issues and providing solutions, continuous research, and managing projects from requirements gathering to delivery.
Must Have
- 7+ years of experience
- 5+ years of Python programming with Pandas/Pyspark
- CDW experience in the US Pharmaceuticals market is preferred
- Experience implementing or supporting HCP, HCO data management, MDM
- Experience working on various Python libraries
- Advanced analytical and problem-solving skills
- Understanding of business processes and data transformations
- Knowledge in SQL queries, Snowflake, Databricks, Azure and AWS
Job Description
We'll trust you to:
- Oversees and develops approach and solution components for Data Warehouse projects to ensure methodological soundness; consistently delivers quality client services and drives high-quality deliverables
- Advises on strategy, team resources, and deadlines, and assumes data investigation and platform configuration tasks as necessary to support internal team and clients
- Synthesizes findings, develops recommendations, and communicates results to clients and internal teams
- Provides project leadership for team members regarding process improvements, planned approaches for client requests, or transition of new deliverables
- Coordinates with diverse teams, including those globally
- Ensures seamless communication and collaboration with US-based project managers and clients to align project goals and deliverables
- Design, build, and maintain efficient, reusable, and reliable code
- Identify the issues, and provide solutions to mitigate and address these issues
- Continuously expand body of knowledge via research
- Handle the project efficiently from requirements gathering to development and delivery to project maintenance
- Lead code and major feature reviews
- Provide leadership to team, driving a quality mindset, through communication, documentation, and example
- Comply with corporate quality policies and procedures
- Ensure all training requirements are completed in a timely manner
You'll need to have:
- Minimum of 7 years experience in the following:
- At least 5 years of python programming experience including data transformations using Pandas/Pyspark libraries.
- CDW (Commercial Data Warehouse) experience in US Pharmaceuticals market is strongly preferred.
- Experience implementing or supporting HCP and HCO data management, and MDM (Master Data Management) in US pharmaceuticals market is preferred.
- Having experience working on different Python libraries and willing to learn/work on new libraries.
- Having advanced analytical and problem-solving skills.
- Understands the business processes and business data used in data transformations.
- Having knowledge in SQL queries, Snowflake, Databricks, Azure blob storage and AWS.