Data Engineer

ThinkTek • Washington, DC

19d

About The Position

ThinkTek is seeking a Data Engineer with strong expertise in Microsoft Azure and experience integrating with ServiceNow (SNOW) platforms to support a Human Capital Management (HCM) modernization program for a large Federal agency. The selected candidate will provide technical leadership in designing secure, scalable data solutions that enhance interoperability between Azure-based systems, HCM platforms, and ServiceNow applications.

The ideal candidate will have deep hands-on experience in Azure Data Factory, Azure Synapse Analytics, Power BI, and SQL Server, combined with a working knowledge of ServiceNow data structures, CMDB, and API integrations.

Requirements

• Active Secret Clearance.
• Bachelor's Degree or higher.
• 5+ years of experience leading enterprise data architecture, modeling, and migration efforts.
• 5+ years of hands-on experience with Azure SQL, Azure Data Factory, Azure Synapse, and Power BI.
• Experience with ServiceNow data models, integrations, and CMDB architecture.
• Strong SQL and database design proficiency, including stored procedures, APIs, and ETL workflows.
• Experience supporting or integrating Human Capital Management or ERP systems (e.g., Oracle HCM, Workday, PeopleSoft, or SAP SuccessFactors).
• Knowledge of federal data privacy, security, and compliance frameworks (FISMA, FedRAMP, NIST).

Nice To Haves

• Azure Solutions Architect, Azure Data Engineer, or ServiceNow Integration Specialist certification.

Responsibilities

• Lead the design and implementation of enterprise data architecture to support Human Capital Management and related business systems.
• Develop and maintain scalable data models, data warehouses, and migration strategies within the Microsoft Azure environment.
• Architect and manage Azure SQL Database, Azure Data Lake, and Synapse pipelines to enable secure data flow across HCM and ServiceNow platforms.
• Integrate data between Azure and ServiceNow, leveraging APIs, MID Servers, and RESTful web services.
• Collaborate with HR, IT, and ServiceNow platform teams to define and implement data standards, mappings, and transformation logic.
• Establish and monitor data governance, quality assurance, and compliance processes aligned with federal cybersecurity and privacy mandates (e.g., FISMA, FedRAMP).
• Develop advanced analytics and reporting solutions using Power BI and Azure Analysis Services to support workforce planning, performance insights, and executive dashboards.
• Serve as a technical advisor to ensure data architecture aligns with business goals, modernization priorities, and cloud best practices.

Benefits

• We offer comprehensive benefits including medical, dental, and vision insurance for full-time employees, generous PTO, and a variety of paid leave options.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level