This position can be remote, but applicants must reside in one of the following states to be considered: MN, NY, OH, MO, PA, SC.

AAA Minneapolis is a part of one of the largest membership organizations in the country, and offers so much more than our legendary roadside service. We are a not-for-profit organization that serves Hennepin County and is made up of local Minnesotans who love our community as much as you do. Our products and services span some of the top industries, including travel, financial services, insurance, technology, traffic safety and, of course, automotive. This gives our employees the rare opportunity to be exposed to a variety of fields along with the ability to advance. AAA offers a flexible, supportive, collaborative work environment that prioritizes a healthy work-life balance and is inclusive of diverse backgrounds, beliefs and experiences.

AAA Minneapolis has more than a 120 year history and is in the early stages of an exciting new data journey. This is an opportunity for an experienced candidate to work closely with executive management and help us through an evolution into a data-centirc and growth performance organization that compliments an established history of service culture and employee life balance.

WHO WE ARE LOOKING FOR:

We are looking for someone who can independently manage the enterprise database environment, collection, analysis and insightful display of company data for delivering best in class business intelligence. The incumbent will initiate the development of enterprise database infrastructure and business intelligence capabilities, develop processes, and implement best practices in order to establish master data management as a new competency for the organization.

DUTIES AND RESPONSIBILITIES:

Data Collection, Standardization, and Automation

• Prepare data feeds from department software applications and disparate data sources
• Partner with company SMEs to understand granular detail and ensure data quality
• Fully automate data extraction, transformation, and load technical processes
• Identify, scope and deliver new opportunities for data collection
• Document sources, definitions, and standardized processes for data collection

Data Management and End Use

• Develop and maintain enterprise data warehouse for staging and consumption
• Utilize SSIS, SQL Server Management and SSRS to develop and manage data flows from origin to warehouse and subsequent required output
• Partner with SME’s to maintain a functional understanding of business data and ensure consistent data accuracy and integrity within the enterprise database environment
• Maintain a functional understanding of departmental and company data
• Identify and prioritize data management projects
• Use best practices for data protection, security, and protocols

Data Analysis and Business Intelligence

• Analyze and interpret data to assist executive management with strategic agendas, decision-making, operational improvements, and performance management
• Investigate data to account for outliners, demonstrate patterns and trends
• Partner with SME’s to understand reporting requirements
• Develop and maintain reports, dashboards and visualizations for end users via Power BI, SSRS, and SharePoint

QUALIFICATIONS:

• 5+ years experience with SQL Server, data management and report writing
• Advanced knowledge of SQL Server and Microsoft Productivity Applications
• Proficient use of Microsoft ETL tools and reporting tools, SSIS and Power BI
• Experience working with cross-functional project teams
• Experience managing data from multiple sources
• Self-starter and problem solver with the ability to work independently
• Excellent attention to detail
• or B.S. in IT, analytics (preferred)
• Experience with new or start-up data initiatives, projects, or teams (preferred)

AAA Minneapolis offers a competitive compensation and benefits packages including; medical/dental insurance, immediate eligibility for 401(k) & 401(k) matching, generous time off, a complimentary AAA Membership and much more!

AAA Minneapolis is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, sexual orientation, national origin, disability or protected veteran status.

Job Type: Full-time

Pay: $95,000.00 - $115,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Employee assistance program
• Employee discount
• Flexible schedule
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Vision insurance

Work Location: Hybrid remote in Minneapolis, MN 55416