BI Data Analyst (Must Reside In Buffalo / Western NY Region)

At AAA Western and Central New York, our Associates are committed to providing our members with a totally satisfying experience. Therefore, we seek Associates who are dedicated to this purpose, people who truly demonstrate compassion, empathy and unsurpassed service. These are the people that help us create a loyal membership base that strengthens our mission—to be our members’ most trusted provider of high quality automotive, travel, insurance and other relevant products and services that offer safety, security, peace of mind, value and convenience.

AAA Western and Central New York is regularly recognized as one of the best & healthiest places to work in the WNY & CNY area. In addition to a market competitive salary, Associates are eligible for a wide selection of benefits (dependent upon position) including:

• Medical, Dental, Life and AD&D Insurance


• Flexible work schedules


• Pre-Tax & Roth 401(k) plan with company match


• Health Spending Accounts with company contribution & Flexible Spending Accounts


• Company Paid Short-term & Long-term disability


• Paid time off


• Tuition reimbursement & company-paid training programs


• FREE AAA membership & travel / product discounts


• Paid Volunteer Time Off

Job Responsibilities

Data Analysis & Interpretation : Understand, interpret, and analyze the data used by multiple business lines using statistical methods. Develop, edit, and monitor data quality control reports to provide clear and quality of the data in use. Assist in development of data architectural design, data collection systems and data analytics to improve upon efficiency, transparency and quality of data. Identify, analyze and interpret trends or patterns in complex data sets. Provide database function recommendations and solutions to improve data through processes such as ETL (Extract, Transform, and Load) and other data cleansing projects. Review new process data improvements and present to management. Collaborate with Sales Analysts to validate assumptions, calculations, and metric definitions used in analytical models. Ensure analytical outputs are supported by consistent dimensional models and shared definitions.

BI Platform Optimization, Quality, & Governance : Build and manage the performance and quality of data sets and data flows in Power BI for all Power BI reporting. Manage the review of developed reports by business line analysts and approve for production ensuring governance of Report inventory. Assist with the documentation of information value chain process flows and analyze for improvements to efficiency. Document and maintain details of meta data for multiple business functions. Provide issue management and remediation support to business lines. Collaborate with management to ensure process flows and prioritization is followed per documented requirements. Provide support to business line subject matter experts on data questions and permissions.

Communication & Execution : Collaborate with Subject Matter Experts in the business to understand their data requirements. Use this information to inform data quality monitoring. Articulate clearly and concisely to business lines on the quality results. Prepare reports for executive leadership to effectively communicate relevant trends and patterns that may be used to predict and inform management of actions. Ensure appropriate estimates for time to complete data efforts for monthly sprints and deliver timely.

Issue Management and Remediation Support- Provide issue management and remediation support to business lines. Collaborate with management to ensure process flows and prioritization is followed per documented requirements. Provide support to business line subject matter experts on data questions.

Project Contribution : Contribute to data projects designed to progress efficiencies within the Club. Provide business line management data on relevant project components.

Job Specific Requirements

• Proficiency with Python, Databricks, Azure Data Factory, SQL, Microsoft Office applications, preferably including MS Visio and MS Power BI or other Business Intelligence Applications

• Demonstrable technical expertise regarding meta data concepts, data models, database design development, data mining techniques and relational databases

• Ability to apply, transform, communicate and present statistical knowledge in creation of query and report that can be clearly understood by various business lines

• Must be able to work independently

• Demonstrated experience partnering with business analysts or sales analysts to develop and operationalize analytical data models

• Strong understanding of dimensional modeling concepts (facts, dimensions, measures) for BI and reporting use cases

• Demonstrated use of Artificial Intelligence (AI) tools for the purpose of data cleansing, analytics, or reporting

• Some travel required within the Club territory

Physical Requirements

• Ability to perform routine office tasks that includes operating a computer for long periods of time, sitting, filing and communicating on the phone


• Ability to perform all physical functions consistent with travel including sitting in airplanes and driving for long periods of time


• Must be able to lift, carry, push, pull a maximum of 30 lbs

Starting pay range: $79,351-$93,355