Description

　　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

　　Potential for remote work & 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

　　Job Responsibilities

　　30% Data Development Architecture & Job Construct - Develop, implement and oversee strategic cloud based data lake. Support the movement of data from various internal and external sources into the data lake while maintaining existing data warehouse. Monitor processes and reports for completeness and quality of data in the warehouse. Maintain existing extract, transform and load data (ETL) and developing ELT for cloud analytics, while being responsible for the issue resolution process. Create and maintain relevant documentation.

　　30% Report Structure & Development -Develop, implement and troubleshoot data extractions from all applicable data sources into the data lake and data warehouse. Translate business requirements into functioning data structures. Support strategic reporting dashboards and data sets as needed.

　　30% Technical Solutions & Communications -Provide technical guidance to identify BI process system deficiencies. Analyze and provide solutions to implement corrections. Provide issue management and support to business lines regarding report or dataset structure. Collaborate with management to ensure process flows and prioritization is followed per documented requirements. Translate business requirements into data sets and/or files for the transfer of internal information to external partners including developing, testing and implementing solutions. Integrate data management solutions with the data warehouse and other applications. Actively participate in Club projects involving new or changed data to ensure data is tested, usable and prepared for user consumption and seamless reporting.

　　10% Data Analysis -Support the department as needed including data analysis, code review, support to consumer questions and documentation. Continuously learn and communicate on relevant technical advances and improvements that are aligned with the Club's needs and continued digital transformation.

　　Job Specific Requirements

　　Strong knowledge of Azure Databricks, Azure Data Factory, Microsoft Reporting Services, MS SQL Server Management Studio, SQL Server Integration Services (SSIS)

　　Demonstrated competency in Data Visualization tools such as MS Power BI

　　Expertise on data models, database design development, data mining techniques and relational databases.

　　Technical development and deployment as indicated in the job description

　　Proven ability to work collaboratively with stakeholders translating business requirements into data management activities

　　Excellent documentation skills

　　Experience in developing and maintaining Application Programming Interfaces (API) is preferred.

　　Satisfactory equivalent combination of education and experience

　　Compensation

　　The mid-market salary range for this position is $80,787.60 to $89,764.00. Starting salary is dependent on several factors including previous work experience, specific industry experience, and skills required. Our benefits package includes, but is not limited to, health and dental insurance, 401(k) plan with competitive match, fully paid group life insurance, short and long term disability insurance, travel discounts and a free AAA membership.. To learn more visit: www.aaa.com/careers.

　　Qualifications

　　Education

　　Preferred

　　Bachelors or better in Computer ScienceExperience

　　Required

　　Experience designing, writing technical requirements and/or presenting data solutions.

　　Working knowledge of Databricks or similar application to write queries and publish visualizations.

　　3 years: Experience developing visualizations and reports in Business Intelligence application or equivalent experience Working knowledge of both on premises and cloud based data and analytics environments

　　5 years: Experience with Extract, Transfer and Load (ETL) development, Extract, Load and Transform (ELT) or equivalent experience.