Marketing Analytics & Business Intelligence | SW Marketing
The Data Analyst will be responsible for collecting, analyzing, transforming, and reporting on data to support the organization's marketing team and broader business objectives. This individual will work with data from multiple systems and platforms to develop meaningful insights, identify trends, measure performance, and support data-driven decision-making.
The ideal candidate will have strong technical expertise in SQL, Snowflake, and Power BI, along with experience working with large datasets, data modeling, and business intelligence tools. The ability to translate complex data into clear, actionable reporting and dashboards is essential.
Experience supporting marketing, sales, or business development teams is highly desirable, particularly in areas such as campaign performance, lead generation, customer segmentation, sales pipeline analysis, and revenue reporting. Familiarity with AI platforms and emerging AI-driven analytics tools is also a plus.
Essential Functions
Data Analysis & Reporting
-
Collect, analyze, and interpret data from multiple business systems and platforms.
-
Identify trends, patterns, and opportunities through data analysis.
-
Develop recurring reports and provide ad hoc analysis to support business decisions.
-
Ensure data accuracy, consistency, and integrity across reporting environments.
SQL & Data Management
-
Write, optimize, and maintain SQL queries to extract and analyze data.
-
Work with Snowflake and other data warehouse environments to access, organize, and manage large datasets.
-
Perform data cleansing, validation, transformation, and integration.
-
Assist with data modeling and the development of reliable reporting datasets.
Business Intelligence & Visualization
-
Design, develop, and maintain interactive dashboards and reports using Power BI.
-
Translate business requirements into meaningful KPIs, metrics, and visualizations.
-
Present analytical findings in a clear and understandable format for business stakeholders.
-
Improve existing reporting processes and automate recurring reports where possible.
Marketing & Sales Analytics
-
Support marketing performance measurement, campaign analysis, lead generation, and customer segmentation.
-
Analyze sales pipeline activity, conversion rates, and business developme