The Data and Reporting Engineer collaborates with Database Engineers to maintain database objects, develop reports, troubleshoot data issues, and support projects.
The Oracle Forms Data and Reporting Engineer is an integral part of the Technical Services & Support team. The DRE will work with the Database Engineers to maintain database objects including tables, functions, stored procedures, views, triggers and packages. In addition, the DRE will assist with developing and maintaining custom client reports. The DRE will assist with Professional Services projects and handle Tier 2 support tickets from internal Ren teams. They will be trained on Ren systems, platforms, database needs and internal processes in the onboarding process.
Duties & Responsibilities:
- Review, document, analyze, troubleshoot and resolve customer’s data related issues.
- Advanced PL/SQL queries, scripts, stored procedures, materialized views, and views
- Design, develop and maintain reports using Crystal reports and other tools.
- Respond to requests within expected SLA timeframes.
- Work closely with the software engineering teams to close data related defects in the software.
- Developing new strategies and building internal processes that help make your support team's work easier.
- Creating documentation and materials to help educate both your customers and fellow team members on data related aspects of the product.
- Follow best practices and guidance around troubleshooting procedures and corresponding runbooks.
- Provide knowledge base and help artifacts that increase customer self-service options.
Education & Experience:
- Bachelor’s degree in software development, computer science, business intelligence, data management, or other related fields
- 3-5 years experience with SQL procedures and advanced queries, specifically Oracle PL/SQL
- Strong communication skills
- Financial Services experience preferred
- Experience with business intelligence tools, specifically Metabase and Crystal Reports
- Experience with Oracle Forms
- Cloud data warehouse experience, Snowflake is preferred
Ren is an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status or any other characteristic protected by law.
Top Skills
Crystal Reports
Metabase
Oracle Forms
Pl/Sql
Snowflake
Similar Jobs
Artificial Intelligence • Fintech • Payments • Financial Services • Generative AI
As a Senior AI Engineer, you will develop AI-driven solutions, design architecture for applications, and collaborate with teams to enhance growth and efficiency at Airwallex.
Top Skills:
Python
Artificial Intelligence • Fintech • Payments • Financial Services • Generative AI
As an AI Engineer, you will develop AI-driven solutions, design system architecture, and collaborate on projects to redefine customer support and automation.
Top Skills:
Python
Artificial Intelligence • Fintech • Payments • Financial Services • Generative AI
Manage onboarding and customer activation processes for enterprise clients, ensuring a great customer experience and resolving technical issues in collaboration with internal teams.
Top Skills:
Google LookerGoogle SuiteSalesforce CRMSequelZendesk
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
