Data Architect

Description

We transform lives.

Phoenix Rescue Mission is a place of hope, healing, and new beginnings for men, women, and children facing with hunger, homelessness, addiction, and trauma. We follow Christ’s example of servant-leadership and teamwork in our ministry of rescue and restoration. We are a community who values and celebrates one another and we strive toward excellence together as a certified Best Christian Workplace. At this moment, God is doing important and incredible things at Phoenix Rescue Mission. Do you want to be a part of it?

WHO WILL LOVE THIS JOB

• A strategic thinker, you can see around corners and develop forward-looking plans that will put the organization in the best place possible.
• A data expert, you use creative solutions to analyze significant amounts of data and craft narratives that drive strategy and execution.
• A motivated fixer, you are energized by problem solving and helping others troubleshoot issues.
• A self-starter, you thrive when working independently on multiple projects, ensuring that you are meeting deadlines.
• An efficient worker, you have top-notch organizational skills and can keep multiple plates spinning in the air.
• A committed Christian, you are energized by spreading God’s Word and growing His Kingdom.

YOUR TOP RESPONSIBILITIES

• You will be a strategic leader responsible for designing, implementing, and governing the enterprise data architecture at PRM.
• You will ensure the integrity, scalability, and accessibility of organizational data while aligning technical systems with mission-driven goals.
• You will build and maintain the infrastructure needed for advanced analytics, operational reporting, forecasting, compliance, and strategic decision-making. 
• You will architect, maintain, and optimize Snowflake or other data warehouses and schemas to support scalable, secure, and performant data access.
• You will design and manage end-to-end data flows from ingestion to transformation, storage, and analytics across all platforms, including, but not limited to, ERP, CRM, HRIS, and financial systems.
• You will establish and enforce enterprise-wide data governance policies, including metadata standards, naming conventions, access controls, and data lineage documentation.
• You will ensure high data quality, integrity, and standardization across internal and external data sources; implement robust validation and QA processes.
• You will develop and manage secure, automated data pipelines (ETL/ELT) using modern data stack tools such as Fivetran, dbt, or Azure Data Factory.
• You will partner with analytics, IT, and program stakeholders to deliver data infrastructure that supports forecasting, AI/ML initiatives, KPI dashboards, and donor impact reports.
• You will continuously evaluate and enhance the data architecture to meet evolving organizational needs, scaling with new tools, data sources, and user demands.
• You will lead or participate in devotions, prayers, or other organization activities that promote a credible Christian witness and lifestyle.

WHAT YOU SHOULD HAVE

• A bachelor's degree in information technology, information systems, computer science, or a related field and at least 5 years of experience in data architecture, data engineering, or enterprise data modeling, or a combination of education and experience.
• You have advanced proficiency in SQL and Snowflake, including performance tuning, roles/permissions, and schema design.
• Experience in Power BI and designing data models for self-service BI environments is preferred.
• Exposure to forecasting, predictive analytics, and machine learning workflows is preferred.
• You have hands-on experience managing data pipelines and integrations across a multi-system enterprise (ERP, CRM, finance, HR, programs).
• You have a strong understanding of HIPAA, PHI, and PCI DSS compliance requirements and data privacy principles.
• You have experience building governed, scalable datasets for analytics, reporting, and operational use cases.
• You have excellent verbal and written communication skills.
• You have the ability to translate technical needs into business outcomes.
• A solid and credible Christian witness and lifestyle that exemplifies Christ in character and actions.

WHAT WE OFFER

• Life-giving work that transforms the cities we serve
• Caring and supportive environment
• Generous health, dental, and vision benefits
• 401(k) match program
• Robust paid time off program
• 12 paid holidays annually