Job Details

Email to Friend Save Back

SQL/SSAS Data Engineer

CHICAGO-60290, IL, US
08/27/2018

-

Required Skills

web applications

Company

Infinity Consulting Solutions, Inc

Experience

4 to 7 Year(s)

Job Description

SQL DATA ENGINEER

Seeking an experienced SQL Data Engineer to join an established and growing organization downtown.

The SQL Data Engineer will be integral in providing companywide strategic, analytical and technical support for BI activities.

You will work in a fast-paced, team environment collaborating directly with all business units.

The ideal SQL Data Engineer will be hands-on, results orientated role and must have expertise in the Microsoft toolset for data and data analytics, including SQL Server, data models in SSAS, and Power BI dashboard creation.

Responsibilities

Collaborate with business leaders to analyze critical data and translate business requirements into technical, scalable specifications

Cultivating data models

Design, develop, test, and document new reports and dashboards.

Mentor others in using analytics tools

Evaluate and enhance existing reports and dashboards

Define and document business requirements for new metrics and reports

Ensure accuracy and integrity of data and reporting applications through detailed analysis, efficient coding, writing clear documentation processes, identifying and resolving problems as they arise

Review and write complex SQL queries and develop stored procedures and functions in SQL

Perform ongoing monitoring and refinement of reports and BI solutions

Provides ongoing performance monitoring and tuning, and automation of production activities related the BI environment

Works in conjunction with analysts and other users acting as a liaison between technical and business departments in developing dashboards and other BI related solutions.

Ability to work effectively within competing deadlines with minimal guidance

Interact professionally and collaborate with a diverse group including executives, managers, and subject matter experts

Qualifications

4+ years of professional experience as a developer using SQL Server, SSRS, SSAS, Azure, and SSIS

Experience building/optimizing cubes with SQL queries, and experience with Analysis Services (SSAS) and Reporting Services (SSRS) including database development, deployment, configuration, security and troubleshooting.

Strong knowledge of relational and multi-dimensional database architecture

Experience creating and maintaining documentation following standard creation and change control processes

Analysis Services/OLAP experience required

Strong data warehouse and physical data modeling skills.

Experience with DAX and/or MDX is a plus.

Experience integrating Power BI or Power Pivot into web applications

Proficient oral and written communication skills

Ability to lead a meeting and present to small audiences