Job DescriptionABC BI Publisher/ Report Developer. Replacing a contractor who left recently.
Richmond candidates preferred (read all info below before submitting)
ALL candidates MUST be able to attend a web based interview. Local candidates may start working remotely HOWEVER they will be expected to work on site once offices safely reopen.
Important to note: If offered the role, equipment MUST be picked up in person (COV ID credentials require initial log in to be done locally). Therefore someone who is out of the state cannot be considered and equipment cannot be shipped).
Duration: assignment end date in Vector is based on fiscal yr end for POs. Assignment is expected to exceed June 30 end date.
UPDATED INFO from mgr:
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.
The latter skills will gradually become more prominent but we do require candiadtes to be proficient in supporting our existing environment.
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.
2+ years of experience with Oracle BI Publisher / OBIEE (preferable 12c)
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 view: ABC is moving our reporting to a MS platform for BI so exposure to MS Power BI is key.
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/Desired Skills SkillRequired /DesiredAmountof ExperienceOracle BI Publisher / OBIEE (Oracle BI)Required5YearsExperience with XML/XPath/XSD conceptsRequired2YearsExperience creating RTF/PDF templates for BI Publisher ReportsRequired2YearsAdvanced SQL (PL/SQL preferred) scripting & query knowledgeRequired5YearsBI Publisher Security model and configurationHighly desired2YearsPerformance tuning SQL and PL/SQLHighly desired2YearsExperience with Oracle BI Dashboards & AnalysisHighly desired2YearsExperience using Oracle SQL Developer or ToadHighly desired2YearsExperience with other mainstream reporting tools such as SAP Crystal and Business ObjectsHighly desired2YearsAdvanced experience working with relational database systems and writing complex views, queries, and proceduresRequired5YearsWorking knowledge of data warehouses, ETL, and data models (star schema, dimensional)Highly desired2YearsExperience with an ETL platform such as Oracle Data Integrator, Informatica, or SSISNice to have2YearsWorking knowledge Microsoft PowerBI (pls note this is not the main tool they are looking for)Desired2Years Questions No.QuestionQuestion1Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?Question2Please list candidate's email address that will be used when submitting E-RTR.Question3Does your candidate's experience match or exceed the skills listed above and the number of years of experience with each skill?Question4Does your candidate CURRENTLY reside in Richmond?Question5Does your candidate agree to complete the entire engagement?Question6Although 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?Question7Has your candidate been submitted to CAI in the past by your company or any other vendor? If so, for which agency and when?Question8Does your candidate have atleast 5 years of experience with BI Publishing?Question9If selected, can your candidate pick up their equipment in person due to COV ID regulations (no exceptions).