Senior Consultant, Data Engineer – JDE, SAP DS

This is a fully remote position, open to applicants in Maryland, +1 more state.

📋 Description

• Oversee the reverse-engineering of legacy ETL processes and manage the pipeline migration workflow for enterprise clients.

• Assume complete technical responsibility for transitioning intricate legacy ETL pipelines to contemporary dbt and Databricks architectures.

• Convert legacy ETL processes, orchestrators, and SQL Server Agent tasks into scalable dbt models and Databricks pipelines.

• Develop and execute automated data validation frameworks to compare modernized results against legacy data warehouse baselines.

• Establish transitional write-back processes to SQL Server data warehouses to ensure compatibility with downstream reporting.

• Engage directly with technical stakeholders from client organizations.

• Lead smaller engineering teams and provide mentorship to junior consultants.

⛳️ Requirements

• Minimum of 5 years of practical experience in data engineering.

• At least 2 years of experience in a client-facing or consulting capacity.

• Proficient production experience with SQL, Python, Spark, dbt, and workflow orchestration tools like Airflow.

• Extensive technical expertise in Databricks and cloud platforms (Azure or AWS).

• Experience in migrating legacy ERP and ETL systems, such as JD Edwards or SAP.

• Must be located in the DMV area (Washington, DC, Maryland, or Virginia).

• Availability for a contract engagement lasting between 4.5 to 6 months.

• Preferred but not mandatory: Databricks Data Engineer Professional certification or a similar qualification.

• Preferred but not mandatory: Experience with both JD Edwards EnterpriseOne and SAP BusinessObjects Data Services.

🏝️ Benefits

• Opportunity for conversion to a full-time position with the client upon completion of the engagement.

• Competitive hourly rate commensurate with experience and fit.

• Necessary hardware supplied for contractors.

• Competitive salary for W-2 full-time employees only.

• Medical, Dental, and Vision insurance plans for W-2 full-time employees only.

• 401(k) matching, dollar-for-dollar, up to 4% of salary for W-2 full-time employees only.

• Flexible paid time off policy, ensuring at least two weeks off per year for W-2 full-time employees only.

• State-of-the-art hardware optimized for performance or mobility for W-2 full-time employees only.

• Access to a proprietary learning academy with over 100 customized modules for W-2 full-time employees only.

• Certification stipend for delivered platforms for W-2 full-time employees only.

• Fully remote work environment and a culture of empowerment for W-2 full-time employees only.