Sorry, this listing is no longer accepting applications. Don’t worry, we have more awesome opportunities and internships for you.

2021 Data Analyst Internship

Austin Capital Bank

2021 Data Analyst Internship

Austin, TX
Paid
  • Responsibilities

    Job Description

    COMPANY OVERVIEW

    Austin Capital Bank (ACB) is a rapidly growing technology company with a community bank charter. Located in Austin, Texas, we are one of the best performing banks in the country and a nationwide leader in consumer-friendly, responsible financial innovation. We’re well on our way to building a $1 billion tech company with revenues approaching $50 million and a CAGR of almost 100%. ACB has made the INC 5000 fastest-growing private companies in America list for the last 5 years in a row. 

    As a pioneer in fintech and banking, we have our own technology platform, bank charter, are profitable, and are self-funded so we control our own destiny. We are a 5-star rated independent community bank and member of the FDIC. We also have a product pipeline that would make even the most well-funded fintech Unicorn blush with envy, including B2C, B2B, BAAS, and embedded finance.

    OUR CULTURE

    We combine the stability of a profitable bank with the creativity and energy of a fintech startup. We have a casual demeanor yet execute with professional precision. You’ll enjoy a family friendly, culture of customer-oriented and responsible innovation. We expect you to have the innovation, creativity, and drive for growth of a rapidly scaling technology company, with a work-life balance of a normal human.

    OUR CORE VALUES

    We are nice folks, but unapologetically fierce competitors in the marketplace who work as a team. Every member of our team embodies our core values. We work, hire, fire, and promote by these values.

    • Take Initiative – A bias to action
    • No Big Egos – Self-confidence with humility
    • Honesty – Direct forthright communication
    • Wicked Smart – Intellectually and emotionally self-aware

    If your favorite pronouns are “I” and “me”, you won’t be a great fit. If you get inspired by wanting your next career milestone to read: “Senior Architect on a TEAM that grew revenue from $50 million to $500 million in 5 years.”, we’d like to chat with you.

    Please visit https://www.creditstrong.com/ and https://www.austincapitalbank.com/ for more information. 

    ABOUT YOU

    • You embody our core values and have exceptional initiative to create and enhance world class technology solutions.
    • You have acute attention to detail. You love and understand data, analysis, and optimization.
    • You have a fire in your belly. You love to win and hate to lose.

    ROLE DESCRIPTION 

    We are transforming our business to ensure that technology provides a competitive advantage in every product or service that we offer.  From the integration of AI and machine learning across our product base to leveraging infinitely scalable cloud-based operating models, we will use technology to drive deeper insights, enhance productivity, and offer best-in-class service capabilities for our customers and partners.

    ROLE RESPONSIBILITIES

    • Work with team members to understand their data needs
    • Code SQL reports to provide business insights and drive strategy
    • Build data visualizations and “heartbeat monitors” for the business
    • Anything else the team is working on. There’s plenty of work to go around!

    REQUIRED QUALIFICATIONS

    • Willingness to work in person in the office
    • Proficient in SQL, any kind
    • Willingness to learn
    • Ability to pivot to new challenges in a fast-paced environment

    PREFERRED QUALIFICATIONS

    • Knowledge in financial services, loans, or credit score reporting
    • Experience in writing business reports
    • Experience with data visualization software (Tableau, Spotfire, PowerBI)
    • Knowledge of the software development life cycle and Agile practices

    COMPENSATION

    $18.00 per hour 

    PLEASE SUBMIT YOUR ANSWER TO THIS QUICK SQL QUIZ ALONG WITH YOUR COVER LETTER IN ORDER TO BE CONSIDERED FOR THIS OPPORTUNITY. 

    QUICK SQL QUIZ There is a customer table and a transaction table. Excerpts of these tables are shown below.  Given these two tables, write a SQL query that: a) Lists each customer from Texas and all transactions they have, e.g. if Crystal has two transactions, there are two rows in the results. b) Lists each customer and the total dollar amount of their transactions Any “flavor” of SQL is fine.

    Please input your answers into the Cover Letter form.

     

     

     

    Powered by JazzHR

    TBmE8aAy7P