• 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.

Data Analytics and Visualization

• 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.

Database Administration

• 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.

• 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.
• Bachelor’s degree in Computer Science, IT, Engineering or related field preferred.
• 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.

Starting salary range is $111,200 to $125,100, commensurate with education and experience.

BENEFITS

• Peer Exchange among the senior leaders of HPN member organizations who share knowledge and ideas to advance best practices in the field.
• Policy and Advocacy to strengthen the impact, scale, and sustainability of the sector.
• Innovation R&D is borne from ideas surfaced through peer exchange which HPN staff explore and test.
• Social Enterprises that HPN and members develop together are launched to address current affordable housing and community development challenges and advance innovative solutions.