Business Intelligence Developer

Job description

Job location: Chicago, IL

Employment Type: Full-time
Posted data: 2019-08-05
Req: R0003823
Job Description:

The Business Intelligence Developer works closely with the business to develop and document business intelligence solutions for reporting and analysis.  The role is responsible for creating reports using Workday, Tableau, SSRS, and Power BI.  They will support the other report writers who use these technologies in various departments across the organization.  They will provide information by collecting, analyzing, and summarizing data from a variety of data sources. They will need to be familiar with key business applications and processes to assist in identifying key metrics. 

Responsibilities included but not limited to:

  • Design & develop standardized reports using SQL Server Reporting Services, TSQL queries, and Stored Procedures for all departments
  •     Data Quality management
  •     Create and Deploy SSIS Packages for ETL and ELT processes
  •     Create tables, stored procedures, functions, views, and triggers using SQL Server Management Studio
  •     Query Performance Tuning & Optimization 
  •     Maintain and support existing Data Warehouses/Marts
  •     Create ad hoc reports and queries from key applications
  •     Implement high level dashboards for senior staff
  •     Analyze data to improve processes and assist with defining key metrics
  •     Follow industry data standards, resolve data issues, complete unit testing, and documentation for ETL processes

Position Requirements:

  •     Collaborate with business analysts, subject experts, and other team members to determine BI requirements and develop enterprise level solutions
  •     Support IT staff and business users in the development, usage and troubleshooting of database-driven applications
  •     Respond quickly to bug fixes and enhancement requests
  •     Work on multiple projects concurrently

Position Qualifications:

  •     BA/BS in related field
  •     3-5 years experience with SSIS package development and SSRS report writing
  •     Knowledge of data warehouse design patterns 
  •     Advanced knowledge of SQL BI Tools (SSRS, SSIS, SSAS)
  •     Data warehouse/ Data Mart development experience
  •     Excellent analytical, written and verbal communication skills
  •     Experience with tableau reports development & administration
  •     Python or R experience is a plus 
  •     Knowledge of extracting data through API/web services a plus
  •     Experience in education industry a plus


TCS Education System offers a generous compensation and benefits package, as well as the opportunity to work for a leader in the field of education. Some of our key benefits include: generous paid time-off, medical and dental coverage, company-paid life and disability insurance, retirement plan with employer contribution, multiple flexible spending accounts (FSA), tuition reimbursement, professional development, and regular employee appreciation events.

TCS Education System is an Equal Opportunity Employer.




Diversity Profile: University



View more

Learn more on Inside Higher Ed's College Page for University

Arrow pointing right
Job No:
Posted: 8/6/2019
Application Due: 11/4/2019
Work Type: