Interview: Phone then video
READ THE NOTES:
LOCAL CANDDIDATES ONLY SINCE CANDIDATES WILL NEED TO DO ONBOARDING ONSITE IN RICHMOND (LAPTOP, BADGE, ETC.) AND THEN WILL WORK REMOTE UNTIL OFFICE REOPENS
WEBCAM ITNERVIEWS
COVID-19 REMOTE THEN ONSITE AT CLIENTS DIRECTION
MANAGER REQUEST COMPLETE ANSWERS TO THE FOLLOWING:
- Does your candidate's experience match or exceed the skills listed above and the number of years of experience with each skill?
- Does your candidate CURRENTLY reside in Richmond?
- Does your candidate agree to complete the entire engagement?
- Although Web IVs will be conducted the expectation is for the candidate to be on site once offices re-open. Does your commit to working on site once requested?
- Has your candidate been submitted to CAI in the past by your company or any other vendor? If so, for which agency and when?
- Does your candidate have at least 5 years of experience with BI Publishing?
- If selected, can your candidate pick up their equipment in person due to COV ID regulations (no exceptions).
NOTES FROM MANAGER:
We are looking for a Report Developer with a mix of skills. OBIEE and BIP are required, preferably with experience in not just report development, but some OBIEE admin skills as well.
We are transitioning to a MSBI stack, so PowerBI, SSRS and Sql server skills are important as well.
IDEAL CANDIDATE: Right now we are an Oracle shop, order of preference for this role are
BIP, OBIEE then PowerBi, SSRS and SQLServer.
Candidates must complete skills matrix below:
Skill
Required / Desired
Amount of Requested Experience
Candidate's Actual Experience
Last Used
Oracle BI Publisher / OBIEE (Oracle BI)
Required
5 Years
Experience with XML/XPath/XSD concepts
Required
2 Years
Experience creating RTF/PDF templates for BI Publisher Reports
Required
2 Years
Advanced SQL (PL/SQL preferred) scripting & query knowledge
Required
5 Years
BI Publisher Security model and configuration
Highly desired
2 Years
Performance tuning SQL and PL/SQL
Highly desired
2 Years
Experience with Oracle BI Dashboards & Analysis
Highly desired
2 Years
Experience using Oracle SQL Developer or Toad
Highly desired
2 Years
Experience with other mainstream reporting tools such as SAP Crystal and Business Objects
Highly desired
2 Years
Advanced experience working with relational database systems and writing complex views, queries, and procedures
Required
5 Years
Working knowledge of data warehouses, ETL, and data models (star schema, dimensional)
Highly desired
2 Years
Experience with an ETL platform such as Oracle Data Integrator, Informatica, or SSIS
Nice to have
2 Years
Working knowledge Microsoft PowerBI (pls note this is not the main tool they are looking for)
Desired
2 Years
Position Description
The BI Report developer will be responsible for the analysis, design, and delivery of reports for various business lines and use cases across the organization as part of the Enterprise BI & Reporting strategy.
Qualifications:
- 2+ years of experience with Oracle BI Publisher / OBIEE (preferable 12c)
- XML/XPath/XSD Concepts
- Skilled with creating RTF/PDF Templates for BI Publisher Reports
- 2+ years BI Publisher & OBIEE Catalog Maintenance
- Understanding of Oracle BI & BI Publisher security models and implementation
- BI Publisher Administration Concepts
- BI Publisher Security
- BI Publisher Migration to new Versions
- Experience with Export/Import Catalog Objects in OBIEE
- Experience writing complex SQL views and/or procedures
- Preferred experience with Oracle BI (OBIEE) Dashboards
- Working knowledge of ETL & Data Warehousing, Oracle BI repository preferred
- Experience with tools such as Oracle SQL Developer & Toad
- Worrking knowledge of Microsft BI Stack (SSRS/SSAS Tabular/PowerBI/SQLServer) Microsoft PowerBI.
Long term this environment is moving their reporting to a MS platform for BI so exposure to MS Power BI is key.
Communication:
- Assist in working with business and technical teams to gather report and data integration related
- requirements from business users to create functional and technical requirements documents.
- Communicate with business users and project managers at regular project status meetings.
- Translate business requirements and source system understanding into technical design.
- Ensure Project deliverables are delivered on time.
- Communicate effectively both verbally and in writing
Required Skills:
- 5 years’ experience with Oracle BI Publisher / OBIEE (Oracle BI)
- 2 years’ experience with XML/XPath/XSD concepts
- 2 years’ experience creating RTF/PDF templates for BI Publisher Reports
- 5 years advanced experience with SQL (PL/SQL preferred) scripting & query knowledge
- 5 years advanced experience working with relational database systems and writing complex views, queries, and procedures
Desired Skills:
- 2 years’ experience with BI Publisher Security model and configuration
- 2 years’ experience with Performance tuning SQL and PL/SQL
- 2 years’ experience with Oracle BI Dashboards & Analysis
- 2 years’ experience using Oracle SQL Developer or Toad
- 2 years’ experience with other mainstream reporting tools such as SAP Crystal and Business Objects
- 2 years’ experience with working knowledge of data warehouses, ETL, and data models (star schema, dimensional)
- 2 years’ experience with an ETL platform such as Oracle Data Integrator, Informatica, or SSIS
- 2 years’ experience with working knowledge Microsoft PowerBI (pls note this is not the main tool they are looking for)