DataJobs.io
← Back to all jobs

Job Description

Palmer College of Chiropractic Foundation is seeking a Data Engineer to design, build, and maintain data integration solutions that enable governed delivery of information across reporting, analytics, system implementations, and data governance initiatives. In this onsite role in Davenport, IA, you will develop ETL/ELT pipelines, support Snowflake-based data structures, and collaborate with College stakeholders and vendors to ensure reliable, secure data flows.

What you’ll do

  • Build and maintain ETL/ELT pipelines and integrations that move data between enterprise applications, databases, cloud platforms, APIs, and external partners.
  • Administer and improve Snowflake data structures, including security, transformations, and automated processing for operational and analytical needs.
  • Prepare governed data for reporting, analysis, and institutional decision-making.
  • Support data migrations and system implementations through mapping, transformation, testing, reconciliation, and production deployment.
  • Monitor and troubleshoot data processes, strengthen data quality and security controls, maintain technical documentation, and partner with College stakeholders and vendors.

Required qualifications

  • Bachelor’s degree or an equivalent combination of relevant education and professional experience.
  • Three years of professional experience in data engineering, data warehousing, data integration, database development, or a closely related field.
  • Proven ability to develop production SQL and Python solutions and support ETL/ELT pipelines in a cloud or enterprise environment.
  • Experience with relational databases, APIs, structured data files, source control, testing, troubleshooting, and technical documentation.
  • Excellent customer service and communication skills, with the ability to work effectively across all levels and with external vendors and support partners.
  • Strong organization, accuracy, thoroughness, accountability, and commitment to high-quality work.
  • Regular and reliable attendance, including availability for scheduled evening or weekend work and response to critical production issues as required.

Technologies and tools

  • ETL/ELT, SQL, Python
  • Azure Data Factory, Azure Blob Storage, Azure Batch, Azure DevOps
  • Snowflake
  • REST APIs, CSV, XML, JSON, SFTP

Key technical skills

  • ETL/ELT development, orchestration, data integration, transformation, staging, file processing, migration, and reconciliation.
  • Advanced SQL and Python for data processing, automation, validation, and testing.
  • Azure identity, monitoring, networking, and security services as part of Azure Data Factory, Azure Blob Storage, Azure Batch, and Azure DevOps.
  • Snowflake administration and development, including dimensional and relational design, schemas, tables, views, stages, ingestion, transformations, workload management, and query optimization.
  • Authentication methods and automated file transfers.
  • Metadata management and cataloging, lineage, data products, business glossaries, stewardship, and technical documentation.
  • Pipeline monitoring, logging, alerting, incident diagnosis, data reconciliation, root-cause analysis, and data quality controls.
  • Source-to-target mapping, stakeholder communication, requirements analysis, estimation, and cross-functional problem-solving.
  • Role-based access control, secrets management, secure data transfer, least privilege, and responsible handling of regulated and sensitive data.

Additional skills and work expectations

  • Strong interest in institutional data and building practical solutions for complex data challenges.
  • Ability to translate business requirements into supportable technical designs and explain technical concepts to nontechnical stakeholders.
  • Strong analytical, troubleshooting, organizational, time-management, documentation, and communication skills.
  • Ability to work independently, manage competing priorities, and collaborate in a service-oriented, team-based environment.
  • Ability to design, build, test, deploy, monitor, and maintain data pipelines, platforms, applications, and warehouse objects that meet institutional standards.
  • Experience participating in scheduled maintenance, production support, and after-hours incident response when required.
  • Knowledge of higher-education data domains and privacy or security requirements, including FERPA, HIPAA, and PCI DSS.

Reporting and relationships

  • Reports to the Director of Applications and provides support responsibilities to other departments and College personnel as necessary.

Work environment and physical requirements

  • Sedentary to light work in a ventilated, lighted, and temperature-controlled office setting.
  • Frequent need to stand, stoop, walk, sit, and lift light objects up to 10 pounds, along with similar actions during the workday.
  • Frequent use of a computer, keyboard, telephone, and other standard office equipment, including extended screen work.

Additional duties may be assigned in support of institutional data management, system integration, reporting, operational efficiency, and technology initiatives. All responsibilities must be performed in alignment with Palmer College of Chiropractic policies, including Equal Employment Opportunity and Affirmative Action requirements.

Similar Jobs