Advanced Technology Services, Inc. Power Business Intelligence Developer in Peoria, Illinois

Title: Power Business Intelligence Developer

Location: US-IL-Peoria

Other Locations: US-IL-Schaumburg

Job Number: CJ012318


Designs, modifies, writes, and implements software programming applications. This includes configuring, coding, developing, and documenting software specifications throughout the project life cycles. Relies on instructions and pre-established guidelines to perform the functions of the job.

Principal Duties/Responsibilities:

  • Gather and analyze business requirements and translate business needs into long-term business intelligence solutions leveraging the Microsoft technology platform (SSIS, SSAS, and Power BI)

  • Provide technical assistance to the team on various MS BI stack technologies

  • Tailor solutions for Management dashboards, Financial Reporting and Operational Business Intelligence

  • Develop ETL packages, Cube Model and support the existing database components

  • Identify and troubleshoot business process and or data quality issues on new or existing reports.

  • Develop SQL queries and support ad-hoc requests /reports

  • Configure and optimize BI environment

  • Develop and manage BI presentation layer training, and documentation

  • Collaborate with application developers, business owners, and operation engineers to ensure the creation of production Business Intelligence designs and implementations

  • Troubleshoot BI Environment problems and tune for performance. Diagnose and resolve application bottlenecks and performance issues. Define and enforce coding standards, design styles and best practices


Knowledge, Skills, Abilities, & Behaviors Required:

  • Bachelor's Degree in related field or 5years of experience architecting, developing and/or managing Business Intelligence solutions using Microsoft SQL Server, Microsoft SharePoint and Microsoft Excel utilizing experience with Microsoft Business Intelligence tools.

  • SSIS (SQL Server Integration Services)

  • SSAS (SQL Server Analysis Services)

  • Extensive T-SQL/query knowledge

  • MDX (Multidimensional expressions) or DAX (Data Analysis expressions)

Not-required but desired skills/technology:

  • SSRS (SQL Server Reporting Services)

  • Programming/development experience

  • Data mining experience

  • Experience with Power BI, Power View, DAX & SSAS Tabular

Job: Information Technology