Data Engineer

Location : Parsippany basedPosition SummaryThe candidate will play a critical role in the development of a advanced-analytics enabled enhancement of Zoetis’ go-to-market sales strategy. The candidate will be responsible for shaping the core data capabilities that drive critical use cases within the organization, such as revenue generation tactics and strategies to detect and prevent potential customer defection. This candidate will also support data quality and governance initiatives such as master data management, and assist the data engineering team in applying advanced analytics to both internal and external data sources to solve complex business problems. The role will provide the candidate with an exceptionally broad view of every aspect of Zoetis’ business, while serving as critical support for the US Petcare division.To be successful, the ideal candidate will demonstrate an advanced technical expertise, along with a thirst for knowledge and natural curiosity to enable rapid learning of the Zoetis business model and data infrastructure at a scale to support a growing $2b region. The position involves working with structured and unstructured real-world data, requiring a candidate who is comfortable thinking independently about solving business problems. Candidates must be self-motivated, detail-oriented, have the ability to work with limited supervision, and must be comfortable in an environment of changing priorities. Candidates should have a strong business acumen, with evidence of delivered business value, preferably in a commercial settingJob ResponsibilitiesDesign, develop, test and implement database solutions related to optimal data pipeline architecture and infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL Server, Oracle, Sales Force, Python and Big Data technologies.Develop, construct, test and maintain US commercial data layers to enable modelingCollaborate with and enable data scientists on the team to rapidly iterate on model building and deploymentAssists in data quality, integrity, and documentation efforts in support of data governance initiativesAutomate processes that increase productivity for the US commercial data and analytics teamDevelop and implement controls to ensure data integrity and regulatory compliance (SOX).Package and support deployment of releases of new code within our Azure environment.Drive innovation within the group in areas including development efficiencies within Databricks, and leading-edge industry concepts and developments.Monitor the production schedule and provide support to remediate job failures.Provide support to team members when they need a solution to a complex issue.Provide production support to business users.Education and ExperienceMasters from an accredited college/university in Computer Science, Information Technology, Electrical Engineering, or related fieldMinimum of Three years of professional experience working as a Data EngineerDeep experience building deployed data pipelines / ETLExpertise in designing, building and maintaining large-scale databasesDeep acuity in leveraging the latest in big data and cloud infrastructure methodologiesDemonstrated ability to learn and apply new concepts and technologiesExperience working directly with data scientists to build and deploy predictive and optimization models, including assisting in feature engineeringExcellent interpersonal, written, and verbal communication skills; demonstrated ability to effectively communicate complex ideas to both technical and non-technical audiencesFluency in English requiredExpertise in database design, creation, and maintenanceTechnical Skill RequirementsHands-on experience in latest data infrastructure technologies, including cloud-based (e.g. Amazon S3, Redshift, Azure Storage) and distributed file systems (HDFS)Strong proficiency in SQL and at least one programming language (Python, Scala, Java).Experience in working with modern ETL tools and data pipeline platforms (e.g., Databricks, Azure Data Factory, Airflow, DBT, Prefect).Experience in large-scale/distributed computing and analytics (Hadoop, Spark)Familiarity with predictive model building in Python (Pandas/PySpark) / RExperience with source control and collaboration tools (e.g. Git)Software development / engineering experience a plusExperience in scaled model testing, integration, and deployment (DevOps) a plusExperience working in Microsoft tech stack preferredPhysical RequirementsPosition is based in Parsippany, NJOffice based, Hybrid positionTravel approximately 5%The US base salary range for this full-time position is $105,000 - $151,000. Our salary ranges aredetermined by role, level, and location. The range displayed on each job posting reflects the base pay target rangefor new hire salaries for the position. Within the range, individual pay is determined by work location and additionalfactors, including job-related skills, experience, and relevant education or training.In addition to compensation, Zoetis offers a comprehensive benefits package that supports the physical, emotionaland financial wellbeing of our colleagues and their families including healthcare and insurance benefits beginningon day one, a 401K plan with a match and profit-sharing contribution from Zoetis, and 4 weeks of vacation.Visit zoetisbenefits.com to learn more.Full timeRegularColleagueAny unsolicited resumes sent to Zoetis from a third party, such as an Agency recruiter, including unsolicited resumes sent to a Zoetis mailing address, fax machine or email address, directly to Zoetis employees, or to Zoetis resume database will be considered Zoetis property. Zoetis will NOT pay a fee for any placement resulting from the receipt of an unsolicited resume.Zoetis will consider any candidate for whom an Agency has submitted an unsolicited resume to have been referred by the Agency free of any charges or fees. This includes any Agency that is an approved/engaged vendor but does not have the appropriate approvals to be engaged on a search.Notice: Zoetis Recruiters will contact candidates via email from an address ending in @zoetis.com and may also initially connect with candidates through LinkedIn , including LinkedIn InMail. Zoetis does not use Gmail, Outlook, Yahoo, or other web-based/generic email domains to communicate about job opportunities, interviews, or offers of employment. If you receive a recruitment-related email message claiming to be from Zoetis that does not come from @zoetis.com , please treat it as suspicious. For your security, do not reply, click links, open attachments, share personal or financial information, or send money in response to unexpected or questionable recruitment communications.Zoetis is committed to equal opportunity in the terms and conditions of employment for all employees and job applicants without regard to race, color, religion, sex, sexual orientation, age, gender identity or gender expression, national origin, disability or veteran status or any other protected classification. Disabled individuals are given an equal opportunity to use our online application system. We offer reasonable accommodations as an alternative if requested by an individual with a disability. Please contact Zoetis Colleague Services at View email address on click.appcast.io to request an accommodation. Zoetis also complies with all applicable national, state and local laws governing nondiscrimination in employment as well as employment eligibility verification requirements of the Immigration and Nationality Act. All applicants must possess or obtain authorization to work in the US for Zoetis. Zoetis retains sole and exclusive discretion to pursue sponsorship for the acquisition or maintenance of nonimmigrant status and employment eligibility, considering factors such as availability of qualified US workers. Individuals requiring sponsorship must disclose this fact. Please note that Zoetis seeks information related to job applications from candidates for jobs in the U.S. solely via the following: (1) our company website at site, or (2) via email to/from addresses using only the Zoetis domain of “@zoetis.com”. In addition, Zoetis does not use Google Hangout for any recruitment related activities. Any solicitation or request for information related to job applications with Zoetis via any other means and/or utilizing email addresses with any other domain should be disregarded. In addition, Zoetis will never ask candidates to make any type of personal financial investment related to gaining employment with Zoetis. #J-18808-Ljbffr