Senior Business Intelligence Developer
- Employer
- Chicago Public Schools - CPS
- Location
- Chicago, IL, US
- Salary
- Competitive
View more
- Job Category
- Administrator, Finance / Business / CFO
You need to sign in or create an account to save a job.
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:
Technical Skills
Personal Skills
Additional Notes :
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
You need to sign in or create an account to save a job.
Get job alerts
Create a job alert and receive personalized job recommendations straight to your inbox.
Create alert