Jobs
>
Chicago

    Business Intelligence Developer - Chicago, United States - Chicago Transit Authority

    Default job background
    Technology / Internet
    Description

    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.





  • Chicago Transit Authority Chicago, United States

    SALARY · $80,000 - $100,000 · POSITION SUMMARY · 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, implem ...


  • Chicago Transit Authority Chicago, United States

    Business Intelligence Developer W ) · **Description** · **SALARY** · $80,000 - $100,000 · **POSITION SUMMARY** · Under general supervision, serves as a key technical resource in the planning and execution of data applications, data models, and database structural design and ...


  • Chicago Transit Authority Chicago, United States

    Business Intelligence Developer W ) · **Description** · **SALARY** · $80,000 - $100,000 · **POSITION SUMMARY** · Under general supervision, serves as a key technical resource in the planning and execution of data applications, data models, and database structural design and devel ...


  • Chicago Transit Authority Chicago, United States OTHER

    · SALARY · $80,000 - $100,000 · POSITION SUMMARY · 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, imp ...


  • The University of Chicago Chicago, United States

    This job was posted by : For more information, please see: Department · F&A ITS - BIS Architecture · About the Department · ITS collaborates with campus partners to support the mission of the University of Chicago through the consistent delivery of high-quality solutions and se ...


  • CCC Information Services Chicago, United States Part time

    About CCC · CCC Intelligent Solutions is a leading technology company helping to improve the insurance claims process for millions of people. Our award-winning SaaS platform connects more than 30,000 businesses, including insurance carriers, repair facilities, automakers, part s ...


  • Secure Community Network Chicago, United States

    We are **Secure Community Network (SCN),** **a nonprofit 501(c)(3) serving as the official safety and security organization of the Jewish community in North America. Here at SCN, we deeply value the team of people who work diligently to commit their lives to action for a better t ...


  • Green Thumb Chicago, United States

    **The Role**: · **Responsibilities**: · - Collaborate with key decision makers and business stakeholders to understand their reporting and analytics needs · - Manage the daily operations of the Business Intelligence team and foster a high performance and personal growth culture · ...


  • Sidley Austin LLP Chicago, United States

    Summary: · The Business Intelligence System Analyst (BI System Analyst) is responsible for facilitating the financial information and reporting needs of the Firm. This person will act as a day-to-day analyst responsible for organizing data points, developing ad hoc reporting and ...

  • Prescient

    Associate Director

    1 week ago


    Prescient Chicago, United States

    **TITLE**: Associate Director (Deep & Dark Web Intelligence)-Cyber · **PRACTICE AREA**: Cyber-(Deep & Dark Web Intelligence) · **LOCATION**:All Offices · **REPORTS TO**: Director / Managing Director · **FLSA**:Exempt · **WHY PRESCIENT?** · Prescient is a global risk management an ...


  • Pando Chicago, United States

    **Job Information**: · Industry · **Software Product*** · City · **Chicago*** · State/Province · **Illinois*** · Country · **United States*** · Zip/Postal Code · **60607*** · **Sales Development Representative (Chicago, USA)** · - Pando is a global leader in supply chain technolo ...


  • Konica Minolta Business Solutions, U.S.A., Inc. Chicago, United States

    Overview: · Konica Minolta currently has an exciting opportunity for a sales professional with a hunting mentality to join us as a **Director, Industrial Print Business Development **This position utilizes outstanding interpersonal, communication, time management, organizational ...


  • Google Chicago, United States

    **Minimum qualifications**: · - Bachelor's degree or equivalent practical experience.- 6 years of experience in customer-facing and driving customer development programs. · - Experience managing customer organizational structures, developing technology programs, defining mileston ...

  • HirexHire

    Data Analyst

    2 days ago


    HirexHire Chicago, United States

    ABOUT US · HirexHire (pronounced hire by hire) is a Chicago-based recruiting and talent consultancy that integrates with companies short-term to provide long-term talent solutions. We take a seat in our client's everyday operations to understand their people's goals, gaps, and ch ...

  • Verve

    Associate Director

    3 days ago


    Verve Chicago, United States

    **Quantitative Research Associate Director** · Location: Chicago, North America · **Salary**: Industry Leading · **Verve is hiring** · Verve is "The Artificial Intelligence, Human and Cultural understanding business". · We're undergoing a business transformation as AI is designed ...

  • Allstate

    Threat Hunting Lead

    6 days ago


    Allstate Chicago, United States

    The world isn't standing still, and neither is Allstate. We're moving quickly, looking across our businesses and brands and taking bold steps to better serve customers' evolving needs. That's why now is an exciting time to join our team. You'll have opportunities to take risks, c ...


  • Envestnet Chicago, United States

    **Description** · Envestnet is seeking a passionate and talented **Consulting Services Specialist** to join our Portfolio Management Consultants (PMC) team. This position is expected to report to either our Berwyn, PA, Denver CO, or Chicago, IL office. · Envestnet is transforming ...


  • Fanisko Chicago, United States

    **Job Type**: · Contract · **Experience**: · 4 to 8 years · **Location**: · Remote · The Servicenow SecOps & SIR(Security Incident Response, Vulnerability · Response) developer would need to have at least 5+ years of experience · with more than 2 year of experience in Security In ...


  • Kirkland and Ellis Chicago, United States

    **About Kirkland & Ellis** · At Kirkland & Ellis, we are united in our ambition and drive to move forward. We share core values that help us achieve excellence: collaboration, talent empowerment, service, inclusion, respect and gratitude. Our people are our greatest asset, and we ...

  • Vanator

    SQL Developer

    4 days ago


    Vanator Chicago, United States

    Advanced SQL programming skills. · - Experience with Teradata or other database systems · - Experience in database design/development, database administration, and business intelligence · - Experience in data analysis and analytical reporting · - Proficiency with advanced Excel f ...