Full-Time SQL Developer II (Req#2876)
Job Description
The data engineer role is part of Credit Risk Analytics group and is responsible for providing day-to-day CDM (Credit Data Mart) maintenance, documentation, and quality assurance.
Responsibilities:
- Develops new reporting and dashboards from the CDM and automates existing reporting for the Credit Risk Analytics group and its stakeholders.
- Evaluates, tests, and validates CDM outputs and performs reconciliations to ensure the accurate representation of data and analysis.
- Preforms Business Requirements gathering and user documentation.
- Provides support for internal application programming changes and reporting process.
- Provides issue resolution on daily data loads.
- Knowledgeable with SDLC processes, and able to facilitate changes to a controlled data mart environment.
- Provides Quality Control and Assurance work on monthly team deliverables (various reports and financial disclosures).
- Remediates data quality issues.
- Provides support on requests from internal/external auditors and regulatory agencies.
Education and Experience:
- Bachelor’s Degree in a quantitative field of study (i.e., Accounting, Business, Economics, Finance, Mathematics, Statistics, Engineering), or equivalent work experience.
- 7-10 years of work experience at a financial services company working as data analyst, programmer, or database administrator.
- 5+ years writing complex T-SQL
- Past project work migrating legacy SQL Server Applications to an Azure environment a plus.
- Experience in compliance, audit, or quality assurance a plus.
- Training/certification on MS SQL Server products and Business Intelligence tools a plus.
Skill Set:
- Working knowledge of distributed applications including one or more of the following technologies: SQL Server 2016 and higher; ASP.NET, SSRS, SSIS, Power BI and data visualization tools.
- A robust knowledge of the characteristics and analytics associated with banking product portfolios.
- Experience with large scale data remediation projects, from issue identification, through to remediation/resolution including profiling, data mapping for data warehousing systems.
- Experience with writing and modifying complex SQL.
- Strong verbal and written technical communication skills.
How to Apply
If you will like to learn more and apply, use the link below: https://gka.fa.us1.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX/job/2876/?utm_medium=jobshare52 total views, 0 today