Data Warehouse BI Analyst

etl, database, sql, sql server, ssis, ssrs, powerBI
C2H W2, 3 month CTH
$45/hr W2
Work from home not available Travel not required

Job Description

**All resumes will remain strictly confidential.  US Citizens and those authorized to work in the US are encouraged to apply.  We are unable to sponsor visa's at this time. Candidates must be LOCAL to the Pacific Northwest and available for onsite interviews

JOB OVERVIEW:

The Analyst, Data Warehouse & Business Intelligence performs analysis, design and development of data Loading, warehousing and reporting solutions using Microsoft SQL Server and related technologies. This position supports data marts and implementation of supporting business intelligence and analytics capabilities. This position will be a part of a team which is responsible for end to end development of data projects from analysis and design to testing and delivery, as well as data quality and cleanup efforts.

  • Assist in analysis, design, development and implementation of data warehouse and data mart structures.
  • Assist in identifying and mitigating data quality issues.
  • Assist in coordinating data cleanup efforts with end users
  • Manage and prioritize work efforts for data projects.
  • Communicate with work teams and senior management.
  • Analyze, design and development processes to load various systems such as data warehouses and data marts to assure accuracy.
  • Develop extracts and reports to satisfy the needs of business customers.
  • Document source system database structure and usage.
  • Interview end users and document operational structure and workflow.
  • Interview end users, managers, and analysts to document current reporting needs and procedures and identify future needs and trends.
  • Perform data modeling and de-normalization of existing databases.
  • Maintain data mart platform design and performance.

TECHNICAL REQUIREMENTS:

  • Bachelor's degree with an emphasis in Computer Science, Data Science, Telecommunications, or Information Technology preferred. Equivalent education, experience, and training may be substituted year over year for the degree requirement plus four (4) years of progressive information technology experience. Higher level education may be substituted for the experience requirement on a two years' experience for one year education basis.
  • Technical analysis and Requirements gathering.
  • Data warehouse and analytics analysis and design.
  • SQL Server Integration Services (SSIS).
  • SQL Server Reporting Services (SSRS) for report generation.
  • Power BI.
  • Data modeling and database design.
  • SQL Server best practices.

Posted By

Jeff Morris

12520 SW 68th Ave, Suite B Tigard, OR, 97223

Contact
Dice Id : TRIADTOR
Position Id : 999
Have a Job? Post it