Description
data engineer ii (azure) - (location: buenos aires, argentina or mexico city, mexico - hybrid role)
syneos health is a leading fully integrated biopharmaceutical solutions organization built to accelerate customer success. We translate unique clinical, medical affairs and commercial insights into outcomes to address modern market realities.
every day we perform better because of how we work together, as one team, each the best at what we do. We bring a wide range of talented experts together across a wide range of business-critical services that support our business. Every role within corporate is vital to furthering our vision of shortening the distance from lab to life.
discover what our 29,000 employees, across 110 countries already know:
work here matters everywhere
why syneos health
* we are passionate about developing our people, through career development and progression; supportive and engaged line management; technical and therapeutic area training; peer recognition and total rewards program.
* we are committed to our total self culture - where you can authentically be yourself. Our total self culture is what unites us globally, and we are dedicated to taking care of our people.
* we are continuously building the company we all want to work for and our customers want to work with. Why? Because when we bring together diversity of thoughts, backgrounds, cultures, and perspectives - we're able to create a place where everyone feels like they belong.
job summary
the technology & data solutions (tds) business unit is the syneos health accelerator for life sciences innovation. Tds houses our advanced technology acquisitions, homegrown products & applications, actively participates in new m&a and partnership activities, delivers critical insights as part of our integrated strategy for customers and drives enterprise-wide adoption and change management for innovative tech & data solutions. Our work supports getting meaningful new medicines to patients faster, with greater positive impact. The data engineer ii supports our business goals by designing, implementing, and maintaining data pipelines using cloud-native tools in a modern data stack.
job responsibilities
* work independently to solve open-ended questions.
* develop and maintain end-to-end data pipelines using cloud-native solutions to extract, load, and transform data from disparate data sources to a cloud data warehouse.
* capable of formatting and distributing custom data extracts through various means (e.g., custom sftps, apis (e.g., restful), and other bulk data transfer mediums) and optimizing data storage options based on business requirements.
* create models to transform raw data into analytics ready data structures.
* competent in helping to develop/design database structure and function, schema design, and database testing protocols.
* create connectors for data pipelines to ingest data from disparate sources into a data warehouse.
* contribute to the process of defining company data assets (data models) and custom client workflows, as well as standardized data quality protocols.
* capable of independently and collaboratively troubleshooting database issues and queries for improving data retrieval times across various systems (e.g., via sql).
* collaborate with both technical and non-technical stakeholders including it, data science, and various team members across a diverse array of business units.
* work closely with it team whenever necessary to help facilitate, troubleshoot, or develop database connectivity between internal/external resources (e.g., on-premises azure data lakes, data warehouses, and data hubs).
* help implement and enforce enterprise reference architecture and ensure that data infrastructure design reflects enterprise business rules as well as data governance and security guidelines.
qualifications
* bachelor's degree (bs/ba) in information systems, software engineering, computer science, data engineering, or related field required. Master's degree (ms/ma) preferred.
* experience with etl/elt, taking data from various data sources and formats and ingesting into a cloud-native data warehouse required.
* experience with azure stack (data lake/blob storage, powerbi services, azure data factory (or equivalent), databrick) and production level experience with on-premises microsoft sql server required.
* experience with one of the following: python, r, and/or scala as well as standard analytic libraries/packages (e.g., pandas, numpy, dplyr, data table, stringr, slick, and/or kafka) and related distribution frameworks required.
* strong english verbal and written communication skills required.
* familiarity with agile and lean concepts that drive towards mvps and iterative learning to generate the desired business and technology outcomes required.
* experience with datarobot, domino data labs, salesforce mc, veeva crm preferred.
* familiarity with modern data stack components like snowflake, dbt, stitch, tableau, and airflow.
* familiarity with statistical concepts and analytic modeling (e.g., regression analyses, hypothesis testing, and ml based modeling) preferred.
* experience with software engineering best practices like version control with git and ci/cd preferred.
* experience with us healthcare and healthcare data, as well as familiarity with hipaa guidelines, and best practices for handling and storing phi and pii preferred.
* experience with healthcare marketing analytics, healthcare data (claims), and common medical coding sets (icd, hcpcs, npis) preferred.
get to know syneos health
over the past 5 years, we have worked with 94% of all novel fda approved drugs, 95% of ema authorized products and over 200 studies across 73,000 sites and 675,000+ trial patients.
no matter what your role is, you'll take the initiative and challenge the status quo with us in a highly competitive and ever-changing environment. Learn more about syneos health.
additional information:
tasks, duties, and responsibilities as listed in this job description are not exhaustive. The company, at its sole discretion and with no prior notice, may assign other tasks, duties, and job responsibilities. Equivalent experience, skills, and/or education will also be considered so qualifications of incumbents may differ from those listed in the job description. The company, at its sole discretion, will determine what constitutes as equivalent to the qualifications described above. Further, nothing contained herein should be construed to create an employment contract. Occasionally, required skills/experiences for jobs are expressed in brief terms. Any language contained herein is intended to fully comply with all obligations imposed by the legislation of each country in which it operates, including the implementation of the eu equality directive, in relation to the recruitment and employment of its employees. The company is committed to compliance with the americans with disabilities act, including the provision of reasonable accommodations, when appropriate, to assist employees or applicants to perform the essential functions of the job.
#j-18808-ljbffr