Oracle Developer

Oracle Developer

Vacancy expired!

Our large Public Accounting client is seeking a Senior Oracle Developer to assist in analyzing business problems to determine the best way to apply Oracle OBIEE & BI capabilities to deliver solutions. This techno-functional consultant maintains and grows working knowledge of enterprise data assets and data-centric business processes within the finance organization. The Reporting Developer is responsible for data analysis, coding, testing, and deployment of report solutions to support various business stakeholders.

We are unable to offer visa sponsorship for this position.

Role description:

• 7+ years relevant experience.
• Evaluate business requests for new or modified capabilities to determine feasibility, cost and time required, compatibility with current systems, and computer capabilities.
• Analyze business requirements into technical requirements for reporting/visualizations, data models, and databases.
• Review technical specifications derived from technical requirements.
• Create and review/approve technical design documents and specifications on change requests and assignments within a project while maintaining documentation and abstracts in conformance with standards.
• Develop reporting for business consumption using a variety of BI tools.
• Provide detailed source analysis and data mappings/transformations to BI developers to implement new data sources and integrations.
• Configure BI systems to deliver BI solutions.
• Devise and deliver testing plans and testing data to validate BI solutions.
• Coordinate user testing for acceptance of BI solutions.
• Deploy and Validate BI solutions ensuring changes follow appropriate Change and Release Management processes.
• Assist development teams with analysis and design for new or existing systems.
• Provide consultancy to business units for detailed information on data availability, location, lineage, and quality.
• Perform data analysis, profiling, and quality assessment to ensure the integrity of business data to necessary levels
• Assist with complex incident management situations affecting BI capabilities and solutions.
• Review design proposals of other BI Analysts and vendors; as well as perform reviews on work during various stages of delivery for adherence to current standards.
• Work with technical leads and architects to implement new standards, new technology, and tactical solutions driving the business strategy forward.
• Works within the System Development Life Cycle.
  

Job duties:

• Create and refine data models.
• Develop new reports and dashboards in PowerBi, OBIEE and Tableau based upon defined request and requirements from stakeholders and maintain a catalog of reports' use and purpose.
• Maintain queue of report requests from initiation through to completion, including their detailed requirements
• Participate in business analysis activities to maintain reports and develop enhancements as needed.
• Enforce rules and procedures for cleaning, integrating, and reconciling information/data from various sources.
• Assist end users with report troubleshooting.
• Work with stakeholders to define and understand their data/reporting needs.
• Develop report standards and best practices or guidelines for repeatable processes.
• Develop testing plan along with performing tests to delivery high quality solutions.
• Analyze report / data issues and provide recommended approaches to solve.
• Accountability for meeting commitments as scheduled and achieving high customer satisfaction.
• Keep other team members and management fully informed of progress, emerging issues, corrective actions, and escalating appropriately as the situation demands

Required skills:

• Finance (Revenue, FP&A, C&C, Tax & Sale Compensation) knowledge
• Familiarity with BI, Big Data, and Data Warehousing concepts.
• Oracle OBIEE
• Experience developing reports or query writing with PL/SQL and/or Microsoft SQL/MySQL Server (preferred)
• Expertise with OBIEE and PowerBI dashboard and visualization using Finance data.
• Prior experience with Oracle BI tools, such as OBIEE, BICS, OAC, BI Publisher - Preferred.
• Prior experience with Tableau or Power BI. (Certified)
• Excellent communication skills both verbal and written.
• Demonstrated interpersonal skills and ability to work with all levels of the organization.
  

#pcit
#LI-REMOTE