Consulting - Senior Associate - Business Intelligence

RSM

Job Title: Consulting - Senior Associate - Business Intelligence
Description:

We are looking for a business intelligence professional with strong background in data integration (ETL) design and development, data modeling and business and data analysis. This individual will work closely with the Business Intelligence team to:

  • Design and develop data integration routines to integrated data from disparate source systems into an integrated business intelligence environment including defining source-to-target mappings, business rules and other required data transformations
  • Design and develop dimensional data models in support of stated requirements
  • Conduct business analysis to define the required data to fulfill on business requirements
  • Conduct detail data analysis is support of data related projects

Basic Qualifications

  • Significant experience (3-5 years) in the Microsoft business intelligence platform, including SQL Server databases, SQL Server Integration Services and SQL Server utilities (preferable with SQL Server 2012/2014)
  • Experience with SQL Server Data Quality Services (DQS) and Master Data Services (MDS)
  • Significant experience in the architecture, design and development of data integration solutions
  • Significant experience in data analysis and data quality analysis
  • Experience in creating dimensional data models across multiple subject areas
  • Significant experience in optimization of data integration processing and database design
  • Experience in defining and managing ETL metadata repositories
  • Significant experience in automating data integration routines

Additionally, the following is considered optional:

  • Experience in formal data quality assessments
  • Experience in designing and developing reporting, analytics and data visualization solutions (preference with QlikView/QlikSense, Power BI or Tableau
Location Street Address: 1861 International Drive, Suite 400
City: McLean
State: Virginia
Region: Southeast Region
Position Type: Full Time
Job Type: Experienced
Degree Required: Bachelor
Travel Required: Yes
Relocation Eligible:
Sponsor candidates who are not
eligible to work in US:
No
Read Full DescriptionHide Full Description
Confirmed 10 days ago. Posted 30+ days ago.

Discover Similar Jobs

Suggested Articles

One Step Register
Need an account? Sign Up