Azure ETL Engineer

Posted Date 3 months ago(9/22/2022 8:43 AM)
Job ID

About DMI

DMI is a global professional services company that specializes in digital strategy, design, transformation, and support. More than your basic systems integrator or big-box advisor, we are a new breed of partner that blends human-centric consulting and design with agile engineering, delivery, and global scale. We believe that digital transformation is an end-to-endless evolutionary process that requires technology solutions and partners that meet organizations where they are. Consultants at the core, DMI has been delivering mission-critical, enterprise grade solutions since 2002 for more than a hundred Fortune 1,000 enterprises, various state and local government agencies and all fifteen U.S. federal departments. DMI has grown to 2,100+ employees globally and has been continually recognized by top industry analysts as well as a Top Workplace in the USA and Remote.| Careers | Twitter | LinkedIn |Facebook 

About the Opportunity

DMI is looking for a Azure ETL Engineer


Duties and Responsibilities:


This is a client delivery role for a very well-funded client. You’ll be part of a team delivering data driven revolution to the workplace experience and empowering each employee with augmented decision making. It is an exciting and multifaceted data driven project that needs a talented and driven data engineer to make it all work.


What you’ll be doing

  • Collecting and formulating business requirements and design solution architecture and Data pipeline.
  • Design Data Pipeline solutions for the enterprise using the Microsoft Azure data platform including ETL and EL processes for complex datasets.
  • Experience in development of data pipelines for both real time and batch data on Azure platform covering structured and unstructured data.
  • Automation of ETL auditing and ETL email notification.
  • Advanced Experience with ADF (Azure Data Factory) is a mandatory skill.
  • Experience with using REST and GRAPH API to retrieve or post data is also a must have skill for this role.
  • Strong experience in programming languages like Java or Python.
  • Guidance to junior Azure ETL developers.
  • Experience in Data Lake and Data warehouse design.
  • Collaboration with business analysts, data analyst and AI/ML team.
  • Feature Engineering, Data Validation, Data Cleansing.
  • Design data migration strategies, including working with software architects to ensure continuity of enterprise services.
  • Experience in SQL Development, specifically with complex queries, tuning indexes
  • Able to work with Scaled Agile Framework (SAFE)
  • Drive Quality Assurance to ensure data quality is adhered as is required per requirement of the project (less than 2% of defects).
  • Production Deployment of data pipeline and orchestration.


Education and Years of Experience:  

  • 5 - 9 years of overall Data Engineering experience with 5+ years of experience working with Azure services.
  • 2+ years demonstrable experience of software development lifecycle, Lean / Agile development methodologies.
  • 2+ years in guidance/supervisions to junior Azure ETL developers
  • 1-2 projects consuming and leveraging REST, Graph, Groq, or SOAP APIs for receiving and providing data to downstream consumers

Required Skills/Certifications: 

  • Azure Data Lake Services
  • Azure Data Factory
  • Synapse / AZ SQL DB
  • SQL
  • Azure Event Hub
  • Azure Stream Analytics
  • Function Apps
  • C#
  • Logic Apps
  • Spark / Data Bricks
  • Consuming and providing data thru REST APIs, GraphQL, and GROQ

Other Skills/Experiences: 

  • Exposure to Snowflake preferred
  • Exposure to Sanity CMS a plus


Physical Requirement(s): No Physical requirement needed for this position.

Location: Remote, US


Working at DMI

DMI is a diverse, prosperous and rewarding place to work. Being part of the DMI family means we care about your wellbeing. As such, we offer a variety of perks and benefits that help meet various interests and needs, while still having the opportunity to work directly with a number of our award winning, Fortune 1000 clients. The following categories make up your DMI wellbeing:

  • Community – Blood drives, volunteering opportunities, Holiday parties, summer picnics, Tech Chef, Octoberfest just to name a few ways DMI comes together as a community.
  • Convenience/Concierge - Virtual visits through health insurance, pet insurance, commuter benefits, discount tickets for movies, travel and many other items to provide convenience.
  • Development – Annual performance management, continuing education and tuition assistance, internal job opportunities along with career enrichment and advancement to help each employee with their professional and personal development.
  • Financial – Generous 401k match for both pre-tax and post-tax (ROTH) contributions along with financial wellness education, EAP, Life Insurance and Disability help provide financial stability for each DMI employee.
  • Recognition – Great achievements do not go unnoticed by DMI through Annual Awards ceremony, service anniversaries, peer-to-peer acknowledgement through Give-A-Wow, employee referral bonuses.
  • Wellness – Healthcare benefits, Wellness programs, Flu Shots, Biometric screenings, on-site lactation rooms provide employees with several wellness options. 

Employees are valued for their talents and contributions. We all take pride in helping our customers achieve their goals, which in turn contributes to the overall success of the company.

The company does and will take affirmative action to employ and advance in employment individuals with disabilities and protected veterans, and to treat qualified individuals without discrimination on the basis of their physical or mental disability or veteran status. DMI is an Equal Opportunity Employer Minority/Female/Veterans/Disability. DMI maintains a drug-free workplace.




***************** No Agencies Please *****************


Applicants selected may be subject to a government security investigation and must meet eligibility requirements for access to classified information. US citizenship may be required for some positions.


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Connect With Us!

Not ready to apply? Connect with us for general consideration.