Data Analyst

About the role

MicroSourcing is seeking a Data Analyst to join its remote team. The role focuses on data integration, automation, and analytics to support client reward programs and internal decision‑making.

Key responsibilities

• Analyze client data structures and build automated pipelines, data transposers, and integrations between client systems and P2M platforms.
• Audit existing client workflows and data pipelines to identify bottlenecks, eliminate manual steps, and automate data transfers.
• Execute end‑to‑end data setup, mapping, and validation for new reward program launches and ongoing maintenance.
• Create interactive Power BI/Excel dashboards, visualizations, and analytical presentations for internal and client stakeholders.
• Synthesize unstructured data from disparate sources to uncover inefficiencies, analyze engagement trends, and deliver strategic recommendations.

Required profile

• Advanced proficiency in data cleaning, transformation, and mapping across CSV, JSON, XML, and Excel formats.
• Deep hands‑on experience with advanced Excel functions (nested logic, Power Query, Pivot Tables, XLOOKUP, data modeling).
• Understanding of database mechanics, file transfer protocols (SFTP, APIs), and data integration pipelines.
• Strong analytical and critical‑thinking abilities to spot trends, anomalies, and operational inefficiencies.
• Excellent written and spoken English to translate technical findings into executive summaries and client‑facing presentations.

Required skills

• Data manipulation and ETL tools
• Advanced Microsoft Excel
• Data integration via SFTP and APIs
• Power BI or Tableau
• SQL querying
• Python or R for automation and statistical modeling

What we offer

• Above‑market compensation with performance bonuses
• Healthcare coverage from day one for you and dependents
• Paid time‑off with cash conversion
• Group life insurance
• Flexible remote work arrangements
• Opportunities for continuous learning and career advancement
• Inclusive culture that celebrates diversity