Senior Data Engineer

  • Dresher, PA
  • Posted 18 days ago | Updated 10 hours ago

Overview

Remote
On Site
Contract - W2

Skills

Change data capture
PL/SQL
Financial services
Decision-making
Data processing
Data warehouse
Customer service
Data structure
Data integration
Meta-data management
Data marts
Extract
transform
load
Application Support
Data loading
Quality control
Code review
Quality assurance
Unit testing
Test cases
Software development
Analytical skill
Active listening
Data modeling
Programming languages
Relational databases
SAP Sybase ASE
Data
Oracle
SQL
Python
C
Design
Scalability
SAP BASIS
Planning
Metrics
Replication
Specification
Orchestration
Management
Warehouse
Communication
Writing
Documentation
Java
MySQL
DICE

Job Details

Senior Data Engineer
(ETL, Oracle Data Stores, PL/SQL, SQL, Python)
*Cannot sponsor. Cannot work c2c at this time.
*6-12 month Contract on W2
*100% Remote
*EST Working Hours

Position Summary
As a Senior Data Engineer at THIS ENTERPRISE (Financial Services), you will enable data-driven decision making by collecting, transforming and visualizing the data. You will design, build, maintain and troubleshoot data processing systems with emphasis on security, reliability, fault-tolerance, scalability, fidelity, and efficiency. You will be part of the Data Warehouse (DW) team.

Job Functions, Essential Duties and Responsibilities
  • Responsible for protecting, securing, and proper handling of all confidential data held by THIS ENTERPRISE to ensure against unauthorized access, improper transmission, and/or unapproved disclosure of information that could result in harm to THIS ENTERPRISE or our clients.
  • Our I-Client service philosophy and our Core Values of People Matter, Quality First and Integrity Always should be visible in your actions on a day-to-day basis showing your support of our organizational culture.
  • Design, build and maintain data structures and data processing systems (tools, infrastructure, frameworks, services).
    • Assist with Data Warehouse project definition and planning.
    • Implement and troubleshoot deployments.
  • Data Integration
    • Services
      • Design and build data ingestion tools, metrics, alerts and notifications, metadata management.
      • Design and build data replication services and Change Data Capture (CDC) processes to incrementally update data in the data warehouse / data marts from Ascensus systems of record.
    • ETL development
      • Contribute to standards and best practices for implementing ETL tools in support of the DW vision and reference architecture.
      • Build and maintain ETL solutions and platform.
      • Participate in creating long term ETL application support model.
  • Data Warehouse and Data Marts
    • Develop technical standards and specifications addressing performance, security and orchestration of ETL and data warehouse / mart management.
    • Organize metadata and define processes for loading data into and extracting data from the warehouse / marts.
  • Quality Control
  • Peer code review and quality assurance duties throughout the data warehouse project life cycle; creating, executing and updating unit test plans and test cases for necessary projects and application releases.
  • Assist with other tasks and projects as assigned

Experience, Skills, Knowledge Requirements
Required skills and experience
  • 6+ years of relevant experience in data/software development, including data warehousing and ETL tools, techniques and technology.
  • Bachelor's degree or equivalent work experience.
  • Excellent analytical skills.
  • Excellent oral and written communication skills including active listening. Asking appropriate questions, clarifying information and writing clear, concise documents.
  • Strong knowledge of SQl
  • Significant PL SQL experience
  • Very good understanding of data modeling techniques.
  • Strong knowledge of Data Warehousing and ETL design/tools.
  • Strong expertise in Java or other data related programming languages.
  • Extensive Oracle and Pl/SQL experience and skills
  • Good experience with relational databases like Sybase ASE, Oracle, MySQL.

#LI-JC
#Tential
#Dice
#remote
#Dice-remote

About Tential