Jobs
>
Chicago

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

    Default job background
    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 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 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.


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


  • CCC Intelligent Solutions Chicago, United States

    Pay Rate/Hourly Range: · The hourly range is $ $43.00 per hour. · Pay is based on factors including school year, program of study, role responsibilities, etc. · CCC Intelligent Solutions is a leading technology company helping to improve the insurance claims process for millio ...


  • CCC Intelligent Solutions Chicago, United States

    The hourly rate is: · $33.00 per hour · 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 35,000 businesses, including insurance carriers, repair f ...


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


  • McDonald's Chicago, United States

    McDonald's is proud to be one of the most recognized brands in the world, with restaurants in over 100 countries that serve 70 million customers daily. We continue to operate from a position of strength. Our updated growth strategy is focused on staying ahead of what our customer ...


  • Wipfli Chicago, United States

    At Wipfli, people count · The way you think makes you different. At Wipfli, we embrace that. · Our inclusive culture provides a space for everyone to have a voice. Our growing number of DEI resource groups celebrate diversity and champion awareness throughout Wipfli. · We're al ...


  • Starcom Chicago, United States Full time

    Job Description · About Our Insights Center Of Excellence · Our newly formed Insights Center of Excellence is the fuel for designing meaningful connections with people and brands in culturally relevant ways. We combine creativity and data to uncover differentiating insights th ...


  • Lawson Products Chicago, United States

    Since 1952, Lawson Products has worked hard to make our customers' jobs easier by improving their operational efficiency, productivity and overall performance. As a leader in the MRO industry, we partner with customers to make sure they have the right maintenance and repair parts ...


  • Green Thumb Chicago, United States full

    The Role · Green Thumb Industries is seeking an experienced manager to join our Business Intelligence team, focusing on evolving our use of data to deliver improved insights across the company. The candidate will collaborate closely with stakeholders across our Finance, Retail, ...


  • Annalect Chicago, United States

    About Annalect · Annalect is the Data & Technology arm of Omnicom Media Group · Annalect's 2,000+ innovators leverage data and technology to help clients across Omnicom build relationships that matter — whether that means fostering consumers' trust in brands, building new experie ...


  • Brooksource Chicago, United States Contract-to-Hire

    Apply Now · << Business Intelligence Analyst/Developer · Contract to Hire · 100% Remote · We are searching for a Business Intelligence (BI) Analyst to join the Data and Analytics team. You will use a combination of business and analytics knowledge to provide executive leadership ...


  • Amentum Chicago, United States Full time

    Amentum is a government services provider of strategic solutions to the defense, homeland security, and the Intelligence Community. Amentum provides intelligence analysis and security, training and education, and intelligence support strategy and policy support, intelligence and ...


  • UpToDate, Inc. Chicago, United States Full time

    Wolters Kluwer Health's Clinical Effectiveness (CE) organization is a fast-growing and innovation-driven healthcare information technology (HIT) provider working on the front lines of clinical care. Our talented team of physician and pharmacist editors, technologists, and product ...


  • The Kraft Heinz Company Chicago, United States Full time

    Description · : As the BI & Reporting lead, you will be responsible for overseeing the design, development, and implementation of our SC business intelligence and reporting solutions. You will collaborate with cross-functional teams to gather requirements, analyze data, and deli ...


  • CCC Intelligent Solutions Chicago, United States Part time

    Pay Rate/Hourly Range: · The hourly range is $ $43.00 per hour. · Pay is based on factors including school year, program of study, role responsibilities, etc. · CCC Intelligent Solutions is a leading technology company helping to improve the insurance claims process for million ...

  • Bank of America

    Senior Threat Hunter

    4 weeks ago


    Bank of America Chicago, United States Full time

    Description · : Our Cyber Threat Hunting, Intelligence & Defense team within Bank of America's Cyber Security Defense function works to continuously strengthen the bank's cyber security posture through research, threat simulations, threat hunting, and offensive security engageme ...

  • CCC Intelligent Solutions

    Data Science Intern

    2 days ago


    CCC Intelligent Solutions Chicago, United States Part time

    Pay Rate/Hourly Range: · The hourly range is $ $43.00 per hour. · Pay is based on factors including school year, program of study, role responsibilities, etc. · CCC Intelligent Solutions is a leading technology company helping to improve the insurance claims process for million ...


  • VMock Chicago, United States

    Do you have a passion for forging connections and shaping the future of college students' careers? Look no further We're on the lookout for dynamic individuals to join us as a Business Development Associate, the heartbeat of our Sales team. · Who We Are: VMock aims to empower st ...


  • CCC Information Services Chicago, United States Full 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 ...


  • Ipsos Chicago, United States

    What makes this role important at Ipsos? · As a Senior Director on the Synthesio team, you will be joining a passionate and entrepreneurial group of social and digital experts dedicated to delivering impactful business solutions to the world's biggest brands. You will partner wi ...