Job Description
ABC BI Report Developer
VENDOR MAXIMUM SUBMITTAL RATE $$$.$$/hr.
*local candidates strongly preferred
*ALL candidates MUST be able to attend a personal interview, NO phone interviews, NO Skype, NO exceptions
*Please do NOT submit candidates who were submitted to the previous reqs ABC BI reqs. We need NEW candidates ONLY.
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
• 5+ years of Oracle database & SQL/PLSQL knowledge
• 2+ years Performance Tuning of Oracle SQL/PLSQL
• 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 SAP BOE / Crystal Reports
• 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
• Working knowledge Microsoft PowerBI. Long term view: ABC is moving some of our reporting to PowerBI, and long term will be slowly migrating 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/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 Required2Years
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.Question3In what city/state does the candidate reside? Question4Does your candidate's experience match or exceed the skills listed above and the number of years of experience with each skill? Question5Is candidate willing and able to travel to Richmond, VA for a personal interview? Manager will ONLY conduct in person interviews, NO Skype, NO exception Question6Does your candidate agree to complete the entire engagement? Question7How soon after an offer can your candidate start? Question8Has your candidate been submitted to CAI in the past by your company or any other vendor? If so, for which agency and when? Question9Was this candidate submitted to any previous ABC BI reqs? We NEED NEW candidates ONLY.Question10Does your candidate have working knowledge Microsoft PowerBI? If so please highlight this experience in the body of the resume (not just in summary)
Job Tags
Local area