Independent Contractor (1099) – Data Engineer

Description

Organization Overview

Phoenix Rescue Mission is a nonprofit organization dedicated to providing Christ-centered solutions to people facing hunger, homelessness, addiction, and trauma. Our work focuses on food distribution, homeless outreach, and residential recovery, and we are committed to creating meaningful impact in the communities we serve.

We partner with experienced professionals who bring specialized expertise to help strengthen our programs, systems, and organizational effectiveness.

Position Overview

Phoenix Rescue Mission is seeking an experienced Data Engineer to provide professional services in support of our mission. This individual will work collaboratively with internal stakeholders to deliver high-quality expertise and solutions that advance our organizational goals.

This role is designed as a consulting engagement focused on clearly defined projects and deliverables.

This position is an independent contractor (1099) role and is not a W-2 employee position.

Scope of Work

The contractor will support the organization through work such as:

• Designing, implementing, and optimizing data ingestion pipelines and automated workflows using tools such as Snowflake, Snowpipe, dbt, and cloud services (AWS or Azure)
• Integrating data from multiple sources including APIs, databases, Excel/CSV files, and cloud applications into PRM’s centralized data warehouse
• Developing and maintaining structured data models and curated datasets to support reporting, analytics, and operational insights
• Implementing data quality validation, monitoring, and governance controls to ensure reliability, accuracy, and compliance with internal standards
• Collaborating with PRM staff across IT, analytics, and program teams to translate business requirements into scalable data solutions
• Designing, developing, and optimizing Power BI datasets, reports, and reporting infrastructure to support operational dashboards, analytics, and program insights
• Documenting data pipelines, models, workflows, and architecture to support maintainability and knowledge transfer
• Delivering defined project milestones aligned with PRM’s ongoing data modernization efforts

Expected Deliverables

Examples of project deliverables may include:

• Implementation of automated data pipelines to ingest operational and program data into Data Warehouse.
• Development of curated datasets, data models, and reporting structures to support analytics and reporting.
• Design and development of Power BI datasets, dashboards, and reports to support operational insights and decision-making.
• Implementation of data validation, monitoring, and quality controls to ensure accuracy and reliability of data pipelines.
• Documentation of data architecture, pipelines, workflows, and data models to support maintainability and knowledge transfer.

Deliverables will be mutually agreed upon before the start of the engagement.

Requirements

Qualifications

Successful contractors typically bring:

• Demonstrated expertise in the following:
• Data engineering, data integration, or cloud data pipeline development
• Snowflake, dbt, and cloud platforms (AWS or Azure)
• Building ELT/ETL pipelines, developing incremental loads, and working with structured/unstructured data
• SQL and Python for data processing and automation
• Data modeling principles, data warehouse design, and performance optimization
• 3+ years of relevant professional experience
• AWS Certified Data Analytics – Specialty or Azure Data Engineer Associate
• dbt Fundamentals or dbt Analytics Engineering Certification
• Power BI experience, including dataset modeling and DAX
• Familiarity with CI/CD workflows, Git-based version control, and orchestration tools
• Understanding of metadata management, data governance, and security frameworks
• Exposure to forecasting, advanced analytics, or machine learning workflows
• Experience working in non-profit, human services, or impact-measurement environments
• Strong project management and problem-solving skills
• Ability to work independently while collaborating with internal teams
• Excellent written and verbal communication skills

Contract Structure

This opportunity is structured as a professional services engagement.

Key points regarding contractor status:

• This role is a 1099 independent contractor position, not a W-2 employment role.
• Contractors operate as independen