Business Reporting Analyst

Baker Tilly Virchow Krause, LLP Madison , WI 53706

Posted 4 months ago


Baker Tilly Virchow Krause, LLP (Baker Tilly) is a nationally recognized, full-service accounting and advisory firm whose specialized professionals connect with clients and their businesses through refreshing candor and clear industry insight. With approximately 2,700 employees across the United States, Baker Tilly is ranked as one of the 15 largest accounting and advisory firms in the country. Headquartered in Chicago, Baker Tilly is an independent member of Baker Tilly International, a worldwide network of independent accounting and business advisory firms in 147 territories, with over 33,000 professionals. The combined worldwide revenue of independent member firms is $3.4 billion.

It's an exciting time to join Baker Tilly!

Responsible for development and maintenance of firm-wide reporting systems. This includes prototyping reports, designing ETL components, and prioritizing requests for enhancements to the reporting system. Also responsible for supporting users firm-wide with ad-hoc reporting, and data integration to better gather, store and utilize data.

Baker Tilly Annual Report 2017


  • Develop enhancements and make modifications to the reporting systems used by the firm. This includes, but is not limited to: the development of custom level queries, reports and actual system development work as needed, including time estimates to complete.

  • Troubleshooting and resolution of data issues

  • Extract and cleanse data from multiple systems, and provides further research into data

  • Interpret business objectives and needs, assess alternatives and provide innovative and logical solutions

  • Carry out Reporting team initiatives through identifying end user requirements, development, testing and support of reports, data warehouses and data analysis

  • Use effective time management with appropriate prioritization to ensure all assigned responsibilities are executed on time and with the quality expected

  • Provide exceptional customer service

  • Provide second level support for STAR (Time & Billing System) and other data intensive web applications

  • Research new technologies and applications that can improve the quality, performance or functionality of reporting applications used firm-wide

  • Maintain technical knowledge by attending technical education, attending workshops, reading publications and/or pursuing technical certifications

  • Manage projects using IT project management methodologies, including concept, design, budget, implementation and training phases

  • Maintain and comply with quality service by following organization's technological standards. Document procedures used.

  • Receive directions from Technology Manager, Reporting Manager or others, as needed

  • All other duties as assigned


  • Bachelor's degree in a specialized field such as business, finance, computer science, management information systems, or a related field

  • Ability to work independently with minimal supervision

  • Minimum of one (1) to two (2) year's experience or equivalent course-work

  • Excellent verbal and written communication skills and the ability to interact professionally with a diverse group, executives, managers, and subject matter experts

  • Strong problem-solving skills

  • SQL Service experience required

  • Experience using Microsoft Power BI, SQL Server Analysis Services, and/or SQL Server Reporting Services preferred

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Data Warehouse Business Analyst

Northshore Resources, Inc.

Posted Yesterday

VIEW JOBS 12/12/2018 12:00:00 AM 2019-03-12T00:00 <strong>NorthShore Resources has a Contract opportunity for a Business Analyst in Madison, WI!</strong><br /> <br /> We are recruiting for a dedicated IT Business Analyst who is a strong practitioner with 5 or more years of business requirements elicitation, documentation, stakeholder communication, requirements verification and testing as a primary job responsibilities.  <ul> <li style="padding: 0; margin: 0;">Responsible for leading and facilitating the communication with IT staff, business customers and other stakeholders, implementation services, and support services to assist in the development, implementation and support of business intelligence. </li> <li style="padding: 0; margin: 0;">Understands business objectives and problems, identifies alternative solutions, performs feasibility studies and cost/benefit analysis of alternatives in support of enterprise wide business intelligence. Manages the balance between business requirements and user expectations. </li> <li style="padding: 0; margin: 0;">Uses extensive experience as a liaison between users and technologists to drive requirements into design. </li> <li style="padding: 0; margin: 0;">Analyzes user requirements, procedures, and problems to automate processing or to improve existing processes: Confers with personnel of organization unites involved to analyze current business procedures, identify issues, and learn specific business requirements, such as how data is to be summarized, and formats for reports. </li> <li style="padding: 0; margin: 0;">Works with the team lead and manager to determine a detailed and prioritized list of objectives and activities for current and future projects. Experience with Human Services business intelligence is desirable. </li> <li style="padding: 0; margin: 0;">Responsibilities with include project work enhancing existing/new processes through data sharing, configuration, report writing and metrics. </li> <li style="padding: 0; margin: 0;">Troubleshoot and resolve issues efficiently. Identify potential technology improvements to be leveraged in support of the business. Assist in the creation and maintenance of test plans. Participate in special projects as required. </li> </ul> Required Skills <ul> <li style="padding: 0; margin: 0;">5+ years' of experience as a Business Analyst</li> <li style="padding: 0; margin: 0;">5+ years' of experience with Data Analysis</li> <li style="padding: 0; margin: 0;">3+ years' of experience with Data Flow diagramming and Data warehouse design and development</li> <li style="padding: 0; margin: 0;">Experience with Kimball Data Warehouse design principles</li> <li style="padding: 0; margin: 0;">Experience developing and implementing QA processes and procedures, including test/use cases</li> <li style="padding: 0; margin: 0;">Experience with Change Management</li> </ul> <br /> <em><strong>Why work for NorthShore Resources?</strong></em><br /> <em>NorthShore Resources is a Minneapolis-based IT consulting firm, whose focus is to provide superior quality and unparalleled customer service in all aspects of our business. We offer great local jobs to local people, allowing us to build solid, long-term relationships with our clients and consultants. </em><br />  <br /> <em>While working as a consultant for NorthShore Resources, you’ll receive benefits such as medical, dental, and 401(k) with company matching. You’ll also receive one of the best benefits an employer can offer – support! Our staff is here to help you every step of the way, ensuring that all of your questions are answered and that you’re placed on a path to success.</em><br />   Northshore Resources, Inc. Madison WI

Business Reporting Analyst

Baker Tilly Virchow Krause, LLP