Data Engineer/Analyst

Role Overview

The Data Engineer/Analyst will serve on a collaborative team delivering AI, advanced analytics, data engineering, business intelligence, and intelligent automation solutions for the U.S. Department of State. The team will partner with Department bureaus, offices, data owners, mission stakeholders, and technical teams to translate diplomatic, consular, security, and management needs into scalable data products and analytic capabilities.

What You Will Do

Responsibilities include designing, building, testing, documenting, and maintaining secure data pipelines, data models, curated datasets, dashboards, and analytic solutions using approved Department platforms and environments. The Data Engineer/Analyst will also integrate and transform structured and unstructured data from multiple systems while improving data quality, lineage, interoperability, metadata, and availability for authorized users.

Why It Might Be a Fit

The ideal candidate will have experience analyzing large and complex datasets to identify trends, establish key performance or risk indicators, and produce actionable findings for strategic and operational decisions. They will also have the ability to communicate technical findings clearly to nontechnical stakeholders and collaborate with program, policy, operations, security, and technology personnel.

Requirements

• An active and maintained SECRET Federal security clearance
• Bachelor’s degree
• Minimum three (3) years of relevant professional experience, or two (2) years of relevant professional experience with a master’s degree
• Minimum two (2) years of hands-on SQL experience, including complex queries, data transformation, validation, and performance optimization
• Demonstrated expertise developing Power BI semantic models, dashboards, reports, measures, and data visualizations for mission, program, or operational decision-making

Benefits

• Medical, Rx, Dental & Vision Insurance
• Personal and Family Sick Time & Company Paid Holidays
• Position may be eligible for a discretionary variable incentive bonus
• Parental Leave and Adoption Assistance
• 401(k) Retirement Plan
• Basic Life & Supplemental Life
• Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts
• Short-Term & Long-Term Disability
• Student Loan PayDown
• Tuition Reimbursement, Personal Development & Learning Opportunities
• Skills Development & Certifications
• Employee Referral Program
• Corporate Sponsored Events & Community Outreach
• Emergency Back-Up Childcare Program
• Mobility Stipend