Skip to main content

This job has expired

Senior Business Intelligence Developer

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

View more

Job Details

The Chicago Public Schools (CPS) has set ambitious goals to ensure that every childin every school and every neighborhoodhas access to a world-class learning experience from birth, resulting in graduation from high school college- and career-ready.

Information Technology Services is seeking a Senior Business Intelligence Developer 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

Get job alerts

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

Create alert