Data Engineer Azure Databricks

PySpark Power BI Metadata Operations Automation Governance ServiceNow Databricks PostgreSQL Scalability Data Layers Data Quality Data Science Data Lineage Data Modeling Microsoft 365 Cyber Security Data Pipelines Microsoft Azure Data Governance Semantic Search Vector Database Computer Science Azure Databricks Machine Learning Data Warehousing Data Engineering Cosine Similarity Business Valuation Exception Handling Prompt Engineering Workflow Management Metadata Management Service Improvement Reporting Solutions Full Stack Development Cyber Security Systems Large Language Modeling Business Transformation Authorization (Computing) SQL (Programming Language) Git (Version Control System) Extract Transform Load (ETL) Service Improvement Planning Python (Programming Language) Technology Adoption Lifecycle Retrieval Augmented Generation Frontline Decision-Making Autonomy, A leading global aerospace and defense technology organization is seeking a Data Engineer to support its Enterprise Services Infrastructure team.

This role will focus on designing and maintaining enterprise data pipelines in Azure Databricks. The Data Engineer will integrate data from Microsoft 365, ServiceNow, Splunk, identity platforms, endpoint technologies, and cybersecurity systems into analytics-ready Delta Lake tables.

The position will also support data governance, lineage, semantic search, natural-language analytics, and applied AI initiatives. This is an excellent opportunity for a developing Data Engineer who wants hands-on experience with enterprise-scale data, modern Lakehouse architecture, and emerging AI technologies., * Design, build, and maintain enterprise data pipelines using Azure Databricks.

• Integrate ServiceNow, Splunk, Microsoft 365, identity, endpoint, infrastructure, and cybersecurity data.
• Use Python, PySpark, and Spark SQL to transform raw data into analytics-ready Delta Lake tables.
• Develop scalable ETL and ELT workflows using Delta Lake and medallion architecture.
• Build Bronze, Silver, and Gold data layers to support analytics, reporting, and machine learning use cases.
• Create and maintain data models that support Power BI reporting, operational analytics, and business decision-making.
• Build automated data-quality checks, validation processes, monitoring, and error handling.
• Develop data-lineage and governance solutions to identify upstream dependencies, downstream writes, undocumented transformations, stale datasets, ownership gaps, and redundant data products.
• Help create semantic data catalogs that allow users to identify authoritative datasets and understand their business context.
• Support natural-language analytics solutions that help users find relevant data and generate grounded analytical queries.
• Contribute to retrieval-augmented generation solutions that connect current ServiceNow incidents with relevant historical resolutions.
• Use vector embeddings, semantic search, metadata filtering, similarity matching, and clustering to improve enterprise knowledge management.
• Help identify stale, duplicate, underused, missing, or low-quality knowledge articles.
• Collaborate with infrastructure, identity, service desk, governance, cybersecurity, and analytics teams.
• Translate operational challenges into scalable data products, reporting solutions, automation, and applied AI use cases.
• Document pipelines, data models, transformations, dependencies, and engineering processes.

Work Authorization Requirement: Candidates must be legally authorized to work in the United States without current or future sponsorship. Additional eligibility requirements may apply based on the nature of the clients work., * Approximately three or more years of hands-on data engineering experience.

• Strong Python and SQL development skills.
• Hands-on experience building data pipelines in Azure Databricks or a comparable Databricks environment.
• Experience with PySpark, Spark SQL, Databricks notebooks, and Delta Lake.
• Experience developing ETL or ELT pipelines and automated data workflows.
• Understanding of medallion architecture and Bronze, Silver, and Gold data layers.
• Experience with data modeling, data warehousing, schema design, and analytics-ready datasets.
• Experience building data-quality validations, monitoring, and error-handling processes.
• Ability to explain previous Databricks projects and individual technical contributions.
• Must be legally authorized to work in the United States without current or future sponsorship and meet any additional client eligibility requirements.

Preferred Qualifications

• Experience working with Microsoft Azure or Azure Government.
• Experience integrating data from Microsoft 365, ServiceNow, Splunk, identity platforms, endpoint systems, or cybersecurity tools.
• Experience with data governance, data lineage, metadata management, or semantic data catalogs.
• Exposure to retrieval-augmented generation, vector databases, embeddings, or semantic search.
• Experience with ChromaDB or another vector database.
• Understanding of cosine similarity, clustering, metadata-filtered retrieval, or related matching techniques.
• Exposure to large language model orchestration, prompt engineering, or structured LLM outputs.
• Experience with Power BI, PostgreSQL, Git, or Docker.
• Databricks Data Engineer or Machine Learning certification.
• Bachelors or advanced degree in Data Engineering, Data Science, Computer Science, or a related field., Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors.

• Competitive pay range of $45$55 per hour.
• Work with Azure Databricks, PySpark, Spark SQL, Delta Lake, and medallion architecture.
• Gain exposure to enterprise data from Microsoft 365, ServiceNow, Splunk, identity, endpoint, and cybersecurity platforms.
• Contribute to both traditional data engineering and emerging applied AI initiatives.
• Join a small, collaborative team with meaningful technical ownership.
• Build data products that support technology adoption, operational decision-making, service improvement, and software ROI.
• Expand your experience in data governance, semantic search, natural-language analytics, and retrieval-augmented generation.

Job Type & Location

This is a Contract position based out of New York, NY. Pay and Benefits

The pay range for this position is $45.00 - $55.00/hr.

We’re partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That’s the power of true partnership. TEKsystems is an Allegis Group company., Were a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. Were a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. Were strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. Were building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.