Database Architect

About Us

HSP Direct, based in Ashburn, VA, is a leading full-service direct mail fundraising agency. We provide direct mail and online fundraising, audience cultivation, production services, graphic design, and list and data services through our affiliated companies. Driven by data and conservative values, we proudly serve over 100 non-profit and political clients. We're seeking highly motivated team members to join us on the cutting edge of data and fundraising.

Job Summary
Join our innovative team as a Data Architect, where you will take strategic ownership of our data ecosystem—from data warehouses and lakes to cutting-edge analytics platforms. Based in our dynamic technology environment and leveraging platforms such as Azure, Synapse, and SQL, you will lead the design, modeling, integration, and governance of enterprise data solutions. If you are passionate about shaping how organizations use, store, and analyze data, and love guiding technology choices and frameworks, this is your chance to drive real impact.

This is a full-time on-site role located in Ashburn, VA.

Roles and Responsibilities

• Architect and design scalable, high-availability data platforms: warehouses, lakes, and lakehouses within Azure and related technologies.
• Lead enterprise data modeling efforts, establishing standards and frameworks for structured and unstructured data.
• Define and enforce data governance policies—ensure data quality, consistency, security, and compliance across all platforms.
• Strategically guide technology choices for data storage, analytics, and integration, aligning solutions with business goals.
• Oversee integration of data sources, ETL pipelines, and analytic workflows, partnering with stakeholders to optimize data accessibility and utility.
• Develop and maintain robust data architecture documentation, including conceptual, logical, and physical models.
• Set best practices for data management, metadata, and master data strategies.
• Collaborate with development, analytics, and business teams to ensure architectural integrity and seamless solution delivery.
• Evaluate emerging technologies and recommend enhancements to the data architecture roadmap.

Qualifications & Skills

• Bachelor's degree in Computer Science, Information Technology, or related field.
• Minimum 5 years' experience in database or data architecture roles.
• Deep expertise with Microsoft SQL Server, Azure SQL, and Azure Synapse.
• Advanced proficiency in data modeling, OLAP, ETL frameworks, and large-scale data integration.
• Practical knowledge of database languages (SQL, R, Python) and familiarity with semi-structured file formats.
• Experience designing data lakes/lakehouses and strategic data infrastructure.
• Strong understanding of analytics, business intelligence, and data visualization tools.
• Knowledge of RedPoint Data Management Platform is highly desirable.
• Azure data or infrastructure certifications are a bonus.
• Excellent analytical, problem-solving, and communication skills.

Opportunities

• Play a key strategic role in shaping the company's data strategy and technology roadmap.
• Lead enterprise-wide initiatives and leave your mark on advanced data solutions.
• Engage with the latest cloud and analytics technologies, driving innovation and digital transformation.
• Grow into leadership and architecture roles as the data team expands.

Company Culture

At HSP, we value innovation, collaboration, and continuous learning. Our work environment encourages creative problem-solving and open communication across teams. We are committed to integrity, results, and empowering our employees to take ownership of impactful projects. Join us to be surrounded by talented professionals who are passionate about technology and business success.

The ideal candidate will have excellent problem-solving and analytical skills, with the ability to work in a fast-paced environment and communicate effectively with both technical and non-technical staff.

Company Benefits

• Competitive salary commensurate with experience.
• Comprehensive benefits package including health, dental, and vision insurance.
• Annual staff events including field day, golf and spa outings, offsite Christmas party, and more.
• 401(k) with company match.
• Generous PTO and holidays.
• MAHA approved snacks and drinks.
• Company goal trips.
• Onsite fitness center.

If this challenge seems like a great fit for you and you would like a promising career path, please apply with a cover letter, resume, and salary requirements. Cover letter is required for consideration.

Employment Eligibility

In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification form upon hire. HSP Direct will not sponsor work visas.