Data Analyst-Marketing Member

Join Blue Federal Credit Union as a marketing and member data analyst and strategic advisor. In this onsite Cheyenne, WY role, you will help optimize institutional ROI by turning member journey data into actionable insights for senior leadership. The position blends advanced data engineering, segmentation, and predictive analytics with executive-level data storytelling and self-service dashboard adoption.

Salary: USD 63,911 - 92,402 per year. Experience: 3+ years of similar or related work. Education: Bachelor’s degree in data Analytics, Computer Science, Statistics, Economics, Finance, Marketing Analytics, or equivalent.

Responsibilities

• Write, optimize, and maintain advanced SQL queries (multi-table joins, CTEs, window functions) across core banking systems, data warehouses, and MCIF/CRM platforms.
• Engineer high-precision audience segmentation files and suppression logic for omni-channel campaigns including direct mail, digital ads, and email.
• Apply validation protocols, data hygiene, and regulatory compliance requirements including GLBA, CAN-SPAM, FCRA, and Fair Lending.
• Automate recurring data extractions to reduce manual friction and accelerate campaign go-to-market cycles.
• Combine quantitative core data (product penetration, interchange volumes, digital adoption) with qualitative signals (NPS, member effort scores, onboarding feedback) to evaluate end-to-end member lifecycle dynamics.
• Perform root-cause analyses related to acquisition, cross-sell propensity, deposit elasticity, and attrition or dormancy risks.
• Build Python workflows using Pandas, NumPy, and Scikit-Learn for exploratory analysis, persona clustering, and predictive conversion modeling.
• Design and measure A/B and multivariate campaign tests with clear attribution tied to acquisition cost, ROAS, portfolio growth, and lifetime value.
• Architect and maintain interactive enterprise dashboards and semantic data models in Power BI (advanced DAX, Power Query) or Tableau to monitor KPIs, campaign effectiveness, and operational touchpoints.
• Partner cross-functionally with teams such as Retail Branches, Lending, and Wealth Management to translate business questions into automated reporting solutions.
• Maintain data dictionaries, audience logic, reporting catalogs, and lineage documentation.
• Synthesize findings into executive-level presentations, visual scorecards, and narrative business cases for Senior Leadership and Committee review.
• Serve as an internal strategic consultant to department heads, supporting data-backed recommendations on product design, pricing sensitivity, branch operations, and member retention.
• Champion self-service dashboard adoption and metrics interpretation across the organization.
• Comply with all company policies and procedures, including applicable laws and regulations such as the Bank Secrecy Act, the Patriot Act, and the Office of Foreign Assets Control.

Requirements

• Three to five years of similar or related experience, including preparatory experience.
• Proven ability to write, debug, and optimize complex multi-table joins, subqueries, CTEs, and window functions against enterprise relational databases.
• Demonstrated experience building end-to-end data models and dashboards in Power BI (including DAX and data shaping) or Tableau.
• Working knowledge or active application of Python (Pandas, NumPy, Scikit-Learn) for data manipulation, process automation, and predictive modeling.
• Bachelor’s degree in data Analytics, Computer Science, Statistics, Economics, Finance, Marketing Analytics, or equivalent quantitative discipline or work experience.
• Physical ability to perform primarily sedentary work for long periods with limited exertion and occasional lifting of up to 20 lbs; able to bend, sit, and stand; able to climb or descend stairs in an emergency.
• Ability to operate routine office equipment and sustain repetitive keyboard use for an average of 6-8 hours per day when necessary.
• Ability to work extended hours or travel off site whenever required or requested by management, and maintain regular, reliable, timely attendance.
• Ability to work indoors in a climate-controlled shared area with minimal noise; ability to read and follow written and oral instructions; ability to speak clearly and communicate logically.
• Ability to work independently or with limited supervision, handle multiple changing priorities, and exercise discretion with confidential internal and external matters.
• Ability to deal calmly and professionally with numerous different personalities from diverse cultures and demonstrate highest levels of customer service and discretion when working with the public.

Tools You’ll Use

SQL, Python, Pandas, NumPy, Scikit-Learn, Power BI, DAX, Power Query, Tableau, MCIF, CRM, Qualtrics, Medallia, MemberXP.