08/10/2026 updated
100 % available
Senior Data Analyst | SQL | ETL | BI Tools | Power BI | Domo
Brooklyn, USA
Only remote
B.A. in Economics, College of Business, James Madison UniversitydbtSql Server Data Tools (SSDT)Adobe AnalyticsSql Data WarehouseMicrosoft Analysis ServicesAnalytic ApplicationsFinancial Data AnalysisBig DataBusiness AnalysisBusiness InformaticsData ArchitectureData ControlData IntegrationData ManagementData Manipulation Languages
Advanced SQL & Data Modeling
Expertise in advanced SQL including joins, aggregations, and window functions for querying data warehouses and MySQL databases. Data modeling and ETL development to build scalable, reliable datasets across multiple systems.
BI Tools & Dashboarding
Proficiency in Domo (Magic ETL, SQL Tile, Beast Mode, App Studio) and Power BI (DAX, Power Query, dashboards) for building automated dashboards and reporting workflows that track performance, conversion, and efficiency metrics.
KPI Design & Performance Analytics
Design and implementation of KPI frameworks and performance tracking systems. Delivery of executive-ready reports translating complex, multi-source data into clear, actionable insights for decision-making.
ETL Development & Automated Reporting Workflows
Development of automated analytics workflows and ETL pipelines to collect, process, and transform structured and unstructured data, reducing manual reporting effort and improving data accuracy.
Business & Financial Analysis
Analysis of cost, performance, conversion, and ROI data to identify efficiency drivers and support forecasting and performance planning. Building performance tracking frameworks aligned with business outcomes.
Data Cleaning & Standardization
Identification and resolution of data inconsistencies across platforms, improving overall data quality and trust in reporting outputs through systematic cleaning and standardization efforts.
Advanced Excel
Use of advanced Excel features including Pivot Tables, VLOOKUP, and analytical functions to support data analysis, media planning, and client strategy.
CRM & Marketing Platforms
Experience working with Salesforce, Marketo, StackAdapt, and Google Ad Manager to support marketing analytics, campaign performance tracking, and operational reporting.
Executive-Level Data Storytelling
Creation of executive presentations and reports that communicate complex analytical findings and recommendations to both technical and non-technical stakeholders at senior leadership level.
Expertise in advanced SQL including joins, aggregations, and window functions for querying data warehouses and MySQL databases. Data modeling and ETL development to build scalable, reliable datasets across multiple systems.
BI Tools & Dashboarding
Proficiency in Domo (Magic ETL, SQL Tile, Beast Mode, App Studio) and Power BI (DAX, Power Query, dashboards) for building automated dashboards and reporting workflows that track performance, conversion, and efficiency metrics.
KPI Design & Performance Analytics
Design and implementation of KPI frameworks and performance tracking systems. Delivery of executive-ready reports translating complex, multi-source data into clear, actionable insights for decision-making.
ETL Development & Automated Reporting Workflows
Development of automated analytics workflows and ETL pipelines to collect, process, and transform structured and unstructured data, reducing manual reporting effort and improving data accuracy.
Business & Financial Analysis
Analysis of cost, performance, conversion, and ROI data to identify efficiency drivers and support forecasting and performance planning. Building performance tracking frameworks aligned with business outcomes.
Data Cleaning & Standardization
Identification and resolution of data inconsistencies across platforms, improving overall data quality and trust in reporting outputs through systematic cleaning and standardization efforts.
Advanced Excel
Use of advanced Excel features including Pivot Tables, VLOOKUP, and analytical functions to support data analysis, media planning, and client strategy.
CRM & Marketing Platforms
Experience working with Salesforce, Marketo, StackAdapt, and Google Ad Manager to support marketing analytics, campaign performance tracking, and operational reporting.
Executive-Level Data Storytelling
Creation of executive presentations and reports that communicate complex analytical findings and recommendations to both technical and non-technical stakeholders at senior leadership level.
Experience
Professional experience5 - 10 years
Freelancer since2019
Languages
EnglishNative speakerFrenchNative speaker
Project history
Designed and maintained scalable reporting frameworks to provide visibility into customer performance, campaign health, and operational metrics for leadership teams. Built and optimized SQL-driven datasets across multiple systems, improving data accuracy and enabling consistent, reliable reporting. Developed automated dashboards and reporting workflows to track performance, conversion, and efficiency metrics. Delivered bi-weekly and monthly executive reports, translating complex data into clear insights to support decision-making. Analyzed large datasets to identify performance drivers, trends, and optimization opportunities across campaigns. Partnered with cross-functional teams to define KPIs and align reporting with business objectives. Evaluated cost, performance, and conversion data to identify efficiency drivers and improve ROI. Delivered trend analysis to support forecasting and performance planning.
Built analytics tools and data pipelines to collect, process, and analyze structured and unstructured data. Identified business problems and delivered data-driven solutions to improve operational performance. Developed reporting frameworks to synthesize data into actionable insights for business decision-making. Led data collection, cleaning, and transformation efforts to improve data usability and accuracy. Collaborated with stakeholders to define requirements and implement analytical solutions.
Led quantitative and qualitative analyses to support strategic healthcare reform initiatives and operational planning. Developed data-driven recommendations and presentations for senior stakeholders to guide decision-making. Designed and implemented business process improvements across procurement and supply chain operations. Contributed to digital transformation initiatives, including financial tracking and operational systems. Translated high-level strategy into actionable data-driven execution plans.