Location: Remote (with possible on-site meetings – US West Coast)
Job Type: Contract
Overview:
Seeking a skilled Power BI Dashboard Development Contractor to support our Marketing Measurement Initiative. This role will focus on developing capabilities to extract, aggregate, and transform data into insightful metrics presented through a company-wide dashboard. The dashboard will provide the Key Performance Indicators (KPIs) needed to create a compelling narrative for executives, program partners, and other high-level stakeholders.
Key Responsibilities:
Phase 1: Initial Power BI Dashboard for TBD Program
- Collaborate with internal and external teams to implement deliverables.
- Ensure Power BI access for key employees and personnel.
- Confirm points of contact for data source access.
- Connect to data sources and set up data checks for metric accuracy.
- Develop, create, test, and disseminate the dashboard.
Phase 2: Expanded Power BI Dashboard for Three Additional Marketing Campaigns
- Implement deliverables with internal and external teams.
- Ensure Power BI access for key employees and personnel.
- Confirm points of contact for data source access.
- Connect to data sources and set up data checks for metric accuracy.
- Develop, create, test, and disseminate the dashboard.
Services Include:
- Define Dashboard Objectives: Outline specific metrics and KPIs, including campaign reach, conversion rates, cost per acquisition, and program enrollment numbers.
- Gather Data: Utilize sources such as Adobe Analytics, social media platforms, email marketing tools, CRM systems, and others to collect relevant data. Ensure data cleanliness and compatibility with Power BI.
- Modeling: Develop a cohesive data model connecting all relevant data sources. Establish relationships between tables and create calculated columns or measures to derive new metrics if necessary.
- Dashboard Design: Strategically design the dashboard layout with appropriate visualizations like line charts, bar charts, and tables.
- Create Visualizations: Use Power BI's tools to create visually compelling charts and graphs representing the data. Customize visualizations for clarity and comprehension.
- Add Interactivity: Incorporate interactive features such as slicers, filters, and drill-downs for dynamic data exploration by users.
- Include Key Metrics: Ensure the dashboard encompasses key metrics pertinent to marketing campaign performance and program enrollments.
- Testing and Validation: Conduct thorough testing to verify dashboard accuracy and validate data against source data.
- Deployment: Publish the dashboard to Power BI Service or desired platform. Configure permissions to control dashboard visibility and editing capabilities.
Qualifications:
- Advanced knowledge of Power BI Desktop and Power BI Service.
- Strong understanding of data modeling, data visualization, and BI reporting.
- Experience in building dashboards, reports, and data visualizations.
- Understanding of DAX (Data Analysis Expressions) for creating calculated columns, measures, and custom tables.
- Knowledge of Power Query for data transformation.
- Proficiency in SQL for querying databases.
- Experience with data modeling, including the creation and management of data relationships within Power BI.
- Familiarity with ETL (Extract, Transform, Load) processes.
- Familiarity with Azure, databases, REST APIs, and SAP
- Proficiency with data sources such as Adobe Analytics, social media platforms, email marketing tools, and CRM systems.
- Excellent analytical, problem-solving, and communication skills.
- Ability to work collaboratively with internal and external teams.
- Attention to detail and a commitment to data accuracy.
How to Apply:
Interested candidates should submit their resume and a cover letter detailing their relevant experience, and at least 2 complex examples of dashboards.
Job Type: Contract
Pay: $50.00 - $60.00 per hour
Expected hours: 20 – 30 per week
Compensation package:
Experience level:
Schedule:
- Choose your own hours
- Monday to Friday
Experience:
- Power BI: 5 years (Required)
- SQL: 5 years (Preferred)
- Data warehouse: 5 years (Preferred)
Work Location: Remote