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.

Requirements

3+ years of relevant professional experience
Demonstrated expertise in data engineering, data integration, or cloud data pipeline development
Familiarity with Snowflake, dbt, and cloud platforms (AWS or Azure)
Building ELT/ETL pipelines, developing incremental loads, and working with structured/unstructured data
Proficiency in SQL and Python for data processing and automation
Knowledge of data modeling principles, data warehouse design, and performance optimization
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
Strong project management and problem-solving skills
Ability to work independently while collaborating with internal teams
Excellent written and verbal communication skills.

Benefits

Contractors are not eligible for employee benefits, including health insurance, retirement plans, or paid leave.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data engineeringdata integrationcloud data pipeline developmentSQLPythondata modelingdata warehouse designELTETLDAX

Soft Skills

project managementproblem-solvingcollaborationcommunicationindependence

Certifications

AWS Certified Data Analytics – SpecialtyAzure Data Engineer Associatedbt Fundamentalsdbt Analytics Engineering Certification