Senior Data Architect

This is a remote position.

Ad Hoc is a technology company that empowers organizations to deliver scalable, impactful digital services. Using modern, agile methods, our team creates products that meet people’s needs and transform their experience of government.

Work on things that matter

Our collaborations have shaped some of the defining moments in public-sector service delivery. We’ve helped build products that connect Veterans to tailored services, help millions access affordable health care, and support important programs like Head Start. As we work with agencies to deliver critical services, we’re also changing how the government approaches technology.

Built for a remote life

Our culture, communications, and tools are built for remote work, enabling us to bring together top talent nationwide. At Ad Hoc, remote life empowers our teams to design work environments that fit their lives and that foster flexibility and collaboration to achieve positive outcomes for our customers.

Committed to high expectations and a welcoming culture

Ad Hoc values acceptance, accountability, and humility. We aren’t heroes. We learn from our mistakes and improve the process for the next time. We build small, inclusive teams to collaborate closely with our partners to solve the right problems and deliver software that works.

The Federal Civilian business unit supports many customers spanning the federal, commercial, and nonprofit space. Our customers include NASA, the General Services Administration, Office of Personnel Management, the Library of Congress, Health & Human Services, and the FDIC. We partner with these agencies to build new capabilities, deliver products, establish data as a strategic asset for informed decision-making, modernize legacy systems, and build the digital service infrastructure necessary to scale their mission impact.

Primary Responsibilities

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. Primary expectations of a Senior Data Architect include:

• 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

Basic Qualifications

• 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

Preferred Qualifications

• Prior experience with federal agency data environments or government digital services modernization
• Familiarity with digital artifact/content management lifecycles at scale: upload, storage, review, and archiving
• Experience implementing automated reconciliation and referential integrity validation during migrations
• Exposure to interoperability patterns across AWS and Azure/M365 environments
• Mentorship or technical lead experience within a cross-functional delivery team

To learn more about working at Ad Hoc, please visit:https://adhocteam.us/join

Benefits:

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

Ad Hoc LLC is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, sex, sexual orientation, gender identity or expression, religion, age, pregnancy, disability, work-related injury, covered veteran status, political ideology, marital status, or any other factor that the law protects from employment discrimination.

We value the unique skills gained through military service and encourage veterans and transitioning service members to apply.

In support of various state and city equal pay transparency laws, Ad Hoc job descriptions feature the starting range we reasonably expect to pay to candidates who would join our team with little to no need for training on the responsibilities we've outlined above. Actual compensation is influenced by a wide range of factors including but not limited to skill set, level of experience, and responsibility. The range of starting pay for this role is $150,000 - $160,000. Our recruiters will be happy to answer any questions you may have, and we look forward to learning more about your salary requirements.

job reference:

https://adhoc.team/