*job details*
*what you will do?
*
join us in the procurement execution center (pec) as a data engineer as part of a is a diverse team of data and procurement individuals.
in this role, you will be responsible for deploying supporting the e2e management of our data, including: etl/elt, dw/dl, data staging, data governance, and manage the different layers of data required to ensure a successful bi & reporting for the pec.
this role will work with multiple types of data, spreading across multiple functional areas of expertise, including fleet, mro & energy, travel, professional services, among others.
*how you will do it?
*
- deploy data ingestion processes through azure data factory to load data models as required into azure synapse.
- build and design etl/elt processes with azure data factory (adf) and/or python, which once deployed, will require to be executed daily and weekly.
- assemble large, complex data sets that meet functional / non-functional business requirements.
- build the infrastructure required for optimal etl/elt of data from a wide variety of data sources using azure sql and adf.
- develop data models that enable dataviz, reporting and advanced data analytics, striving for optimal performance across all data models.
- maintain conceptual, logical, and physical data models along with corresponding metadata.
- manages the devops pipeline deployment model, including automated testing procedures
- deploys data stewardship and data governance across our data warehouse, to cleanse and enhance our data, using knowledge bases and business rules.
- performs the necessary data ingestion, cleansing, transformation, and coding of business rules to support annual procurement bidding activities.
- support the deployment of a global data standard for logistics.
- create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.
- support rate repository management as required (including rate card uploads to our dw).
- other procurement duties as assigned.
*what are we looking for?
*
- bachelor's degree in related field (engineering, computer science, data science or similar)
- 3+ years of relevant experience in bi engineering, data modeling, data engineering, software engineering or other relevant roles.
- advanced working sql knowledge and experience working with relational databases.
- knowledge in dw/dl concepts, data marts, data modeling, etl/elt, data quality/stewardship, distributed systems and metadata management.
- experience building and optimizing data pipelines, architectures, and data sets.
- azure data engineering certification preferred (dp-203)
- etl/elt development experience (3+ years).
ssis or adf are preferred.
- ability to resolve etl/elt problems by proposing and implementing tactical/strategic solutions.
- strong project management and organizational skills.
- experience with object-oriented function scripting languages: python, scala, c#, etc.
- experience with nosql databases is a plus to support the transition from on-prem to cloud.
- excellent problem solving, critical thinking, and communication skills
- relevant experience with azure devops (ci/cd, git/repo management)
- due to the global nature of the role, proficiency in english language is a must