Pentaho Specialist

  • Powersolv,
  • Washington, DC
Pentaho, SQL, ETL
Contract Corp-To-Corp, Contract Independent, Contract W2, 6 Months
Depends on Experience
Work from home not available Travel not required

Job Description

Title:                 Senior BI Analyst

Location:          Washington, DC

Duration:         6 to 12 Months

 

FYI: In-person interview is must. This is 100% onsite position and background check will be conducted before on-boarding.


Essential Duties


The position’s essential duties include the following:

  • Serve as technical team lead in the development of business intelligence reports and analysis, providing mentoring, guidance and troubleshooting to analysis team members in solving complex reporting and analytical problems
  • Perform Data Analysis and Data validation by writing SQL queries
  • Create Data Mapping documents, data dictionaries and Interface Control Documents (ICDs)
  • Serves as technical team member in the development of business intelligence reports and analysis, providing mentoring, guidance and troubleshooting to analysis team members in solving complex reporting and analytical problems
  • Devises ER diagrams and identifies unique foreign keys, entities, attributes, relationships and business rules for data warehouse
  • Create Data Mapping documents, data dictionaries and Interface Control Documents (ICDs)
  • Manage reporting environment including report data sources, security, subscriptions and metadata
  • Assist in initiative towards data normalization and data integrity across the enterprise
  • Assist Data Warehouse Engineer in identifying and revising enterprise reporting requirements
  • Evaluate, test and implement new or upgraded software
  • Troubleshoot reported problems pertaining to reports and the reporting database environment, working closely with other IT members, especially DBAs, Systems Analysts and Systems Engineers, identifying the cause and designing or developing an approach for resolution
  • Assess impact of changes and updates to source production systems, planning and implementing resulting changes to reports
  • Conduct end user training on reporting system

Skills that the consultant should have:

  • Pentaho, Tableau, Crystal Reports, Data Insight
  • SQL Server, Vertica
  • ETL developer with Data Warehouse implementation experience
  • Dimensional Model (Erwin, ER Studio)
  • SQL Server Analysis Services, Reporting Services and Integration Services                
  • Business intelligence technologies and solutions                                                                 
  • Data Profiling                                       
  • Data warehouse concepts (Kimball, Inmon, star schema, snowflake schemas, and normalized and de-normalized data models)

Education/Training

  • Masters Degree in Business, Information Technology and training in Databases
  • 5-7 years of experience

Posted By

Amit Singh

1801 Robert Fulton Drive, Suite 550 Reston, VA, 20191

Dice Id : 10115336
Position Id : 5884453
Have a Job? Post it