Note: The job is a remote job and is open to candidates in USA. Deloitte is seeking a Database Engineer Contractor to build and optimize database and data integration solutions. The role focuses on migrating legacy SAP data into Azure, structuring datasets in Azure Synapse, and improving database performance, data quality, validation, and security.
Responsibilities
- Build relational database structures and data ingestion workflows that support project requirements for storage, retrieval, reporting, and analysis
- Ingest data from the client’s legacy SAP platform into the Azure data lake using Azure Synapse and connected pipeline tools
- Structure, transform, and model in-scope legacy analytics datasets in the target environment while preserving metadata, lineage, documented business rules, and data integrity
- Optimize database and Azure Synapse performance to support query, scalability, retention, and validation requirements for defined use cases
- Apply database security controls and perform data validation, reconciliation, and quality checks to confirm migrated data is complete, accurate, and consistent with source data
Skills
- • 2+ years of experience in data engineering, database engineering, or database development
- • Experience building and supporting data pipelines in Azure Data Factory (ADF)
- • Experience creating transformations and ingestion workflows in Azure Synapse Analytics, including Synapse Studio and dedicated SQL pools or serverless SQL pools
- • Experience writing Structured Query Language (SQL) for data ingestion, transformation, validation, and troubleshooting
- • Experience building relational data models, including star schemas and slowly changing dimension (SCD) patterns
- • Experience with extract, transform, load (ETL) tools such as Azure Data Factory (ADF), SAP Data Services, Theobald Xtract, or SAP Smart Data Integration (SDI)
- • Experience working with SAP-sourced data, including fields, keys, or SAP Business Warehouse (SAP BW) objects such as InfoCubes, DataStore Objects (DSOs), CompositeProviders, Open Hub, Operational Data Provisioning (ODP), or BW Queries
- Candidates interested in applying for this opportunity must be geographically based in the United States and must be legally authorized to work in the United States without the need for employer sponsorship
- • Experience ingesting SAP data into Azure data lake environments
- • Experience validating migrated datasets through reconciliation and acceptance testing
- • Experience supporting supply chain or operations data domains
- • Experience applying security controls for sensitive datasets in Azure environments
- • Experience using Python for data processing or automation
- • Experience preparing data for machine learning workflows
Benefits
- Remote work arrangement
Company Overview