PlanIT Group, LLC is seeking a Senior Data Engineer to support their client with data ingestion, deduplication, and tagging for migration into Databricks. The role involves designing and maintaining data pipelines, implementing data integrity strategies, and supporting cloud operations.
Responsibilities:
- Design, develop, and maintain scalable data ingestion pipelines to onboard structured, semi-structured, and unstructured data from batch and streaming sources (e.g., APIs, databases, flat files, message queues) into the Azure/Databricks environment
- Implement de-duplication strategies across large-scale datasets using deterministic and probabilistic matching techniques to ensure data integrity and reduce redundancy within the Data Lake
- Develop and enforce data tagging frameworks to classify, label, and annotate datasets with appropriate metadata (e.g., sensitivity, source, domain, lineage) to support data governance, discoverability, and compliance requirements
- Assist with Operationalizing deployments and support of Cloud services for ETL Operations. This will include standardizing and automating processes and workflows, creating documentation/knowledge articles, and overall assisting Operations staff who have limited experience in Cloud
- Written and oral presentations to high-level CIO management on status of current efforts
- Possesses skills and experience related to business management, systems engineering, operations research, and management engineering. Typically has specialization in a particular technology or business application. Keeps abreast of technological developments and industry trends
- Assist with deployment, configuration, and management of Azure Cloud environment
- Assist with migration efforts of existing ETL jobs into Azure/Databricks cloud environment
- Ability to share optimization and efficiencies with the larger team and management
- Ability to automate solutions to repetitive problems/tasks
Requirements:
- Must be eligible for a Position of Public Trust, including U.S. citizenship or permanent residency, five years of U.S. residency, and no more than six months of international travel in the past five years (excluding travel for U.S.-based work)
- Bachelor's degree and 13 years of experience. A degree from an accredited College/University in the applicable field of services is preferred. Four additional years of relevant experience in lieu of a college degree is required. If Degree is not in the applicable field, then four additional years of related experience is required
- 5+ years demonstrated experience designing and implementing data ingestion pipelines using tools such as Azure Data Factory, Apache Kafka, Apache NiFi, Spark Structured Streaming, or equivalent technologies
- 5+ years of experience applying de-duplication techniques at scale, including record linkage, fuzzy matching, and entity resolution across structured and unstructured datasets
- 5+ Hands-on experience with data tagging and metadata management, including the use of tagging schemas, data catalogs (e.g., Azure Purview, Apache Atlas), and automated classification tools to support data governance and lineage tracking
- 5 + Demonstrated experience working with unstructured data
- 2+ years of experience in using Databricks or other Spark-based platforms
- Fluency in at least one scripting language (Python, Perl, Ruby, or equivalent)
- Integration of Git in continuous deployment and experience with DevOps monitoring tools
- Experience with one or more of the following products and technologies: SAS, Python, C++, Hadoop, SQL Database/Coding, Teradata, Oracle, Amazon S3, Apache Spark, Machine Learning, Natural Language Processing, and visualization tools such as Tableau, Strategy and QLIK
- Strong skills and experience in Cloud Operations support in Azure