This is a fully remote position.

Work on things that matter

Ad Hoc is a digital services company that helps the federal government better serve people. Our teams use modern, agile methods to design and engineer government systems that connect Veterans with services, bring affordable health care to millions of people, and support important programs like Head Start. And as we work to make critical government services intuitive, accessible, and human-centered, we're also changing how the government thinks about and uses technology. If you thrive on change, want to help close the gap between consumer expectations and government services, and can see the possibilities in ambiguity, then we want you here with us.

What matters most

Ad Hoc operates according to our commitment to inclusivity, acceptance, accountability, and humility. We aren't heroes. We believe in missions larger than our individual selves and leave our egos at the door, learn from our mistakes, and iterate in order to better serve the people in our country. We prioritize building teams that represent the diversity of the people our government serves. We love the challenge of government-size projects. We want to bring skills to federal agencies, help them better meet the needs of their users, and close the gap between consumer expectations and government.

Built for a remote life

Ad Hoc is remote-first and remote-always. We've designed our culture, communications, and tools to support a nationwide distributed team since the beginning. Being remote by design allows Ad Hoc to be thoughtful and intentional about creating diverse teams and supporting them with a work environment that fits their lives. With a generous PTO policy and Slack channels for every interest (from bird watching to space nerds to parenting) our culture embraces the things happening in your life. Maybe you need to adjust your schedule to care for your family or take a bike ride. At Ad Hoc, that's embraced.

A Senior Principal Data Architect is responsible for architecting data solutions that can process petabytes of highly dimensional data. Rather than solving bespoke point solutions, a Senior Principal Data Architect takes a platform-centric view about how they architect these solutions. They will exhibit strong communication and system engineering skills, with the ability to engage with product management, data analysis, and infrastructure engineering teams to create a system architecture roadmap from the present to the future that meets and exceeds stakeholder requirements.

Our ideal Senior Principal Data Architect will serve as the Technical Lead for the data team and oversee technical delivery across all components of Payroll Data as a Product. They will be responsible for identifying and prioritizing data needs that are critical to the State's short-, medium-, and long-term strategy—including DPA's product goals for Payroll Data as a Product, the payroll system overhaul effort, and the State's larger data strategy efforts across agencies—to ensure data is translated and modeled to drive measured, actionable results.

What You'll Do

• Maintain ownership of delivery and outcomes based on technical solutions derived in the product roadmap, providing supporting documentation such as architecture reference proposals and diagrams.
• Support the Senior Data Analyst and data team with iterative development of a unified Data Dictionary to standardize data definitions across agencies and serve as a baseline to drive all future investigation into and development of the data environment.
• Lead architectural design and implementation of a Data Warehouse platform that meets the needs of the State's Payroll Community, leveraging modern warehouse platform solutions that are approved for use, easy to manage, and highly scalable.
• Lead design and development of associated data pipelines to receive data from the State's Personnel & Payroll System, and other data sources identified in the future.
• Lead and support the Data Analyst's efforts to build reporting channel proof of concept solutions that provide business analytics insight on payroll data.
• Provide API solution recommendations to support consistent integration developer experiences, establish data normalization, leverage unified pagination, and explore a single canonical data model for integrations as needed.
• Work with the Product Manager, State's Product Owner, and other payroll system stakeholders (as needed) to craft a plan and define the design expectations for the new reporting environment for the future payroll system overhaul effort.

The Senior Principal Data Architect is responsible for (Essential Functions):

• Leading architectural design and implementation of a modern data platform, coordinating contributions from senior infrastructure, data, and application engineers.
• Accountable for the development of an ontology-based semantic layer and setting standards for a common and recognizable visual language for all data users and sources.
• Modernizing, iteratively upgrading, and sometimes replacing other systems that often predate and interact with the data platform.
• Collaborating with infrastructure engineering in the design progression of data systems in an Amazon Web Services context, including the best-practice use of AWS services like S3, Redshift, SNS/SQS.
• Planning and minimizing total costs across services.
• Leading and providing practical experience in the evaluation of potential alternative cloud-native data services such as DataBricks, Snowflake, FiveTran
• Understanding the strengths and tradeoffs of different strategies for processing large amounts of data for analytic use, including ETL vs ELT, denormalization and materialization, when to structure data, and how to handle deltas in data from outside sources.
• Ensuring the combination of human and machine processes provide robust defense-in-depth of sensitive data confidentiality through the implementation of security best practices.
• Guiding the development and execution of business logic, with the ability to provide oversight of the development of acquisition, transformation, and downstream consumption work streams
• Advancing data governance, conducting inventory evaluations and subsequently developing solutions to eliminate identified data gaps and improve data maturity
• Identifying approaches for data management based on specific variables, inclusive of importance, complexity and probability of success
• Exhibiting strategic and critical analysis leadership, with the ability to summarize findings and provide comprehensive recommendations
• Executing effective governance by collaborating with data owners and users to modify or implement new repeatable and reliable businesses processes
• Aligning data architecture and standardize data access patterns to make data available to business intelligence tools, apps, and websites
• Fostering team excellence in SQL and complex data schema design.
• Collaborating with a multidisciplinary team of product owners, engineers, designers and researchers, and adapting communication style to the audience
• Providing oversight of data organization, data dictionary standardization, and glossary development to align with data models

Some basic requirements

• All work must be conducted within the U.S., excluding U.S. territories. Some federal contracts require U.S. citizenship to be eligible for employment.
• You must be legally authorized to work in the U.S now and in the future without sponsorship.
• As a government contractor, you may be required to obtain a public trust security clearance.
• 6+ years of professional experience
• High School Diploma or Equivalent

Benefits

• Company-subsidized Health, Dental, and Vision Insurance
• Vanguard 401K Plan
• Use what you need vacation policy
• Continuing Education/Annual Conference Attendance Stipend

Ad Hoc LLC is an Equal Opportunity/Affirmative Action 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.

In support of the Colorado Equal Pay Transparency Act, and others like it across the country, 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 $144,854 - $192,564 and information on benefits offered is here. Our recruiters will be happy to answer any questions you may have, and we look forward to learning more about your salary requirements.