Senior Analytics/AI Engineer

HyerTek

$135K — $155K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 7+ years of hands-on data and analytics engineering experience.
  • Expert proficiency in SQL with strong relational and dimensional data modeling skills.
  • Proven track record in building scoring and calculation logic over data.
  • Production experience with Azure SQL or SQL Server, including performance tuning.
  • Strong programming skills in Python, C#/.NET, or Node.js/TypeScript.
  • Hands-on experience building LLM-backed capabilities with Azure OpenAI.
  • Working knowledge of ETL/ELT, data versioning, and data-access/security design.
  • Experience defining data contracts and APIs for front-end consumption.

Responsibilities

  • Design and manage relational and dimensional data models with ongoing peer reviews.
  • Develop transformation and scoring logic to ensure trusted, verifiable metrics.
  • Implement historical data attribution methods to maintain data integrity over time.
  • Build and maintain robust ETL/ELT pipelines with effective data management practices.
  • Optimize analytical stores for performance, isolating workloads from transactional systems.
  • Develop governed AI capabilities using Azure OpenAI, maintaining scope and security.
  • Establish data-access controls in compliance with federal security requirements.

Benefits

  • Medical, dental, and vision insurance
  • 401(k) with employer contribution
  • Paid time off (PTO) and company holidays
  • Flexible work arrangements
  • Professional development and certification support
  • Employee assistance program (EAP)
  • Life and disability insurance
Full Job Description
Job Type

Full-time

Description

HyerTek is hiring a Senior Analytics/AI Engineer to design, build, and own the data, analytics, and AI layer powering our secure federal solutions. You will model data, build the transformation and scoring logic that turns raw records into trusted metrics and assessments, and deliver the deterministic analytics and scope-limited, grounded AI capabilities that decision-makers rely on - partnering with developers, architects, and security engineers to deliver secure, performant, well-architected analytics for government customers on Azure Government Cloud.

This is a hands-on, builder role with two halves. On the data-and-analytics side, you will own data modeling, pipelines, performance, and data quality, and build the scoring, derivation, and dimensional logic that produces trusted, reconcilable outputs. On the AI side, you will build a governed natural-language analytics capability on Azure OpenAI - grounded, cited, and strictly scope-limited to what each user is authorized to see - plus predictive and anomaly indicators, with the guardrails that keep them trustworthy in a regulated environment. You will work embedded with delivery teams rather than in a separate data organization, within a continuous-authorization (cATO) pipeline where the correctness of what you build is continuously verified and feeds into the accreditation record. Your work will go to federal customers, and the correctness and durability of the data and models you deliver will directly shape their trust in HyerTek.

Location: Candidate must be located in the Washington, DC, metro region and available to go onsite in Maryland. This role supports secure Government environments; a Secret clearance is required, with the ability to obtain Top Secret/SCI. All personnel shall meet DoD 8140/8570 baseline requirements for their role.

Responsibilities:
  • Design and own relational and dimensional (star-schema) data models across development, test, and production tiers, treating the data model as a long-lived, versioned, peer-reviewed deliverable.
  • Build the transformation, scoring, and derivation logic that turns raw source data into trusted, reconcilable metrics, assessments, and analytics outputs - where every figure can be re-derived and verified, never hand-entered.
  • Implement point-in-time and slowly-changing-dimension attribution so historical data rolls up correctly for the period it describes rather than being overwritten by current state.
  • Build and maintain ETL/ELT pipelines and the reference and configuration data behind them, with versioning and effective dating so results stay reproducible over time.
  • Design and tune the analytical store and aggregation strategy for performance, keeping analytics workloads off the transactional systems.
  • Build a scope-based AI query capabilities on Azure OpenAI
  • Implement AI guardrails and deliver predictive and anomaly-detection indicators as governed, explainable analytics - with evaluation and human-review discipline appropriate to a regulated system.
  • Implement data-access controls - row-level and role-based security - aligned to federal security requirements, so analytics and AI honor the same scope model the applications enforce.
  • Define and maintain the data contracts and APIs that downstream visualization layers consume - native front ends, BI tools, or a governed AI layer
  • Partner with security engineers to apply data-protection, de-identification, and governed-release controls; remediate findings and support continuous-monitoring and audit activities.
  • Document data models, lineage, model behavior, and as-built records suitable for continuous authorization and customer handoff.


Requirements

  • 7+ years of hands-on data and analytics engineering across data modeling, pipelines, and analytics delivery.
  • Expert SQL, with strong relational and dimensional data modeling.
  • Demonstrated experience building scoring, rules, or calculation logic over data - not just moving data from one place to another.
  • Production experience with a major relational database (Azure SQL or SQL Server), including performance tuning.
  • Proficiency in a backend language for the logic and service layer - strong Python, C#/.NET, or Node.js/TypeScript.
  • Hands-on experience building LLM-backed capabilities - retrieval-augmented generation (RAG), grounding, prompt design, and model evaluation - ideally with Azure OpenAI.
  • Working knowledge of ETL/ELT, data versioning and effective dating, slowly-changing dimensions, and data-access/security design (row-level and role-based).
  • Experience defining data contracts and APIs consumed by separate front-end, reporting, or BI teams.
  • Excellent troubleshooting, documentation, and stakeholder communication skills.
  • Comfort working independently across multiple concurrent engagements.

Preferred Qualifications:
  • Experience with Azure Government Cloud (IL5/IL6/IL7) and the architectural constraints they impose.
  • Understanding continuous ATO (cATO) / continuous monitoring delivery.
  • Experience securing AI/LLM systems - scope-bound RAG, PII redaction, prompt-injection defense, and data-residency controls in a governed environment.
  • MLOps exposure - feature stores, model evaluation, and de-identified/governed data release.
  • Familiarity with the Microsoft data and analytics ecosystem (Azure data services, Microsoft Fabric) and BI tools (Power BI, Tableau, or comparable), with the judgment to integrate whichever a customer environment requires.

HyerTek offers a comprehensive benefits package, including:
  • Medical, dental, and vision insurance
  • 401(k) with employer contribution
  • Paid time off (PTO) and company holidays
  • Flexible work arrangements
  • Professional development and certification support
  • Employee assistance program (EAP)
  • Life and disability insurance

Clearance & Work Authorization

This position requires U.S. citizenship and a current Secret clearance with the Department of Defense. Candidates must be authorized to work in the United States without the need for employment-based visa sponsorship now or in the future. HyerTek will not sponsor applicants for a U.S. work visa status for this opportunity.

Salary Range

$135,000 - $155,000 annually, depending on experience and clearance status.

Salary Description

$135,000 - $155,000 per year

Similar Jobs

More Jobs at HyerTek

  • Sr. Cloud Engineer
    $140K — $160K *
    Columbia, MD 21044 (Howard County)
    Technical Services
    In-Person
  • Full Stack / Lead Developer
    $160K — $180K *
    Columbia, MD 21044 (Howard County)
    Education, Government & Non-Profit
    In-Person
  • Senior Analytics/AI Engineer
    $135K — $155K *
    Columbia, MD 21044 (Howard County)
    Information Technology
    In-Person
  • Security Engineer
    $140K — $155K *
    Columbia, MD 21044 (Howard County)
    Information Technology
    In-Person
  • Sr. Analytics Engineer
    $135K — $155K *
    Rockville, MD 20850 (Montgomery County)
    Education, Government & Non-Profit
    In-Person

More Information Technology Jobs

Find similar Senior Analytics/AI Engineer jobs: