find jobs
what:
where:
 
job title, keywords or company
city, state or zip code
Business Intelligence Developer more...
Location:Chicago, IL
Company:Chicago Transit Authority (CTA)
First posted:June 09, 2017
x

Description

Job Title Business Intelligence Developer

Location Chicago, IL, US

Job Type Full - Time Permanent

Department

Data Analytics

Position Summary

SALARY TARGET IS TBD. Final salary will be determined in part by the qualifications of the selected candidate and may be higher or lower than target.

Under general supervision, serves as a key technical resource in the planning and execution of data applications, data models, and database structural design and development. Serves as key resource in the design, evaluation,implementation, and support of new data analytics, architectural solutions, and reviews and evaluates database performance for necessary enhancements.

Primary duties and Responsibilities

Designs and develops data applications and architecture to support various analytic and Business Intelligence (BI) needs of the Authority.

  • Coordinates with the team in establishing an enterprise data analytics platform.

  • Creates prototypes of new data analytics technologies.
  • Helps implement and maintain new technology solutions.

Develops and documents analytic technology processes and best practices, including metadata, master data, data lineage, and data quality.

Identifies and implements data standards and improvements.

  • Creates and executes data quality test cases, tracks results, and analyzes results for improvement recommendations.

  • Develops and maintains management reports on the analyses and recommendations of data quality test cases.
  • Liaises with internal and external partners to enhance data access and related processes.

Works with internal departments to develop optimal technical requirements for data-intensive projects and ensures that initiatives are conducted in alignment with established best practices.
Monitors and supports data analytics processes, including Extract, Transform, Load (ETL) and data warehousing troubleshooting.

Performs related duties as assigned.

Qualifications

EDUCATION/EXPERIENCE REQUIREMENTS

  • Bachelor's degree in Computer Science, Statistics, Engineering, Information Technology, Economics, Business or a related field, plus three (3) years of experience in business intelligence, business architecture, information architecture and strategy, and/or enterprise design, or an equivalent combination of education and experience.

PHYSICAL REQUIREMENTS

  • Requires sitting for extended periods of time, standing, visual acumen, manual dexterity, and fingering for working with computer key boards.

KNOWLEDGE, SKILLS, AND ABILITIES

  • Detailed knowledge of relational data architecture, data lifecycles, ETL, structured query languages (SQL), and related methodologies.

  • Detailed knowledge and experience with platforms such as PostgreSQL, SQL Server, and Oracle preferred.
  • Working knowledge of the practices and methods of data warehousing, metadata management, data modeling, data quality, and other data management disciplines.
  • Working knowledge of cloud-based data infrastructure such as AWS preferred.
  • Working knowledge of common programming languages (Python, R, Java, PHP, etc.).
  • Working knowledge of non-relational (unstructured) data technologies and techniques.
  • Working knowledge of version control software and methodologies.
  • Strong Microsoft Excel and other standard office productivity application skills.
  • Strong analytical, problem-solving, decision-making, and teamwork skills.
  • Strong oral and written communication skills.
  • Strong organization and time management skills.
  • Strong interpersonal skills.
  • Ability to effectively diagnose and resolve complex problems pertaining to data infrastructure.
  • Ability to translate complex technical terminology, concepts, and issues in terms understandable to technical and non-technical management and resources staff.

Location and City

Chicago, IL

Applicants, if hired, must comply with CTA's residency ordinance.

CTA IS AN EQUAL OPPORTUNITY EMPLOYER

IT IS THE POLICY OF THE CHICAGO TRANSIT AUTHORITY THAT NO EMPLOYEE OR APPLICANT FOR EMPLOYMENT WILL BE DISCRIMINATED AGAINST BECAUSE OF RACE, COLOR, CREED, RELIGION, SEX, MARITAL STATUS, NATIONAL ORIGIN, SEXUAL ORIENTATION, ANCESTRY, AGE, UNFAVORABLE MILITARY DISCHARGE OR DISABILITY. CTA WILL MAKE REASONABLE ACCOMMODATIONS FOR THE KNOWN DISABILITIES OF OTHERWISE QUALIFIED APPLICANTS FOR EMPLOYMENT AS WELL AS ITS EMPLOYEES, UNLESS UNDUE HARDSHIP WOULD RESULT. IF YOU REQUIRE AN ACCOMMODATION IN THE APPLICATION OR HIRING PROCESS, PLEASE CONTACT (see application details) PRIOR TO THE SUBMISSION OF YOUR APPLICATION OR UPON NOTIFICATION OF YOUR ACTUAL TEST DATE. CTA WILL WORK WITH YOU TO DETERMINE IF AN ACCOMMODATION CAN BE PROVIDED.

Currency USD

Amount of Travel No Travel

Work At Home No

Send this job to yourself or a friend.


Please mention BusinessJobs.org
if asked how you found this job.
»