Data Engineer

PlanIT Group, LLC; Richmond (VA); On-site; USD 100,000 - 140,000; Full time

Job summary

PlanIT Group, LLC is seeking a data engineer to join the EDM Data Engineering team in Richmond, VA. The role focuses on developing, troubleshooting, and implementing a centralized data warehouse by building and testing data pipelines and repositories.

You will leverage Azure Data Lake, Data Factory, and Synapse to design scalable data solutions, perform data cleansing, and support BI foundations. Collaboration with business stakeholders is essential for success.

Qualifications

• 3+ years of data warehouse development experience.
• 2+ years in MS Azure environments and SQL databases.
• Proficient with data cleansing, data exploration, and user story mapping.
• Ability to design and implement EDM data solutions from technical requirements.

Responsibilities

• Develop, troubleshoot, and implement a centralized data warehouse solution.
• Develop and test data pipelines and data repositories.
• Collaborate with the EDM Data Engineering team and stakeholders.

Skills

Effective communication

Team collaboration

Data warehousing concepts

EDM solutions development

Tools

Azure Data Lake

Azure Data Factory

Azure Synapse

Azure Monitor

Azure Log Analytics

ARM/Bicep

Python

PowerShell

SSIS

SSMS

Job description

Description Of Role

Works with the EDM Data Engineering team to develop, troubleshoot, and implement a centralized data warehouse solution by developing and testing data pipelines and data repositories.

Description Of Role

Works with the EDM Data Engineering team to develop, troubleshoot, and implement a centralized data warehouse solution by developing and testing data pipelines and data repositories.

Business Skills

• " Effective oral and written communication skills; able to build good working relationships with technical team as well as business stakeholders.
• " Ability to work independently and as part of a team.
• " Advanced knowledge of Data Warehousing and Business Intelligence concepts, solutions, and best practices.
• " The ability to develop EDM solutions from technical requirements.

Technical Skills Required

• " Intermediate/Advanced Microsoft Office Suite of Tools
• " Must demonstrate hands-on Microsoft Azure experience working with the following Microsoft Azure data technologies: Azure Data Lake, Data Factory, and Synapse.
• " Experience with, and ability to recommend Azure monitoring solution using Azure Monitor, Azure Log Analytics, and custom monitoring scripts.
• " Intermediate working knowledge of Azure Logic Apps, scripting languages like ARM, Bicep DSL, Python, PowerShell or other custom solutions. Experience using one or more of the previous technologies to perform Azure DevOps releases.
• " Advanced experience working with relational and non-relational databases, dimensional models, advanced SQL queries, stored procedures and functions, data warehouses, ETL processes, and database management systems.
• " Advanced experience with SQL Server development technologies like Integration Services (SSIS), Visual Studio, .Net language, Management Studio (SSMS).
• " Good data analysis skills including data cleansing and preparation, data exploration and user story maps.

Experience

• " Minimum 3 years of data warehouse development experience
• " Minimum 2 years working in MS Azure environments and SQL databases