Senior Data Architect

Ad Hoc LLC

Senior Data Architect at Ad Hoc collaborating on federal digital services. Leading data architecture strategy and guiding teams in complex data migrations and cloud solutions.

Posted 6/10/2026full-timeRemote • 🇺🇸 United StatesSenior💰 $150,000 - $160,000 per yearWebsite

Tech Stack

Tools & technologies

AWSAzureCloudOracle

About the role

Key responsibilities & impact

Senior Data Architect serves as an experienced individual contributor within a team, with the expectation that you will further develop your leadership, guidance, and mentoring skills.
With minimal oversight from leadership, you will be responsible for supporting the goal of meeting scope, schedule, and delivery requirements.
A Senior Data Architect impacts the long-term goals of the program, while contributing to the development of the program's data architecture strategy.
You may serve as the discipline's primary lead when working with stakeholders and utilize strong influential skills to drive improvements in data architecture processes and practices.
Lead complex legacy data migrations end-to-end, including schema mapping, data profiling, phased migration sequencing, parallel-run validation, and cutover with automated rollback procedures.
Design and maintain cloud-native data pipelines using event-driven infrastructure (SNS/SQS, Lambda/Step Functions) to support BI and analytics workflows.
Architect data analytics repositories that are production-ready, monitored, and fully documented so agency staff and external tools can operate without contractor dependency.
Manage digital artifact and content management lifecycles including upload, storage, review, and archiving across AWS and Azure/M365 environments.
Drive data governance across programs, including lineage documentation, dictionary standardization, and glossary development.
Align data architecture and standardize access patterns to make data available to BI tools, apps, and web platforms.
Translate business and agency requirements into functional BI portals and dashboards.
Present architectural decisions clearly to mixed audiences, from engineers to product owners to federal agency stakeholders.
Mentor junior analysts and engineers and participate in technical interviews and candidate evaluations.
May lead small, less critical, or temporary structures and projects.

Requirements

What you’ll need

7+ years of relevant data architecture experience and a Bachelor's degree, or equivalent additional experience in lieu of a degree
Must meet federal suitability requirements and pass a background investigation as a condition of employment
Proven experience leading large-scale legacy data migrations, including schema mapping, phased migration strategy, and cutover with rollback validation
Deep expertise with relational (Oracle, RDS) and non-relational databases, and a solid understanding of how structural variability in legacy systems creates downstream migration risk
Hands-on experience building event-driven pipeline infrastructure (SNS/SQS, Lambda/Step Functions)
Working knowledge of AWS (S3, CloudWatch, OpenSearch) and Azure/M365 environments
Strong grasp of data governance principles, lineage documentation, and data dictionary/glossary standardization

Benefits

Comp & perks

Company-subsidized health, dental, and vision insurance
Flexible PTO
401K with employer match
Paid parental leave after one year of service
Employee Assistance Program

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data architecturedata migrationschema mappingdata profilingcloud-native data pipelinesevent-driven infrastructuredata analytics repositoriesdata governanceBI portalsdashboards

Soft Skills

leadershipmentoringinfluential skillscommunicationstakeholder engagementguidanceorganizational skillspresentation skills