CHICAGO TRANSIT AUTHORITY

Programmer Analyst, Data Analytics - (2300009P)

POSITION SUMMARY

• Under direction, develops, implements, and maintains technology processes for the Authority’s Data Analytics department.
• Aids in the research and conceptualization of new programming and automation initiatives for the agency.
• Coordinates with team and IT department to ensure technical processes reflect department and organizational priorities.
• Performs business and data analysis to deliver data and analytics capabilities to the organization.

PRIMARY RESPONSIBILITIES

• Performs hands-on coding and configuration work with an ever-evolving 
  technology toolset.
• Works with Data Analytics group to identify methods that allow for 
  maintenance, enhancement, and automation of existing capabilities.
• Conducts thorough problem analysis of department technical systems 
  and application programs. Documents findings and proposes problem 
  resolution alternatives.
• Builds front-end web interfaces for sharing and visualizing analytic 
  output.
• Reviews all programs prior to implementation to verify consistency and 
  conformance with established departmental guidelines, policies and 
  practices as well as industry standards and guidelines.
• Maintains current working knowledge of all application systems and 
  technologies.
• Serves as technical project liaison with various departments on behalf of the 
  Data Analytics department.
• Provides technical expertise and serves as subject matter expert on Data Analytics project needs and goals.
• Assists in the creation and automation of Data Analytics’ capabilities to 
  support project efforts.
• Provides assistance to Data Analytics group members on data 
  sourcing, transformation, and modeling activities
• Performs related duties as assigned.

MANAGEMENT RESPONSIBILITIES
Reporting to this position are the following jobs:

Job Title

None

CHALLENGES

• Understanding the complex information needs throughout the business and 
  determining the correct technical solutions to address those needs.
• Being a self-directed technologist with no organizational peers doing exactly the same 
  job.
• Communicating technical challenges or constraints to persons less knowledgeable in 
  the area.

EDUCATION/EXPERIENCE REQUIREMENTS

• Bachelor’s degree in Computer Science, Economics, Business, Statistics, Mathematics, Operations Research, Industrial Engineering, Quantitative Analysis, or a related field, plus three (3) years of hands-on technical development experience and/or programming and systems design, or an equivalent combination of education and experience relating to this position.

PHYSICAL REQUIREMENTS

• Requires sitting for extended periods of time, standing, visual acumen, manual dexterity, and fingering for working with computer keyboards.
• When making visits in the field, subject to noise, machinery, and garage environment exposure.
• Chicago Transit Authority requires all employees to be COVID-19 vaccinated.  If you are offered employment, you must provide proof of full COVID-19 vaccination or proof that you are in the process of becoming fully vaccinated as part of the hiring process and as a condition of employment. Visit www.transitchicago.com/careers
• Service Area Requirement: Exempt (Non-Union) employees must live within the boundaries of the CTA Statutory Service Area either at the time of employment or within 6 months of beginning employment at CTA.

KNOWLEDGE, SKILLS, AND ABILITIES

• Detailed knowledge of systems development concepts, lifecycles, and methodologies.
• Detailed knowledge of data management/SQL concepts, lifecycles, and methodologies
• Detailed knowledge of relevant programming languages, such as Python, Java, PHP, HTML, Javascript, CSS PL/SQL, R, Ruby, C#, C++, etc.
• Detailed knowledge of relational database design.
• Detailed knowledge of a range of RDBMS query languages, including PostgreSQL, Oracle, SQL Server, etc.
• Working knowledge of machine learning processes and common algorithms.
• Working knowledge of physical, logical, and conceptual data model design.
• Working knowledge of structured programming principles.
• Working knowledge of the methods and practices in system implementation, industry standard testing, database administration, and user training.
• Working knowledge of a Business Intelligence technical stack preferred.
• Working knowledge of Amazon Web Services database infrastructure preferred.
• Strong analytical, problem-solving, and decision-making skills.
• Good verbal and written communication skills.
• Good organization skills and attention to detail.
• Good time management skills.
• Ability to manage multiple deadlines with competing priorities.
• Ability to work effectively with various departments at all levels of the organization.

WORKING CONDITIONS

• General office environment.
• Required to travel to locations throughout the CTA system and Chicago area as needed.

EQUIPMENT, TOOLS, AND MATERIALS UTILIZED

• Standard office equipment.
• Personal computer and related data analytics applications and software.

Additional Details 

Please note, employees and/or union members will be given priority consideration in the hiring process, per the applicable labor contracts.

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

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

CTA IS AN EQUAL OPPORTUNITY EMPLOYER
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, disability or any other status protected by federal, state, or local laws; except where a bona fide occupational qualification exists We are committed to providing an inclusive environment for our workforce and supporting the communities we serve. 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 arc@transitchicago.com 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.