Marketing Business Data Analyst

Affinity Plus Federal Credit Union; Saint Paul (MN); Hybrid; USD 69,000 - 88,000; Full time

Benefits offered by this job

Low-cost medical, dental, and vision

401K with 5% match

Paid time off / paid leave options

Wellness benefit

Job summary

Affinity Plus Federal Credit Union in Minnesota is seeking a Marketing Business Data Analyst I to transform member insights into action. You will collect and interpret data, build dashboards, and partner with marketing and product teams to measure performance and inform decisions.

This role emphasizes data storytelling for both technical and non-technical audiences, with a starting pay range of $69,100 to $88,100 and hybrid work, mostly virtual with onsite meetings in St. Paul.

Qualifications

• 2+ years of experience in business analysis, marketing analytics, or related role developing reporting based on complex analysis for leadership.
• Strong analytical and decision-making skills with a high degree of accuracy; ability to investigate and determine root cause of issues.
• Experience with SQL writing advanced queries.
• Basic experience with Python for data analysis.
• Advanced Excel and visualization tools proficiency (Power BI, QuickSight) to help tell a story and share actionable insights.

Responsibilities

• Collect, analyze, and interpret data from multiple sources ensuring data quality and consistency.
• Partner with business channels to understand their needs; translating business goals into measurable analytical requirements.
• Build complex analytical content, including reports, dashboards, ad-hoc analysis, and data sets focused on member insights, product & service engagement, marketing impact and other areas of focus for the credit union.
• Develop tracking for business requirements and complete ongoing analysis delivering business insights into our membership, business evaluation, process improvement, and member service.
• Evaluate marketing campaign performance across multiple channels based on KPIs and provide actionable recommendations to optimize targeting, messaging, and ROI.
• Present findings and insights clearly by telling a story with data to both technical and non-technical audiences.
• Collaborate with other analysts & EDI team members to support successful analytics projects across the organization.

Skills

SQL

Python

Excel

Power BI

QuickSight

Marketing analytics

NPS

Communication

Education

Data Analytics degree

Statistics degree

Tools

Power BI

Confluence

Jira

QuickSight

Job description

At Affinity Plus every employee understands how their work affects our members experience and we strive to provide an experience that can't be found anywhere else. Great service starts with great employees and that is why we focus on providing not only the best place our members will ever bank but the best place our employees will ever work. Between our one of a kind culture, incredible benefits, and work/life balance; we believe you will feel the Affinity Plus difference.

Position Overview

The Marketing Business Data Analyst I role is responsible for supporting the goals and success of Affinity Plus by identifying trends & driving awareness surrounding member (customer) insights, bringing forward areas of opportunity & outreach based on data, and analyzing product, service, and program performance. This role will have a focus on Marketing and other specific business areas based on business need and will collaborate closely to maintain on-going communication to better understand business needs and determine how to provide timely & relevant data insights to address.

Duties And Responsibilities

• Collect, analyze, and interpret data from multiple sources ensuring data quality and consistency.
• Partner with business channels to understand their needs; translating business goals into measurable analytical requirements.
• Build complex analytical content, including reports, dashboards, ad-hoc analysis, and data sets focused on member (customer) insights, product & service engagement, marketing impact and other areas of focus for the credit union.
• Develop tracking for business requirements and complete on-going analysis delivering business insights into our membership, business evaluation, process improvement, and member (customer) service.
• Evaluate marketing campaign performance across multiple channels based on KPI’s (i.e. conversion, acquisition, value) and provide actionable recommendations to optimize targeting, messaging, and ROI. Support business planning through trend analysis and modeling.
• Communicate regularly with the internal stakeholders on projects - scope, status, and progress tracking, requesting feedback on results prior to closing out.
• Present findings and insights clearly by telling a story with data to both technical and non-technical audiences. Provide overviews and demonstrations for business users that drive understanding of advanced reporting, interactive visualizations, or other content to increase adoption and usage.
• Collaborate with other analysts & EDI team members to support successful analytics projects across the organization, query writing & validation of data sets, workflows & visualizations, data challenges, and brainstorm options that address business area needs.
• Collaborate with Marketing and other departments & product teams on the development of solutions which support business goals and data-driven decision making.
• Maintain relevant project updates using Jira boards, Confluence, or other software pertaining to work.
• Monitor industry trends and emerging analytics methodologies.
• Other duties as assigned

Qualifications And Skills

• 2+ years of experience in business analysis, marketing analytics, or related role developing reporting based on complex analysis for, and presenting insights to, business leadership required; focus on marketing analytics preferred
• Degree in Data Analytics, Statistics, Business, Finance or another relevant field preferred
• Strong analytical and decision-making skills required with a high degree of accuracy; ability to investigate and determine root cause of issues
• Experience with SQL writing advanced queries required; basic experience with Python for data analysis also preferredAdvanced skill and experience using Excel and visualization tools (i.e. Power BI, QuickSight) to help tell a story and share actionable insights
• Ability to understand and find appropriate applications for data collection and analysis
• Ability to analyze large datasets, summarize, and communicate meaningful insights to business users
• Experience with Net Promoter Score programs, digital marketing & media platforms (i.e. Google Ads, Meta, LinkedIn) and their reporting tools preferred
• Understanding of core marketing concepts and metrics preferred
• Aptitude to work independently as well as part of a team and ability to collaborate with others
• Strong verbal and written communication skills
• Time management skills and the ability to prioritize workload managing multiple projects and deadlines
• Flexibility to adapt and succeed in a dynamic environment

Workplace Environment

• Sitting 90-95% and standing 5-10% which is determined on your rotation within the branch
• Working at a computer 98% of the day, utilizing the phone 40-60%
• Bending, twisting, kneeling, stooping, or crouching when appropriate, on occasion
• Repetitive movements, including but not limited to typing, using a mouse, phones, etc.
• Lift, carry, push or pull up to approximately 30 pounds

Required Work Schedule

Standard Monday through Friday business hours with a willingness to work a flexible schedule as needed.

Location

This position will have the opportunity to work mostly virtually, but candidates should live in Minnesota or Wisconsin. Working onsite throughout the year for meetings and team events will be required and are typically held in or near St. Paul, MN. Additionally, once hired, more time onsite may be required initially for training, collaboration and working sessions.

Compensation & Total Rewards

This position has a starting pay range of $69,100 — $88,100 annually.

Total Rewards

Affinity Plus offers a comprehensive Total Rewards package that goes beyond base pay. In partnership with the State of MN Employer Group, Affinity Plus provides low-cost medical, dental and vision insurance coverage options. Additionally, Affinity Plus frontloads all sick time hours and a portion of vacation hours for all new employees, offers a variety of paid leave options, a monthly wellness benefit, and immediate 401K matching up to 5%. Our Total Rewards philosophy is designed to support your well-being and growth while fostering a fair and inclusive workplace.

Disclaimer

Applicants may be subject to a background and credit check. Employees in this position must be able to satisfactorily perform the essential functions of the position. If requested, Affinity Plus Federal Credit Union will make every effort to provide reasonable accommodations to enable employees with disabilities to perform the position’s essential job duties. As markets change and the Organization grows, job descriptions may change over time as requirements and employee skill levels evolve. With this understanding, Affinity Plus Federal Credit Union retains the right to change or assign other duties to this position.

Application Deadline

Affinity Plus Federal Credit Union accepts applications on a rolling basis.