ETL/Oracle Developer - Data Analytics & Reporting Finance (ABS)
Overview
Opportunity to work in a hybrid model: potential to work 3-4 days per week from home. Sponsorship Opportunities Available.
ETL/Oracle Developer - Data Analytics & Reporting, Finance (ABS) is a critical technical role within the GMF North America Securitization and Conduit Reporting team. This position will design process improvements, create SQL reports, write functional specifications, develop, and test system plans, document processes and programs, advise users on program use, and resolve production problems. This position involves a high level of coordination with other departments and third-party software vendors.
Responsibilities
JOB DUTIES
- Analyze Data to troubleshoot process problems and drive process improvement
- Define functional requirements including requests for new reports or system enhancements
- Translate complex requirements into business requirements/functional specifications documents in coordination with the data warehouse teams
- Understand data warehouse design and data modeling
- Develop SQL, PL/SQL, Access, Cognos queries to manipulate analyze and report on large data sets
- Data extraction, creation, manipulation of multiple files and or databases
- SQL/PL SQL code tuning and Query optimization
- Responsible for the analysis, design, development, and maintenance of ETL processes and applications using SQL and ETL tools
- Responsible for evaluating the use of data, ensures the accuracy and accessibility of all important data following enterprise data standards
- Responsible for supporting the design/construction using data modeling concepts and implementation phases of a system and/or upgrade project
- Responsible for creating ad hoc queries or reports to extract data from disparate databases or data sources and analyzes data to produce dashboards, metrics, or insights and identify trends or anomalies
- Responsible for interprets data, analyzes results using statistical techniques and provides ongoing reports
- Responsible to acquires data from primary or secondary data sources and maintains databases/data systems
- Involve in SIT/UAT testing and identifying data quality issues
- Monitor the production reporting environment on daily and monthly basis
- Find and correct operational errors, determine how to design system enhancements and test programs and systems
- Keep up to date on current technology through training and outside materials
- Data Analytics to analyze data and make business decisions based on the data
- Perform other duties as assigned
- Conform with all company policies and procedures
REPORTING RELATIONSHIP
ABS Reporting Systems Manager
Qualifications
Knowledge
- Advanced working knowledge of developing Oracle PL SQL
- Advanced working knowledge of ETL/Data warehousing Concepts
- Advantage working knowledge on design, testing and implementation on Oracle/Cognos objects
- Advanced working knowledge of Oracle accounting software
- Working knowledge on Data mining/analysis, Data governance and data architecture and reporting
- Knowledge on enterprise IT infrastructure
Skills
- Ability to establish priorities and meet tight deadlines
- Advanced oral and written communication skills
- Ability to interact collaboratively with internal customers
- Capable of managing multiple and varied projects, including ability to coordinate and balance numerous tasks in a time-sensitive environment, under pressure, meeting deadlines
- Demonstrated quantitative skills and data Analytical skills
- Proven ability to quickly learn new applications, processes, and procedures
Education
- Bachelor's Degree in Information Systems, Computer Science, Finance, Business, related field or equivalent work experience required
Experience
- 5-7 years Oracle PL-SQL/SQL required
- 3-5 years Informatica or ETL tool required
- 2-3 years Cognos or any BI reporting tool preferred
- 0-2 years UNIX shell scripting preferred
#LI-Hybrid
#LI-CR1