Data Engineer

Details:

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 projects 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.

Details:

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.

• 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 companys 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 youre 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.

Required Experience:

IC