Senior Data Engineer (remote)

This is a fully remote position. Work on things that matter Ad Hoc is a digital services company that assists the federal government in better serving its citizens. Our teams use contemporary, agile methodologies to design and create government systems that link Veterans with services, offer affordable healthcare to millions, and assist crucial programs like Head Start. As we make vital government services intuitive, accessible, and centered on human needs, we’re also transforming how the government perceives and employs technology. If you thrive on change, desire to assist in narrowing the gap between consumer expectations and government services, and see potential in ambiguity, we want you on board.  What matters most Ad Hoc operates based on our dedication to inclusivity, acceptance, accountability, and humility. We don't consider ourselves heroes. We believe in missions that transcend our individual selves, check our egos at the door, learn from our mistakes and iterate to better serve the people in our country. We prioritize creating teams that mirror the diversity of the people our government serves. We are eager for challenges in government-size projects. We aim to bring skills to federal agencies, assist them in better addressing their user needs, and close the gap between consumer expectations and government services. Built for a remote life Ad Hoc has always been and continues to be a remote-first company. Since inception, we've designed our culture, communication, and tools to be conducive for a nationwide distributed team. Being remote by design allows Ad Hoc to deliberate about creating diverse teams and supporting them with a work environment that suits their lives. With a generous PTO policy and Slack channels catered to every interest (from bird watching to space enthusiasts to parenting) our culture embraces all aspects of your life. Maybe you need to adjust your schedule to accommodate your family or take a bike ride. At Ad Hoc, that's accepted. The chosen candidate will display influential skills to drive improvements in data engineering processes and practices. They will also show a comprehensive understanding of the business, practices, and the needs of customers. They will build systems that collect, manage, and transform raw data into usable information for data analysts to interpret, making data accessible to VA leaders for understanding, evaluating, and optimizing Veteran experiences. Organizational Overview: The Veterans Affairs business unit aids in transforming the VA into a modern digital services organization where Veterans' outcomes are at the core of all endeavors. We work in partnership with the VA to design and render seamless user experiences for Veterans, their families, caregivers, and VA employees. By applying enhanced practices in service design, product management, and technology, we assist the VA in increasing the usage, quality, and reliability of services while reducing the waiting time for Veterans' outcomes. Primary Responsibilities: In this role, you serve as an experienced individual contributor within a team, with the prospect of further honing your leadership, guidance, and mentoring skills. With minimal supervision from the leadership, you will be responsible for supporting the objective of meeting scope, schedule, and delivery requirements. A Senior Data Engineer impacts the long-term goals of the program while contributing to the evolution of the program's data strategy. As a Senior Data Engineer, you might serve as the discipline's primary lead when collaborating with stakeholders. Your primary expectations will include: - Strong influential skills to propose and evaluate multiple approaches to technical and process problems - Serving as a mentor within the team - Possibly leading small, less critical, or temporary team structures and projects - Presenting design documents, system diagrams, etc., to clients, stakeholders, partners, and other engineers - Fully understanding and consistently implementing data engineering best practices - Generating data architecture recommendations and showcasing the ability to implement them - Diagnosing and effectively resolving issues with the systems at their disposal, using incidents to inform educational opportunities and system improvements - Actively mentoring and aiding junior engineers in their skill development - Effectively communicating technical issues and developments with team members and clients - Delivering large features and foundational improvements with minimal guidance and support - Participating in technical interviews with new candidates Basic Qualifications: - Degree - Bachelor’s in Business Administration, Business Management, Computer Science, Information Systems, Information Resource Management, Industrial Engineering, or related fields - 7 years of professional experience - 10 years of professional experience may be substituted for a Degree - Expert level SQL - Intermediate experience with Python (including PySpark) - Experience with data warehousing and data conditioning for analysis, using BigQuery, Synapse, and other tools - Experience with Databricks, Redshift, or similar (MPB warehouse or lakehouse) - Experience with Terraform or other infrastructure as code - Experience gaining access to siloed data sources, integrating into a single working environment - Working with other technical experts on access requests process espy Preferred Qualifications: - Experience with JSON, Parquet formats - Experience working with SAS and other flat files Learn more about engineering at Ad Hoc. Benefits: - Company-subsidized Health, Dental, and Vision Insurance - Use What You Need Vacation Policy - 401K with employer match - Paid parental leave after one year of service 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 other similar laws across the country, Ad Hoc job descriptions include the starting range we reasonably expect to pay candidates who would join our team with little to no need for training on responsibilities, as outlined above. Actual compensation is influenced by a broad range of factors such as skill set, level of experience, and responsibility. The range of starting pay for this role is $101,570 - $130,000, with more information available on the benefits offered here. Our recruiters are eager to answer any questions you have, and we look forward to knowing more about your salary requirements. Job reference: 2166