Description

You will design and maintain data warehouse structures and reporting systems using the Microsoft BI stack.

Responsibilities

• Develop and maintain data extraction methods between SQL, source databases, and the data warehouse.
• Implement and uphold performance standards for all data extraction processes.
• Establish standards for reporting and dashboard structures.
• Assist end users with the creation and development of reports and dashboards using SSRS, SSAS, and SSIS.
• Analyze and resolve complex technical issues across multiple project tasks.

Required Skills

• 5+ years of experience in SQL, ETL, and BI tools.
• Proficiency in Microsoft SQL Server, including extensive hands-on experience with SQL Server 2008.
• Expertise in SSRS, SSAS, and SSIS.
• Strong command of SQL, coding technologies, and stored procedures.
• Experience with data modeling, data normalization, and database integration techniques.
• Experience using TFS for secure code storage.
• Bachelor's degree in Computer Science Technology or equivalent.
• Proven ability in the design and development of front-end SSRS reporting applications.

Preferred Skills

• Experience with SharePoint, PowerPivot, or PowerView.

Key Skills

Education

Bachelor's degree