SALARY

$90,000 - $100,000

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.
• 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.