Note: The job is a remote job and is open to candidates in USA. Housing Partnership Network (HPN) is an award-winning membership network of leading affordable housing and community development nonprofits. The Data Platform Engineer will manage and advance HPN’s data infrastructure, build and maintain data pipelines, and optimize cloud-based data platforms to ensure high-quality data accessibility and insightful reporting.
Responsibilities
- Build and maintain data extraction, transformation, and loading (ETL/ELT) pipelines across systems (e.g., Salesforce, Excel, SharePoint, Azure SQL)
- Support integration of source systems with tools like Databricks, Python, Fivetran, and Power Automate to streamline data workflows
- Ensure high performance and reliability of datasets used for operational and strategic reporting
- Support the development of dashboards and reports in Power BI
- Partner with internal stakeholders to gather requirements and deliver usable insights
- Maintain data definitions and documentation to support data literacy across the organization
- Administer, maintain, and optimize highly scalable and performance-oriented Azure SQL databases hosted on the Microsoft Azure cloud platform, ensuring high performance, availability, and security
- Monitor, proactively address, and troubleshoot performance issues, query optimization, and capacity planning to ensure optimal database performance
- Implement and manage database backup, recovery, patching, and security protocols aligned with best practices to safeguard data and ensure business continuity
- Maintain comprehensive documentation for all database systems, configurations, procedures, and processes, including source control tools and protocols
- Adapt software engineering practices to data engineering, including Azure DevOps source control tools for CI/CD pipelines and protocols
- Stay up to date with emerging database technologies and industry best practices including, semantic data modeling
Skills
- 3+ years of experience in a hybrid data engineering / Data Administrator role or similar
- Experience with data lakes, Azure Databricks, Fivetran and Power Automate
- Deep SQL expertise and familiarity with relational database architecture (especially Azure SQL)
- 1+ year of experience with Azure SQL; Azure Database Administrator Associate certification preferred
- 2+ years of experience with Microsoft PowerBI Premium / Fabric
- Proficiency with Azure DevOps source/version control tool
- Ability to write clean, reusable scripts in SQL and Python
- Excellent organizational and communication skills
- Ability to work independently with minimum guidance while prioritizing workloads to meet goals
- Collaborates well with others and works effectively in a team environment
- Azure Database Administrator Associate certification preferred
- Bachelor's degree in Computer Science, IT, Engineering or related field preferred
Benefits
- 15 vacation days
- 12 sick days
- 12 paid holidays
- Paid personal day
- Medical, dental and vision insurance
- Health savings account
- Flexible spending account
- Dependent care flexible spending account
- Retirement, and savings plan/401(k) match
- Group life insurance
- Short- and long-term disability
- Parental leave
- Sabbatical leave
- Professional development
Company Overview
Housing Partnership Network is a non-profit organization that builds affordable housing sectors for low and moderate-income people. It was founded in 1992, and is headquartered in Boston, Massachusetts, USA, with a workforce of 11-50 employees. Its website is https://www.housingpartnership.net.