Marketing Data Analyst - Power BI

SWCA Environmental Consultants; United States; Remote; USD 60,000 - 80,000; Full time

Job summary

SWCA Environmental Consultants is seeking a Marketing Data Analyst to enhance the analytics capabilities of their marketing team. This role is pivotal in designing and implementing Power BI reports and collaborating on projects that drive data quality and insights, promoting sustainability efforts in a dynamic remote work environment.

Benefits

Competitive wages and benefits

Employee stock ownership plan

Supportive, team-oriented work environment

Qualifications

• Minimum of 5 years of professional experience in marketing analytics or related field.
• At least 2 years focused on Power BI design and implementation.
• Demonstrated knowledge in data architecture principles.

Responsibilities

• Design and implement complex Power BI reports and dashboards.
• Collaborate with business stakeholders to define data models.
• Analyze and present marketing data from various sources.

Skills

Attention to detail

Analytical skills

Communication

Education

Bachelor’s degree

Tools

Power BI

Microsoft Office suite

Job description

3 days ago Be among the first 25 applicants

SWCA, a global employee-owned environmental consulting firm, is seeking a highly-skilled Marketing Data Analyst to significantly impact the data analytics capabilities of the Marketing team. This full-time, regular (with benefits) hourly position is open to remote candidates across the continental United States, with an option to work from our offices if preferred.

This role involves leveraging Power BI techniques, a working knowledge of data architecture and design, and advanced data visualization and data storytelling capabilities. The position also requires someone with attention to detail and the ability to prioritize, coordinate and support multiple projects, be flexible with changing priorities, and work both collaboratively and independently. Strong organizational, analytical, and communication skills are a must.

To be considered for the position, a cover letter must accompany your resume. The cover letter should include your work history designing and implementing complex Power BI reports and dashboards.

Application deadline: Our team will begin reviewing applications immediately, and interviews will be scheduled with qualified candidates on a rolling basis. The application process will remain open until we have received a robust pool of qualified candidates. Once we have identified suitable individuals, we may close the application process without prior notice. We appreciate the time and effort invested by all applicants and will carefully consider each submission.

Our Vision (the North Star): Help drive SWCA to be the best workplace and industry leader in sustainability, bringing sound science and creative solutions to global environmental challenges while maintaining a dedication to employee-ownership.

Core Values: We are #OneSWCA and collaborate across all our offices, programs, and disciplines. We are #AlwaysLearning, we #NeverSettle and #SWCAGivesBack. We are 100% employee-owned, and we build our success together. It is imperative for the successful candidate to fit SWCA's unique culture. Do you appreciate sustainability and environmental awareness? Is giving back to your community a priority? SWCA is a team of scientists, planners, technical experts, and corporate services professionals who are committed to our culture.

Purpose: Our company purpose is to preserve natural and cultural resources for tomorrow while enabling projects that benefit people today. You are invited to be a part of our success story.

What You Will Accomplish

• Design and implement complex Power BI reports and dashboards, utilizing advanced DAX, Power Query, and custom visuals to support cross-departmental decision-making.
• Collaborate closely with business stakeholders to define and execute data models that support efficient marketing data analysis and reporting across various platforms and departments.
• Be the go-to resource for client feedback, sales, opportunities, digital marketing, and CRM-related analytics and insights.
• Collect, compile, manipulate, analyze, and present marketing data from disparate sources.
• Work with organizational data and Business Intelligence (BI) program team to maintain existing BI products and develop new products to meet marketing - and broader business - needs.
• Create data visualizations and written summaries to ensure effective communication of data insights and their implications on the business.
• Proactively identify data gaps and partner with ERP, CRM, DAM, and other marketing system or channel managers to enhance marketing-related data collection.
• Drive the adoption of best practices in data governance, data quality, and data privacy to maintain high standards of data integrity and compliance.
• Use advanced data visualization and storytelling techniques to help internal data consumers understand, interpret, and use information to make decisions or create action plans.
• Support the annual business planning process with up-to-date marketing data and planning templates.
• Support quarterly marketing and sales KPIs tracking and benchmarking.

Experience and qualifications for success

Required Qualifications

• Bachelor’s degree from an accredited college or university.
• Minimum of 5 years of professional experience in marketing analytics, business analytics, or a related field, with at least 2 years focused on Power BI design.
• Demonstrated knowledge in data architecture principles, including dimensional modeling, and ETL processes.
• Proficiency in DAX, Power Query, and creating custom visuals in Power BI.
• Proficiency with Microsoft Office suite and Office 365 (Word, Excel, Teams, etc.)
• Strong analytical, problem-solving skills, and attention to detail, with an ability to communicate complex technical concepts to non-technical stakeholders.
• Proven track record of managing and delivering data analytics projects within a dynamic and complex organizational structure.
• Demonstrated success managing multiple priorities and meeting deadlines

Preferred Qualifications

• Bachelors degree in a technical or industry-relevant discipline (i.e., business administration, finance, marketing, computer science, information technology, data science, statistics, etc) very helpful.
• Experience in marketing or corporate support roles for B2B companies; AEC industry preferred
• Experience with Smartsheet
• Working knowledge of Microsoft Fabric

SWCA is a 100% employee-owned company, and we build our success together. With offices across the United States, SWCA is one of the largest environmental compliance firms and ranks among Engineering News-Record’s Top 200 Environmental Firms. We offer a supportive, team-oriented work environment and competitive wages and benefits, including a 100% employee stock ownership plan (retirement). We are expanding our team in nationally, and are looking for motivated individuals who take pride in delivering high-quality project work. If you thrive in the pursuit of ensuring excellence and ownership in your work as well as collaborating in a dynamic team environment, this is a great opportunity for you!

If you need assistance accessing SWCA’s website, completing the online application, or require a confidential conversation related to the Americans with Disabilities Act, please contact us at [e-mail] or call 1-480-581-5378. We are committed to providing an inclusive and supportive experience for all candidates. This contact information is specifically for accommodation requests; other inquiries will not receive a response.

SWCA is committed to salary equity and salary transparency for all its employees. In alignment with this commitment, SWCA posts good faith pay ranges in all its advertised job postings to promote pay equity and transparency.

An employee in this position can expect an hourly salary of between $31.80-$41.34. Actual pay within this range may depend on experience, qualifications, geographic location, client requirements where applicable, and other factors permitted by law. Regular-status employees are also eligible for performance bonuses. Candidates are also encouraged to consider SWCA’s Total Rewards package, which includes a competitive Benefits package, forward-thinking workplace flexibility, outstanding corporate culture, award-winning career development, and more.

SWCA is proud to be an Equal Opportunity Employer and encourages women, minorities, individuals with disabilities, and veterans to apply. At SWCA Environmental Consultants, we celebrate diversity and are committed to creating an inclusive work environment. We strongly encourage candidates from all backgrounds, including those with diverse experiences and veterans, to apply. We believe that a diverse and inclusive workforce enhances creativity, innovation, and overall organizational success.

SWCA continues to invest deeply in career development programs, delivering our award-winning Career Landscape support resources to accelerate the growth of our staff. We recognize the valuable skills and experiences our internal team members bring to SWCA’s continued success. Qualified internal candidates are encouraged to apply and will be seriously considered for this position. We believe in promoting from within, where possible, providing our existing employees with compelling opportunities to advance their careers.

Seniority level

• Seniority level

  Not Applicable

Employment type

• Employment type

  Full-time

Job function

• Job function

  Consulting and Marketing

Referrals increase your chances of interviewing at SWCA Environmental Consultants by 2x

Inferred from the description for this job

United States $130,000 - $150,000 2 weeks ago

United States $100,000 - $140,000 3 days ago

United States $80,000 - $95,000 4 days ago

IT Marketing Analyst (Part-Time, Hourly)

United States $144,451 - $216,651 2 weeks ago

New York, NY $116,000 - $125,000 2 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.