Note: The job is a remote job and is open to candidates in USA. A.C.Coy Company is seeking a Sr. Data Engineer with expertise in Databricks to support their US Government client in data migration efforts. The role involves designing and maintaining data ingestion pipelines, implementing de-duplication strategies, and managing data tagging frameworks within a cloud environment.
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
Skills
- A degree from an accredited College/University in the applicable field of services is required. If the degree is not in the applicable field, then four additional years of related experience is required
- 13+ years of overall IT experience
- 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+ years of 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+ years of 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)
- Must be able to obtain a Position of Public Trust Clearance
- Must be a US Citizen or have US Permanent Residence status (Green Card)
- Must have resided in the US for the last 5 years and not have traveled outside the US for a combined total of 6 months or more in last 5 years
- Experience with one or more of the following products and technologies: SAS, 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 is a plus
- Integration of Git in continuous deployment and experience with DevOps monitoring tools is a plus
- Familiarity with Cloud Operations support in Azure is a plus
- Excellent communication skills
Company Overview