Previous Job
SQL/SSAS Data Engineer
Ref No.: 18-05200
Location: Chicago, Illinois
Position Type:Direct Placement
Pay Rate : $ 80,000.00 - 115,000.00 /Year
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.

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

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