Technical Analyst BI ETL (BHJOB22048_675)

Analyst, Business Intelligence, Oracle, SQL, Cognos, Engineers, Systems, Application
Contract W2, Contract Corp-To-Corp, C2H Corp-To-Corp, C2H Independent, C2H W2, Contract Independent

Job Description

Technical Analyst - Business Intelligence

  • Technical Analyst for migration of 100+ BI Report and Dashboards mapping from legacy data sources (Oracle) over to new data sources (SQL Server) - Navigate changes in schema, taxonomy, and data.
  • Work Products: logical data models, data flow diagrams, schemas, data definition documents.
  • Business Intelligence technical analyst for buildout of enterprise BI Dashboarding and Reporting structures, cubes and marts, with drill down and self-service capability for enterprise finance and accounting.
  • Ensure all legacy BI Report functionality is mapped over and is functional on the new platform. Plus add in any new functionality required.
  • Gathers, validates and documents business requirements for business intelligence implementation projects; determines functionality and data required to meet requirements and articulates integration required for the existing business intelligence (BI) environment.
  • Facilitate requirements session workshops to elicit use cases, stories, priorities, and card sorting.
  • Understand business processes, use cases, frequency, priorities, and business impacts of BI solutions.
  • Translates BI requirements into logical data models, data flow diagrams, schemas, data definition documents.
  • Queries data and assists in data profiling activities.
  • Pull data samples from sources with SQL, TOAD, SQL queries and performs data profiling, logical modeling.
  • Data sampling, data profiling, data wrangling, aggregation, and blending data sets for BI drill down capability.
  • Analyzes data (complex joins, pivots, aggregation, blending, normalization) into data models for cubes/marts to support BI Dashboards with drill down and self-service capabilities.
  • Facilitates BI functionality sessions with Business SME's, BI Developers (Cognos, Tableau, SSRS), and DW/ETL Engineers.
  • Liaison between the Business Intelligence tech teams and the internal clients.
  • Ensures BI Engineers understand the data needs and models to support business BI use cases and stories.
  • Help embed data quality and master data management into business processes, BI solutions, and data sets.
  • Develop BI end user UAT test strategy and test plans. Leads business clients in end-user testing efforts for both major business intelligence releases and minor enhancement releases.
  • Coordinates and conducts all BI training using the business intelligence front-end report/query products.
  • Assists in mentoring other technical staff members in business processes and workflows.


  • 3-5 years Technical Analyst, Systems Analyst - generating logical data models, data flow diagrams, data definition documents.
  • 3-5 years Business Intelligence tools, technologies, concepts - Dashboards, Reports, Cubes, Marts, models.
  • Experience Data sampling, data profiling, data wrangling, and blending data sets for BI drill down capability.
  • Advanced Business Intelligence requirements identification and documentation experience. JAD/Req Sessions.
  • BI data documentation experience: logical data models, data flow diagrams, data definition documents, etc.
  • Hands on experience with BI tools, such as report writers and cube technology
  • Intermediate skills with SQL, Toad or other query tools.
  • Intermediate skills in Joint Application Design (JAD) facilitation or other requirements gathering techniques.
  • Basic understanding of ETL, BI, Cognos, and Tableau dashboards
  • Experience developing and conducting BI platform training
  • Ability to communicate technical concepts to non-technical audiences
  • Preferred: knowledge of financial industry, investing, banking and lending terminology.


  • Local Denver resources only.
  • Remote only during Pandemic. Then on site only. No remote. Need to be local.
  • W2 only NO sub vendors.
  • NO sponsorship available.
Dice Id : 10483216
Position Id : BHJOB22048_675
Originally Posted : 2 months ago
Have a Job? Post it

Similar Positions

Business Intelligence Analyst II
  • SNI Technology
  • Cherry Hills Village, CO
Sr. MS BI Developer
  • Robert Half
  • Denver, CO
SQL Data Analyst / ETL Developer
  • Unison Systems, Inc
  • Englewood, CO
BI/Data Analyst
  • Apex Systems
  • Greenwood Village, CO
Web & Data Designer
  • Istonish
  • Golden, CO
Qlik Sense Developer-Contract to Hire
  • The Doyle Group
  • Westminster, CO
SSIS Developer
  • Sempera
  • Denver, CO
BI Alteryx Consultant; Part-Time
  • Kelly IT
  • Denver, CO
Business Intelligence Developer
  • Jobot
  • Englewood, CO
ETL Developer
  • Edgelink
  • Westminster, CO