Business Intelligence Analyst

Community Tax, LLC

Job Description

Community Tax is a nationally leading tax resolution firm, based in Chicago and rapidly increasing  our national presence.  We are highly data driven and provide an environment for the Business Intelligence Analyst to grow.

This job is responsible for supporting and managing a program of business initiatives designed to help drive value from information. You’ll contribute to enterprise success by ensuring business needs and goals are realized through analysis and reporting activities of the Data Analytics / Business Intelligence Group. In this role, you’re responsible for supporting stakeholders and senior management with concise, high-quality information, helping them leverage it to identify and address business opportunities and threats, enabling data-driven decision-making, identifying new revenue growth opportunities, and executing on strategic initiatives. Your day-to-day will involve dashboarding, A/B analysis, owning data reporting pipelines, and working cross-functionally, providing consultation on the interpretation of data to various business partners throughout the organization.


  • Actively and consistently support all efforts to simplify and enhance the customer experience
  • Provide advice and education in the usage and interpretation of business data relevant to the business unit
  • Build dashboards to monitor product performance and ensure success on a technical and business level
  • Be the business Intelligence SME and be the bridge between Product/Service Delivery, Data Science, Operations, Marketing and Sales
  • Own and maintain the reporting data pipeline for specific business units and custom dashboards
  • Perform continuous A/B Testing Analysis for Product/Service teams
  • Communicate data nuances and insights to all levels of the company in a clear and concise manner
  • Assists users at all levels within the company on how to leverage BI capabilities for accurate reporting and analysis
  • Leverage knowledge of Business Intelligence capabilities and familiarity with business trends in identifying patterns, opportunities and threats
  • Work closely with business partners in gathering detailed business requirements, establishing business definitions, translating to technical requirements for development team and gaining approval
  • Create report mock ups based on requirements and coordinates with technical team in finalizing design and receiving sign off
  • Support all scheduled and non-recurring information needs of the business users
  • Understand data elements in the warehouse at a very detailed grain to support any form of user needs from research to ad-hoc querying to managing large information projects
  • Query large datasets and tables to provide information requested by business users
  • Present data in a fashion that is easy to understand with proper documentation for successful user adoption
  • Work with cross functional teams to ensure alignment in business needs, timelines and department standards
  • Create test plans and scenarios and conducts testing to ensure quality and requirements traceability to final deliverable
  • Assist in identifying solutions to enhance the existing Business Intelligence infrastructure processes and technology
  • Maintain metadata dictionaries and report definitions
  • Understand and evaluates cross functional and system to system impacts of requirements and change requests
  • Use intermediate Excel skills to capture and communicate data findings
  • Liaison among the business, development and support teams to ensure solutions being developed meet or exceed business needs.


  • BA or BS Degree in Business Administration, Finance or business related field with strong underpinnings in Computer Science, Data Analytics or similar area.
  • Advanced Degree in a relevant field is a plus


  • Ability to read, write, speak and understand English
  • Exceptionally strong communication skills both written and verbal
  • Prior experience and passion for leveraging data to drive business impact
  • Statistical knowledge and intuition ideally utilized in A/B or multivariate testing (or related analytics)
  • A passion for data, analysis, and problem solving
  • Proficiency with Power BI
  • Experience dashboarding with BI Tools (ie. Tableau, Looker, Data Studio)
  • Excellent communication and interpersonal skills with different stakeholders
  • Self-starter who can operate independently and drive work to completion in a timely fashion
  • Skilled with SQL (required) and Excel (required)
  • Ability to speak to large groups with good presentation skills
  • Ability to perform critical thinking in the area of data analysis with intermediate analytical skills
  • Strong team and relationship building skills
  • High attention to detail and quality
  • Ability to prioritize and organize effectively and manage multiple projects/assignments
  • Ability to perform in a fast-paced environment
  • Ability to understand complex business processes, rules and gain business acumen
  • Familiarity with data visualization standards and techniques to visually summarize data and insights
  • Familiarity with BI Data Modeling concepts such as Star/Snowflake Schema, Dimensions and Facts
  • Knowledge of Python, PySpark, R is a plus
  • Previous experience communicating technical concepts to various audiences
  • Familiarity with ETL practices and tools (AirFlow, Pyspark)


Experience in related B2C and B2B markets in a financial professional services delivery market place is preferred, but not required.

Job Requirements