Introduction
Visium Resources has been asked to identify qualified candidates for this Data Engineer position. This position is a 18-24 month contract opportunity which is expected to be Hybrid with the expectation that engineer can work onsite in Norman, OK Monday and Tuesdays each week.
Summary
Client is implementing a new enterprise data platform using Snowflake. Phase 1 is expected to incorporate data from PeopleSoft Student, PeopleSoft Human Capital Management, PeopleSoft Financials, Ellucian Banner, Slate, and Instructure Canvas. The implementation includes ingestion, transformation, data modeling, data quality, governance, master data and identity-related work, historical-data conversion, reporting enablement, testing, and operational transition.
The Data Engineer will design, develop, test, deploy, document, and support data pipelines and transformation processes for the Snowflake EDW and, when assigned, the existing Oracle ODS environment. The resource must be capable of independently producing high-quality SQL and data-engineering deliverables while working within architecture established by client and the project's Data Architect.
Job Description:
- Develop and maintain source-to-target ingestion and transformation pipelines for structured enterprise data.
- Write, optimize, test, and troubleshoot complex SQL in Snowflake and Oracle environments.
- Implement transformation logic, conformed structures, crosswalks, reference data, historical-data loads, incremental processing, and reconciliation controls.
- Support identity matching, survivorship, mastered identity records, and related master-data processes as defined by CLIENT architecture and governance decisions.
- Work with source-system experts to profile data, identify anomalies, document rules, and resolve data-quality issues.
- Develop automated data-quality checks, exception handling, auditability, monitoring, logging, and operational alerting.
- Create unit, integration, regression, performance, and reconciliation tests for data pipelines.
- Tune queries and workloads for performance, reliability, scalability, and cost efficiency.
- Use source control, code review, continuous integration and deployment, and environment-promotion practices adopted by CLIENT.
- Document data flows, transformations, dependencies, runbooks, recovery procedures, and production-support requirements.
- Troubleshoot and resolve production data issues in Snowflake, the Oracle ODS, and associated pipelines as assigned.
- Transfer knowledge to CLIENT staff and assist in establishing repeatable data-engineering standards and patterns.
Qualified candidates would have the following:
- Demonstrated professional experience performing hands-on data engineering in complex production environments.
- Advanced SQL development and performance-tuning skills.
- Production experience with Snowflake, including data loading, transformation, security-aware development, workload optimization, and operational support.
- Experience developing and supporting data pipelines using modern orchestration, ELT, ETL, or transformation tooling.
- Experience with dimensional modeling, normalized data structures, slowly changing dimensions, historical-data management, and source-to-target mapping.
- Experience implementing automated testing, data-quality controls, reconciliation, monitoring, and error handling.
- Experience with Git-based source control and structured development, testing, and deployment practices.
Preferred Qualifications
- Experience with Oracle databases and enterprise ODS or data warehouse environments.
- Experience integrating PeopleSoft, Ellucian Banner, Slate, Canvas, or comparable higher-education systems.
- Experience with identity resolution, master data management, crosswalks, and data-governance workflows.
- Experience with Snowflake-native capabilities and tools such as dbt, Informatica, or comparable enterprise data-integration platforms.
- Experience supporting higher education, especially student, finance, human resources, admissions, learning-management, or institutional-reporting data.
- Experience handling regulated or confidential data, including FERPA-protected student records or comparable data-protection requirements.
- Availability to work a hybrid schedule and come on-site in Norman, Oklahoma, when beneficial to the project.
- Completion of a vendor-provided background check or willingness to complete an acceptable background check before receiving CLIENT system or data access.
- Snowflake or relevant data-engineering certifications.
- Residence within reasonable commuting distance of Norman, Oklahoma, or another practical arrangement for periodic on-site work.
Visium Resources is an award-winning employment firm with a mission to match talented individuals with highly successful organizations. At Visium, our company’s success is based on your success. When you work with us, you are never “just a number”. You are our most important asset. Here, you will know us by name through our regular visits to client sites and even occasional luncheons. We will always be there when you need assistance and will always go the extra mile to ensure that you are as successful as possible. Whether you're looking for contract, contract-to-hire or permanent opportunities, we firmly believe there is no employment agency that will work harder for you than Visium. Visium Resources is an equal opportunity employer and values diversity. All employment is decided based on qualifications, merit and business need.
