Data Analyst

MARS Solutions Group; Milwaukee (WI); Hybrid; USD 75,000 - 110,000; Full time

Job summary

MARS Solutions Group is seeking a Data Analyst for the Decision Science & Strategy team in Milwaukee. The role centers on SQL, data processing, campaign segmentation, reporting, and Power BI to support nonprofit fundraising campaigns.

The position is hybrid with 1–2 remote days per week, offering collaboration with both technical and non-technical stakeholders. You will also build data pipelines and deliver campaign-ready outputs.

Qualifications

• 3+ years of data processing, programming, and data analysis experience.
• Strong SQL; write and optimize queries across sources.
• Hands-on experience with Azure, SQL, SSIS, Power BI and Excel.

Responsibilities

• Analyze and process data from multiple sources to support campaigns.
• Build and maintain ELT/data pipelines and integrations.
• Create campaign segmentation and campaign-ready output files.
• Develop Power BI dashboards and reporting for stakeholders.
• Automate manual data processes and improve efficiency.

Skills

SQL

Data processing

Data analysis

Campaign segmentation

Power BI

Data pipelines

Data cleansing

Deduplication

ELT pipelines

Dashboard reporting

Automation

Stakeholder communication

Tools

Azure

SSIS

Power BI

Excel

Job description

Our client has a Data Analyst opening supporting the Decision Science & Strategy team. This role is heavily focused on SQL, data processing, campaign segmentation, reporting, and Power BI, with the data ultimately supporting nonprofit fundraising campaigns. The position is hybrid with 1 2 remote days per week

What They Are Looking For

• 3+ years of data processing, programming, and data analysis experience
• Strong SQL is critical must be able to write and optimize queries, validate data, and work across multiple data sources
• Hands‑on experience with Azure, SQL, SSIS, Power BI, and Excel
• Experience cleaning, processing, deduplicating, and segmenting large datasets
• Ability to create campaign/output files that are ready to be sent to external vendors
• Experience building and maintaining ELT/data pipelines and integrations
• Strong Power BI dashboard and reporting experience
• Experience improving or automating manual data processes
• Ability to manage multiple projects and deadlines in a fast‑paced environment
• Strong communication skills and ability to work with both technical and non-technical stakeholders

Nice To Have

• Python or PowerShell automation
• Nonprofit or fundraising experience
• Experience with nonprofit CRMs such as Salesforce NPSP, Raiser s Edge, or EveryAction
• Direct mail, digital marketing, donor segmentation, source coding, or RFM modeling experience
• Understanding of fundraising campaign metrics and multi-channel reporting

Important: This is not just a BI/reporting position. We need candidates who are comfortable getting into the underlying data SQL, data cleansing, segmentation, deduplication, data pipelines, and producing campaign-ready output files in addition to dashboards and reporting.