Data Engineer & Automation Developer

Travel Required: None | Clearance Required: Active Secret

About the role

Apply strong technical skills and a mission‑focused mindset to understand client needs, identify opportunities, and design data‑driven solutions. Leverage tools such as Python and platforms such as Databricks to create and maintain automated workflows to catalog data using APIs to ingest and transform data from various sources and file types. Create and maintain authentication workbooks for connections from data sources to cataloging tools. Work on the Microsoft Power Platform to create and maintain Power Apps solutions. Communicate clearly to translate technical findings for both technical and non‑technical audiences, including leadership. Engage directly with clients to gather requirements, adapt solutions to mission needs, and drive initiatives forward.

Responsibilities

• Develop and maintain automated workflows in Python and Databricks for data cataloging via APIs.
• Create and manage authentication workbooks for connections to cataloging tools such as Alation.
• Design, build, and sustain Power Apps solutions on the Microsoft Power Platform.
• Translate technical findings into clear communication for technical and non‑technical stakeholders, including leadership.
• Engage with clients to gather requirements, tailor solutions to mission needs, and drive initiatives forward.

Requirements

• Active Secret Federal or DoD security clearance (maintained).
• Bachelor’s degree.
• Minimum two (2) years of professional experience in data analysis, data science, data engineering, or data visualization.
• Experience creating and maintaining automated workflows using Python in Databricks, including API‑based data ingestion and transformation.
• Experience building authentication workbooks for connections to cataloging tools such as Alation.
• Proficiency with Microsoft Power Platform and Power Apps development.
• Ability to support remote, hybrid, or on‑site projects in the Washington, D.C. metro area.

Nice to Have

• Three (3) or more years of relevant professional experience.
• Additional experience working in Databricks.
• Familiarity with Agile team operations (sprint planning, stand‑up calls, Jira story writing, backlog refinement, etc.).
• Proven ability to work independently, identify value‑adding opportunities, and drive innovation.
• Strong presentation skills for technical and non‑technical audiences, including leadership.
• Experience with ETL processes, database management, and data engineering.
• Experience with data cataloging, metadata management, and APIs.
• Familiarity with Alation.
• Ability to support business development activities such as RFP, RFQ, RFI responses, and white papers.
• Relevant experience supporting the Department of State or other Federal Government organizations.

Benefits

• Medical, prescription, dental, and vision insurance.
• Personal and family sick time and company‑paid holidays.
• Discretionary variable incentive bonus eligibility.
• Parental leave and adoption assistance.
• 401(k) retirement plan.
• Basic and supplemental life insurance.
• Health Savings Account, dental/vision, and dependent‑care flexible spending accounts.
• Short‑term and long‑term disability coverage.
• Student loan pay‑down program.
• Tuition reimbursement, personal development, and learning opportunities.
• Skills development and certifications.
• Employee referral program.
• Corporate‑sponsored events and community outreach.
• Emergency back‑up childcare program.
• Mobility stipend.