Data Engineer

POSITION DESCRIPTION

POSITION TITLE: Database Engineer

In completion of the position description, provide definitions for all acronyms.

POSITION SUMMARY
Summarize the primary purpose & key accountabilities of the position, including scope of responsibility in 5-7 concise sentences. (i.e. Global vs. Country/Region) It may be helpful to complete this section after you have finished the other sections of the document.

We are seeking a passionate and experienced Data Engineer to join the DX data team.
In this role you'll design and implement high quality data solutions that serve our customers across our DX ecosystem.
Your responsibilities include creating and maintaining data pipelines using Azure Data Factory, Azure Synapse.
You'll work with various Azure data storage options, such as Azure SQL Database, Data Lake Storage, Data Warehouse, and Cosmos DB.
Proficiency in big data technologies like Azure Databricks and Apache Spark is essential.
Additionally, experience with Azure Functions—building serverless event-driven code—is highly valued.
Collaborate with cross-functional teams to ensure scalable, performant, and cost-effective data solutions.
Join us in shaping the future of data-driven applications and engineering within the DX Data team.

POSITION RESPONSIBILITIES
In order of importance, list the primary responsibilities critical to the performance of the position.  It is recommended not to list actual tasks but focus on essential responsibilities that highlight accountability and level of judgment required. Percent of Time (sum of responsibilities should equal to 100%)
Data Solution Design:
o Collaborate with cross-functional teams to deliver on data strategy, architecture, and governance.
o Design and deploy data solutions in the cloud, ensuring scalability, performance, and cost-effectiveness.
Data Pipelines and Integration:
o Create and maintain data pipelines using Azure Data Factory/Azure Synapse.
o Extract, transform, and load (ETL) data from various sources into data warehouses or data lakes.
o Ensure efficient data cleaning, conversion, and loading processes.
Data Storage and Management:
o Work with various Azure data storage options, including:
§ Azure SQL Database
§ Azure Data Lake Storage
§ Azure Cosmos DB
§ Azure Blob Storage
o Design storage systems that meet organizational requirements. 65%
Big Data and Analytics:
o Utilize big data technologies such as Azure Databricks and Apache Spark.
o Develop data processing workflows and pipelines to handle and analyze large volumes of data.
o Support data analytics, machine learning, and other data-driven applications. 25%

• Azure Functions Development:
o Proficiency in creating, deploying, and managing serverless functions using Azure Functions.
o Knowledge of triggers (e.g., HTTP, timer, queue, blob) and bindings (e.g., Cosmos DB, Azure Storage, Service Bus).

• Event-Driven Architecture:
o Understanding of event-driven design patterns and how to build scalable, event-triggered workflows.
o Ability to integrate Azure Functions with other Azure services (e.g., Logic Apps, Event Grid).

• Serverless Best Practices:
o Familiarity with best practices for optimizing performance, monitoring, and error handling in serverless applications. 10%

ORGANIZATIONAL RELATIONSHIPS
Provide the primary groups or key positions that this position will have interaction with as a regular part of the position responsibilities.  Include any external interactions as appropriate.

Collaboration with product managers, product owners, scrum masters, development and testing teams.

RESOURCES MANAGED  
Financial Accountability
Indicate the Average Budget or Revenue accountability, as applicable.

Supervision
Indicate the typical number of Colleagues managed.  Include direct & indirect reports, matrix responsibility and or additional resources (i.e. contingent workers), as applicable.

EDUCATION AND EXPERIENCE
Indicate the formal education, certification or license required and/or preferred. Include the minimum number of years of relevant experience required for the position (where legally permissible).

• A bachelor's degree in computer science, information technology, or a related field is required.

TECHNICAL SKILLS REQUIREMENTS
Indicate the technical skills required and/or preferred, as applicable.
Required:

• Minimum 5+ years of experience in data engineering role.

• Strong hands-on experience with Azure Data Factory, Azure SQL, CosmosDB, Azure Synapse

• Experience with Data Lake, data warehouse, Big Data, Spark, Azure Databricks

• Strong experience with verification, comparing and troubleshooting of data across environments.

• Experience with applying version control systems for create and migration scripts.

• Strong experience with best practices in database performance optimization

• Strong experience in creating complex functions and stored procedures.

• In depth knowledge of SQL and relational database management systems (RDBMS)

• Strong understanding of data modelling and database design

• Experience is building and evolving data models (Conceptual, Logical, Physical).

• In depth knowledge of database best practices and standards

• Good familiarity with data warehousing and business intelligence tools

• Experience in a range of database systems, from traditional RDBMS/SQL to NoSQL and other scalable databases technologies

• Strong analytical and problem-solving skills.

• Excellent attention to detail and a keen eye for usability issues.

• Excellent English verbal and written communication skills

• Experience with manual and exploratory testing techniques.

• Experience with bug tracking & collaboration tools (e.g., Jira, Zephyr Scale, Confluence) a plus.

Desired:

• Passion for solving complex problems and making a difference.

• Experience with product development and collaborating in agile teams.

• Strong aptitude for learning new technologies.

• The ability to collaborate with a diverse group of people.

• Highly motivated and self-starting individual

• Takes ownership and accepts accountability for successful outcomes.

PHYSICAL POSITION REQUIREMENTS 
Note the physical conditions in which work will be performed, if applicable to the position.  Examples: Lifting, sitting, standing, walking, ability to travel, drive, unusual attendance requirements, weekend work or travel requirements, etc.

At least four hours overlap with GMT / IST (Irish Standard Time).
Some weekend work may be required to assist in data changes to systems during releases (estimated once every 2-3 months).

This description indicates the general nature and level of work expected.  It is not designed to cover or contain a comprehensive listing of activities or responsibilities required of the incumbent.  Incumbent may be asked to perform other duties as required.  Additional position specific requirements/responsibilities are contained in approved training curricula.  

Any 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.