ETL/Oracle Developer - Data Analytics & Finance (ABS)
Company: GM Financial
Location: Fort Worth
Posted on: March 18, 2023
|
|
Job Description:
Analyst III - ABS Data Analytics & Reporting, Finance 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.
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
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
Working knowledge on Azure services such as GIT preferred
Experience with translating business requirements into system
functional and non-functional requirements
Knowledge of big data concepts and cloud technologies preferred
Knowledge of data virtualization concepts
Knowledge of GM Financial's core business functions
Working knowledge of the consumer loan business
Working knowledge of all system applications
Working knowledge of the corporate business solution
environment
Significant experience in a large and complex business
environment
Knowledge on enterprise IT infrastructure
Skills
Ability to establish priorities and meet tight deadlines
Solid design, coding, testing and debugging skills
Excellent problem-solving skill
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
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
Automotive Lending or Financial Services industry experience
preferred
Experience delivering BI and Data Warehouse solutions with both
Dimensional and Relational modeling preferred
#LI-Hybrid
#LI-CR1
Requisition ID: 2023-44262
External Company URL: www.gmfinancial.com
Street: 801 Cherry Street
Hybrid (Combo of work from home and in-assigned office location):
Yes
Keywords: GM Financial, Fort Worth , ETL/Oracle Developer - Data Analytics & Finance (ABS), IT / Software / Systems , Fort Worth, Texas
Click
here to apply!
|