Business Intelligence / Business Objects Professional - Military veterans preferred

Description

Business Intelligence Developer / Data analyst / Data designer

Responsible for the design and development of SAP Business Intelligence (BI/BO 4.0+) data universes and reports leveraging data from multiple sources in support of project management decision-making.  Maintain an in-depth knowledge of business practices and complex data sets.  Utilize database and technical knowledge to analyze and solve problems, and create ad-hoc reports.

5. Person must be able to obtain a Public Trust security clearance
5. No travel is required for this position
5. This position is not a telework position and is in Lakewood, CO

 

Duties may include:

5. Responsible for design and maintenance of business intelligence entities, currently SAP Universes and Web Intelligence Reports
5. Leverage business knowledge of data and data relationships in 6+ major database schemas to design data relationships, and analyze and resolve issues
5. Maintain ongoing comprehensive understanding of organizational business operations, information flow and reporting needs
5. Design custom Oracle database data views, scripts, procedures, SAP report objects
5. Meet with end-users to capture new business requirements for translation into custom universe and report elements
5. Work with database administrators, web developers, and network administrators to ensure access to reports and up-to-date data
5. Troubleshoot data issues using analysis and design of SQL queries utilizing filtering, sorting, grouping, bracketing, comparing, counting, ranking and other methods
5. Develop validation plans to ensure accuracy of data
5. Provide guidance for future BI development
5. Serve on various work teams to provide guidance on data and reporting plans
5. Team lead for Labor Cost Distribution Processing, database side, over four federal lands divisions – merging Delphi accounting system General Ledger (GL) payments with division project labor hours to create project accounting invoices in Delphi system 
5. Perform other development tasks as requested eg. Crystal Reports, Dashboards, Adobe LiveCycle Designer Forms, and conversion of raw survey results into reports and metrics
5. Develop and support Oracle Forms and Reports used for administration of leadership team objectives, including Federal employee tracking, employee training, skill and discipline inventories as well as organization and individual information
5. Set user rights, roles and other system settings on server consoles

5. Design BI data universe combining all sets of project management data: fund allocation, internal budgeting and approvals, financial actuals and project controls system data
5. Develop Web Intelligence reports relaying a full representation of project measures across data sets
5. Design additional BI data universes and reports to support additional databases and applications as well as several employee information data sets
5. Primary resource for analyzing and troubleshooting data issues on all databases

5. Provide training on applications and meet with users to observe user’s experience and practices

 

 

 

Essential  Proficiencies, Certifications and/or Requirements

5. Strong working knowledge of SQL and PL*SQL
5. Strong analytical and communication skills
5. Create data tables, views, stored procedures, scripts
5. Create complex data models and relationships
5. Develop strong engineering processes and business knowledge
5. Strong team contributor, working with other developers and clients
5. Work on servers to set up users, roles, other configurations

Qualifications

DOT Public Trust Clearance
Must have a minimum of 6 years of related experience as a database administrator, specializing in supporting Oracle and SQL environment.  
 

Target salary range: $75,001 - $85,000. The estimate displayed represents the typical salary range for this position based on experience and other factors.