Job description

CardWorks Servicing ("CWS") is one of the largest privately-held provider of outsourcing services for bankcard-related products to banks and non-bank lenders in North America. CWS offers management expertise across the credit spectrum and supports both MasterCard and Visa accounts as well as a variety of private label debit, credit, stored value, and customer bankcards.

Position Summary:
As a Senior Data Engineer, you will support data related initiatives within Data Strategy and Architecture (DSA) department with a focus on enabling data operations and analytics platform and enabling data for consumption by data operations, reporting, business intelligence and analytics user community. This role is responsible for developing data ingestion patterns, data extraction, load, and transformation (ETL) programs for the initiative, developing and executing ETL test plans, and automating the ETL process through scheduling and exception-handling routines

Essential Functions:

• Works with business teams to understand business use cases, requirements
• Works with applications specialists (SMEs) to understand data sources and perform data discovery and document the learnings
• Creates ETL system design specifications and data flow diagrams
• Prepares technical and system specifications documents including Source to Target Mapping covering data sources integration patterns, controls, data transformation and load rules.
• Designs, develops, tests and deploys ELT programs to extract, stage, cleanse, transform and load the data needed
• Troubleshoots, maintains and supports the warehouse and the downstream data feeds sent to consuming applications
• Supports system, integration and UAT testing
• Assists with performing source data quality assessments
• Performs root cause analysis, resolve production issues and support production teams
• Performs other job duties as assigned and fulfill report and data extraction requests as needed
• Adherence

Education and Experience:

• Bachelor's degree in Software Engineering/Computer Science/Information
• Five (5) years’ experience in ETL/ELT development using Informatica products such as data Catalog, Data Integration and Data Quality etc.
• Proficiency in warehousing architecture techniques, including Data Lake, ODS, DM, and EDW
• Experience in one or more scripting languages: Python, Boto3, Pandas, SQL and/or Kafka
• Experience working in Analytics Databases like Snowflake, Redshift and Big Query
• Experience in snowflake and AWS Cloud technologies will be an added advantage
• Ability to analyze a company’s big-picture data needs
• Strong project management skills
• Clear communication skills
• Ability to troubleshoot and solve complex technical problems
• Consumer Financial Services background, preferably credit card business knowledge

Summary of Qualifications:

• Ability to gather requirements, apply strong analysis and design
• Proficient in designing and developing SQL Queries & ETL Programs
• Strong project management & analytical skills
• Ability to work with data warehouse users, IT Business Analysts
• Strong problem solving, written and verbal communication skills
• Hands on experience with SQL-Based databases highly beneficial (and preferred)
• Knowledge of Cloud-based solutions and databases beneficial (e.g. Snowflake)
• Proficiency in Python preferred

Work Environment/Physical Demands:

• Work is in an office environment, sustained posture in a seated position for prolonged periods of time; works with computer equipment for prolonged periods of time
• Some stress may occur
• Some travel may be required
• This position reports to an assigned manager and typically supervises no one
• Routine interaction with multiple levels of the organization including the executive team
• Minimal rotating weekend and holiday support is required

If this position is based in our Woodbury, Long Island office or Virtual, please note that ALL the work for this position must be performed outside of the five Boroughs of New York City.

We are an equal opportunity employer, and we evaluate qualified applicants without regard to race, color, religion, sex, national origin, disability, veteran status or any other legally protected characteristic. We will conduct a thorough background check for all hires in compliance with applicable law which includes (but may not be limited to) a review of factors including the applicant’s personal credit history, drug testing, and employment/personal references.

abouteureka.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, abouteureka.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, abouteureka.com is the ideal place to find your next job.