Business Intelligence Developer

Job Locations US-CO-Lakewood
ID
2021-2073
Category
Information Technology
Type
Regular Full-Time

Overview

We are seeking a Business Intelligence Developer to join our team supporting DOT EITSS  in Lakewood, CO.

 

TekSynap is a fast growing high-tech company that understands both the pace of technology today and the need to have a comprehensive well planned information management environment. “Technology moving at the speed of thought” embodies these principles – the need to nimbly utilize the best that information technology offers to meet the business needs of our Federal Government customers.

 

We offer our full-time employees a competitive benefits package to include health, dental, vision, 401K, life insurance, short-term and long-term disability plans, vacation time and holidays.

Visit us at www.TekSynap.com

Apply now to explore jobs with us!  

Responsibilities & Qualifications

RESPONSIBILITIES

  • 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.

  • Responsible for design and maintenance of business intelligence entities, currently SAP Universes and Web Intelligence Reports

  • Leverage business knowledge of data and data relationships in 6+ major database schemas to design data relationships, and analyze and resolve issues
  • Maintain ongoing comprehensive understanding of organizational business operations, information flow and reporting needs
  • Design custom Oracle database data views, scripts, procedures, SAP report objects
  • Meet with end-users to capture new business requirements for translation into custom universe and report elements
  • Work with database administrators, web developers, and network administrators to ensure access to reports and up-to-date data
  • Troubleshoot data issues using analysis and design of SQL queries utilizing filtering, sorting, grouping, bracketing, comparing, counting, ranking and other methods
  • Develop validation plans to ensure accuracy of data
  • Provide guidance for future BI development
  • Serve on various work teams to provide guidance on data and reporting plans
  • 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 
  • Perform other development tasks as requested eg. Crystal Reports, Dashboards, Adobe LiveCycle Designer Forms, and conversion of raw survey results into reports and metrics
  • 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
  • Set user rights, roles and other system settings on server consoles
  • Design BI data universe combining all sets of project management data: fund allocation, internal budgeting and approvals, financial actuals and project controls system data
  • Develop Web Intelligence reports relaying a full representation of project measures across data sets
  • Design additional BI data universes and reports to support the IBM’s Maximo Inventory Management system as well as several employee information data sets
  • Redeveloped all reports and supporting data views and queries in anticipation of older PARS reporting system sunset plan
  • Primary resource for analyzing and troubleshooting data issues on all databases
  • Served on Fundsmap future planning team, Labor Cost Distribution team for converting to new labor accounting method, Delphi new release testing team, PARS conversion team and others
  • Create and process test labor cost invoice batches for Delphi system upgrade releases
  • Provide training on applications and meet with users to observe user’s experience and practices

REQUIRED QUALIFICATIONS

  • Must have a minimum of 6 years of experience as a Database Administrator
  • Strong analytical and communication skills
  • Create data tables, views, stored procedures, scripts
  • Create complex data models and relationships
  • Develop strong engineering processes and business knowledge
  • Strong team contributor, working with other developers and clients
  • Work on servers to set up users, roles, other configurations
  • DBA with strong PL / SQL writing skills and experience in Business Intelligence (preferably SAP BI / BO 4.0+).
  • Active or must be able to obtain Public Trust

  • Must be a U.S Citizen or Green Card Holder

  •  

    Must successfully pass a drug screening

Additional Job Information

COMPETENCIES

  • Establish Focus
  • Change Management
  • Develop Others
  • Oral Communication
  • Written Communication
  • Interpersonal Awareness
  • Build Relationships
  • Analytical Thinking
  • Conceptual Thinking
  • Strategic Thinking
  • Technical Expertise
  • Initiative
  • Foster Innovation
  • Results Oriented
  • Teamwork
  • Customer Service

WORK ENVIRONMENT AND PHYSICAL DEMANDS

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of the job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

  • Location: Lakewood, CO
  • Type of environment: Office
  • Noise level: Low
  • Work schedule: Schedule is day shift Monday – Friday. May be requested to work evenings and weekends to meet program and contract needs.
  • Amount of Travel: Less than 10%

The anticipated salary range for this position is $63,899 - $74,500.  The final range is not a guarantee, actual salary will be set based on experience, geographic location, contract requirements.  Please note offered salary or compensation could fall outside this range.

 

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to use hands to handle, feel, touch; reach with hands and arms; talk and hear. The employee is regularly required to stand; walk; sit; climb or balance; and stoop, kneel, crouch, or crawl. The employee is regularly required to lift up to 10 pounds. The employee is frequently required to lift up to 25 pounds; and up to 50 pounds. The vision requirements include close vision, distance vision, peripheral vision, depth perception, and ability to adjust focus.

 

WORK AUTHORIZATION/SECURITY CLEARANCE

Must be a U.S Citizen or Green Card Holder

Must successfully pass a drug screening

Active or must be able to obtain Public Trust

 

OTHER DUTIES

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.

 

EQUAL EMPLOYMENT OPPORTUNITY

In order to provide equal employment and advancement opportunities to all individuals, employment decisions will be based on merit, qualifications, and abilities. TekSynap does not discriminate against any person because of race, color, creed, religion, sex, national origin, disability, age, genetic information or any other characteristic protected by law (referred to as “protected status”). This nondiscrimination policy extends to all terms, conditions, and privileges of employment as well as the use of all company facilities, participation in all company-sponsored activities, and all employment actions such as promotions, compensation, benefits, and termination of employment.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed