DeveloperJobs.io
← Back to all jobs

Job Description

The Palmer College Foundation is seeking a Data Engineer (onsite in Davenport, IA) to design, build, and maintain data integration solutions, ETL/ELT pipelines, and cloud and data warehouse capabilities. This role enables governed data delivery to support reporting, analytics, system implementations, and data governance efforts.

Key Responsibilities

  • Build and support dependable ETL/ELT pipelines and integrations that move data among enterprise applications, databases, cloud platforms, APIs, and external partners.
  • Administer and enhance Snowflake data structures, security, transformations, and automated processing to support operational and analytical requirements.
  • Prepare governed data for reporting, analytics, and institutional decision-making.
  • Support data migrations and system implementations by performing mapping, transformations, testing, reconciliation, and production deployment.
  • Monitor and troubleshoot data processes, improve data quality and security controls, maintain technical documentation, and collaborate 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 experience developing production SQL and Python solutions and supporting ETL/ELT pipelines in a cloud or enterprise environment.
  • Experience working with relational databases, APIs, structured data files, source control, testing, troubleshooting, and technical documentation.
  • Strong customer service and communication skills, including the ability to work effectively with individuals at all levels and with external vendors and support partners.
  • Demonstrated organization, accuracy, thoroughness, accountability, and commitment to work quality.
  • Regular and reliable attendance, including availability to perform scheduled evening or weekend work and to respond to critical production issues as required.

Technical Skills and Competencies

  • ETL/ELT development, orchestration, data integration, transformation, staging, file processing, migration, and reconciliation.
  • Advanced SQL and Python scripting for data processing, automation, validation, testing, and integration.
  • Azure identity, monitoring, networking, and security services (including components used with 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, 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.
  • Technical writing, 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 Qualifications

  • Interest in institutional data and developing practical solutions for complex data challenges.
  • Ability to translate business requirements into supportable technical designs and to 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 effectively in a service-oriented, team-based environment.
  • Commitment to accuracy, security, maintainability, continuous improvement, and customer service.
  • Ability to learn College goals, business processes, data domains, systems, and operating constraints quickly.
  • Capability to design, build, test, deploy, monitor, and maintain data pipelines, platforms, applications, and warehouse objects that meet institutional standards.
  • Experience managing data storage and access, optimizing schemas and queries, and protecting data quality and integrity.
  • Ability to prioritize and complete work in an environment with production deadlines, frequent interruptions, and multiple concurrent responsibilities.
  • Participation in scheduled maintenance, production support, and after-hours incident response when required.
  • Hands-on experience with Azure Data Factory, Azure Blob Storage, Azure Batch, Azure DevOps, and Azure monitoring or security services.
  • Hands-on Snowflake administration and development experience, including role-based access, stages, tasks, stored procedures, query optimization, and warehouse cost management.
  • Experience supporting enterprise data migrations, system implementations, data reconciliation, and production cutovers.
  • Knowledge of higher-education data domains and privacy or security requirements, including FERPA, HIPAA, and PCI DSS.

Technologies

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

Organizational Relationships

  • Reports to the Director of Applications.
  • Provides support responsibility to all other departments and College personnel as necessary.

Physical Requirements and Work Environment

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

Other Duties

  • Performs additional duties as assigned in support of institutional data management, system integration, reporting, operational efficiency, and technology initiatives.
  • Performs all responsibilities in a manner consistent with Palmer College of Chiropractic policies, including Equal Employment Opportunity and Affirmative Action requirements.

Similar Jobs