Skip to main content

This job has expired

Senior Business Intelligence Analyst

Employer
Chicago Public Schools - CPS
Location
Chicago, IL, US
Salary
Competitive

View more

Job Category
Administrator, Finance / Business / CFO, Product, Services & Policy, Data / Analysis
Send job

Job Details

Information Technology Services is seeking a Senior Business Intelligence Analyst to join the team to develop ETL to support continued build out of the CPS Enterprise Data Warehouse and Dashboard.

This individual will be responsible for:

  • Maintain and manage the existing CPS Enterprise Data Warehouse and ODS builds.
  • Builds ETL components according to ETL specifications. Code must address performance, dependency, auditing, error handling and data quality issues.
  • Support post deployment by debugging, fixing, and participating in maintenance.
  • Create reports to meet business requirements and address data needs.
  • Create Dashboard pages and metrics within CPS custom dashboard solution.
  • Responsible for data integrity as well as the quality of data within Dashboard presentation layer.
  • Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural specifications; identify/troubleshoot code-related issues; and review and provide feedback to the final user documentation.
  • Read and understand business requirements, write functional requirements, develop detailed technical designs, and build / unit / system test ETL code.


Technical Skills

  • 3+ years of Enterprise Data Warehouse experience
  • 5+ years of experience with an ETL product (SSIS, Ab Initio, etc) in a development role (administrative knowledge a plus)
  • Good knowledge of data modeling/Star Schema
  • Strong ANSI SQL expertise preferred
  • 3+ years of experience with Unix and Shell Scripting
  • Experience with SQL Server 2012
  • Ability to develop and organize high-quality documentation
  • Experience with at least one job scheduler


Personal Skills

  • Strong written and oral communications skills.
  • Proven ability and initiative to learn and research new concepts, ideas, and technologies quickly.
  • Strong systems/process orientation with demonstrated analytical thinking, organization skills and problem solving skills.
  • Ability to work in a team-oriented, collaborative environment.
  • Ability to quickly pick up new tools and technologies.
  • Willingness and ability to train and teach others.
  • Ability to facilitate meetings and follow up with resulting action items.
  • Ability to prioritize and execute tasks in a high-pressure environment.
  • Strong presentation and interpersonal skills.
  • Ability to effectively move forward on tasks even with ambiguous or changing requirements


Additional Notes :

  • CPS employees are required to be actual residents of the City of Chicago within six months of beginning employment, and are required to maintain Chicago residency throughout employment.
  • Chicago Public Schools is not currently hiring individuals for this position who now or in the future require sponsorship for employment based non-immigrant and immigrant visas.
  • Chicago Public Schools is an EEO/AA Employer. All qualified individuals, including minorities, females, veterans, and individuals with disabilities, are encouraged to apply.

Company

Chicago Public Schools is truly a district on the rise. The last five years have been an unprecedented success for CPS, and during that time, our district has emerged as a beacon of what is achievable for large urban school districts across the country. Our mission is to provide a high-quality public education for every child, in every neighborhood, that prepares each for success in college, career, and civic life.

Company info
Telephone
773-553-1000
Location
42 W Madison St
 Chicago
IL
60602
US
Send job

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert