PRIMARY 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 cloud 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.

MANAGEMENT RESPONSIBILITIES

Reporting to this position may include the following jobs:

Job Title

None

CHALLENGES

• Designing an extensible technology platform to satisfy current and future needs.
• Balancing multiple high-priority requests simultaneously while meeting project deadlines successfully.
• Conceiving technical solutions that are both creative and empathetic.
• Delivering clarity and ease-of-use while providing tools with power and flexibility.
• Adapting to rapidly-changing demands, constraints, and/or ambiguity.
• Maintaining knowledge of emerging analytic platforms and technologies.

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.
• Experience with data processing frameworks such as Hadoop or Spark preferred.

PHYSICAL REQUIREMENTS

• Requires sitting for extended periods of time, standing, visual acumen, manual dexterity, and fingering for working with computer key boards.
• 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 relational data architecture, data lifecycles, ETL, structured query languages (SQL), and related methodologies.
• 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.
• Detailed knowledge of a cloud-based infrastructure such as AWS preferred.
• 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 business intelligence and visualization tools, such as Power BI, Tableau, Qlik, etc.
• 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.

WORKING CONDITIONS

• General office environment.
• Required to travel to field locations throughout the CTA system and Chicago area as needed.
• Subject to existing weather conditions when visiting field
• Subject to normal garage hazards such as noise, machinery, dust, grease, moving vehicles, etc. when visiting field locations.

EQUIPMENT, TOOLS, AND MATERIALS UTILIZED

• Standard office equipment.
• Data analytics and development applications.

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 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.
During the hiring process, CTA's Human Resources department will contact candidates with next steps . Failure to respond to these correspondences in a timely fashion may result in your application being closed out for non-responsiveness.
Please click link below to review the benefits offered at the CTA.