Job Description

Business Units Information and Digital Solutions (IDS) is a global organization strategically positioned so that through information and technology leadership and solutions, we create meaningful connections and remarkable experiences, so people feel genuinely cared for. The Business Unit IDS organization is accountable for designing, developing, and supporting commercial or customer engagement services and capabilities that span multiple Buiness Units (Bio-Medicines, Diabetes, Oncology, International), functions, geographies, and digital channels. The areas supported by Business Unit IDS includes: Customer Operations, Marketing and Commercial Operations, Medical Affairs, Market Research, Pricing, Reimbursement and Access, Customer Support Programs, Digital Production and Distribution, Global Patient Outcomes, and Real-World Evidence. This position isu00A0responsibleu00A0for providing supportu00A0foru00A0ETL / ELT / File Movementu00A0of data.u00A0u00A0 Theu00A0key responsibilities will be to processu00A0and move data between different compute and storage services, as well as on-premises data sources at specified intervals.u00A0The employee will also be responsible foru00A0the creation, scheduling, orchestration and management of data pipelines.u00A0 Competency Data Engineer Data engineers are responsible for ensuring the availability and quality of data needed for analysis and business transactions. This includes data integration, acquisition, cleansing, harmonization and transforming raw data into curated datasets for data science, data discovery, and BI/analytics. Responsible for developing, constructing, testing and maintaining data sets and scalable data processing systems. Data engineers work closest with Data Architects and Data Scientists.u00A0 They also work with business and IT groups beyond the data sphere, understanding the enterprise infrastructure and the many source systems. Input is raw datasets.u00A0 Output is analytics-ready, integrated/curated datasets.u00A0 Key capabilities in this role family include: Data Acquisition -u00A0 is the process of gathering and storing data in a location and format that it can be consumed for data preparation and/or downstream business uses. Data Preparation - u00A0is an iterative process for exploring, integrating, cleaning, validating and transforming raw data into curated datasets Data Publishing -u00A0 is the act of releasing data in consumable form for (re)use by others. Note: All data engineer roles should have a foundational set of knowledge in:u00A0 communication, leadership, teamwork, problem solving skills, solution / blueprint definition, business acumen, architectural processes (e.g. blueprinting, reference architecture, governance, etc.), technical standards, project delivery, and industry knowledge. Businessu00A0Analysisu00A0and Technical Leadership u00A0 Engages with business and proactively seeks opportunities to deliver business value.u00A0u00A0 Understands business requirements and effectively translates business needs and process into technical terms, and vice versau00A0 Elicits and definesu00A0requirementsu00A0 Ensures appropriate business roles are engaged in solution execution.u00A0 Participates in design reviews to ensure traceability of requirements.u00A0 Networks with appropriate IT colleagues to determine solutions to meet business partnersu2019 needs.u00A0 Seeksu00A0opportunities to reuse existing processes and services to streamline support and implementation of key systems.u00A0u00A0 Stay abreast of tools and technologies to influence IT strategy so that it provides best usage opportunities for business Ability to adapt quickly in a constantly changing environment Desired Technologies Bacheloru2019s degree in computer science, information technology, management information systems or equivalent work experienceu00A0 2-5 years of experience in the core tools used by the solution services team (e.g. SQL, Tableau, Informatica (PowerCenter), AWS, Python etc.) Ability to work with business owners to define key business requirements and convert to technical specifications Experience with security models and development on large data sets Expertise in the design, data modeling creation, and management of large datasets/data models Ensure successful transition of applications to service management team through planning and knowledge transfer Develop expertise of processes and data used by business functions within the US Affiliate Responsible for system testing, ensuring effective resolution of defects, timely discussion around business issues and appropriate management of resources relevant to data and integration Expertise in system performance and user experience of solutions Expertise with analytics and business intelligence solutions (e.g. 1 or more of Tableau, PowerBI, QuickSight, Datorama, etc.) Partner with and influence vendor resources on solution development to ensure understanding of data and technical direction for solutions as well as delivery Experience with AWSu00A0 ETL/File Movement tools.u00A0 Experience with Agile Development.u00A0 Familiarity with AWS database technologies.u00A0 Experienceu00A0with Lambda, Pythonu00A0and Sparku00A0 Familiarity withu00A0S3, Kinesis, Glue and Athena.u00A0 Experience with Apache Airflow and Ansibleu00A0 Experience with GitHub and Jenkins toolsets Preferred Qualifications / Certificationsu00A0 Experience working in regulated environments and with internal systems quality policies and proceduresu00A0 Experience in working in Scrum - agile methodologies, coding standards, code reviews, source management (GITHUB), build processes Knowledge of the data architectures associated with information integration, data visualization, & data warehousingu00A0 Experience in development and deployment on cloud infrastructure Pharmaceutical or healthcare industry experience Early drug discovery industry experience Experience with Sales & Marketing Business processes & systems Defining best practices and developing technical standards, design principals, best practices, and frameworks Business Intelligence Certifications Technical curiosity and desire to innovate

Monster