Power BI Developer

Notes to applicants:

• Dimensional sees great value from collaborating in our offices and appreciates the benefits of flexibility. Most roles fit our office-first hybrid approach: We are together on our campuses Tuesdays, Wednesdays, and Thursdays and have the choice to work in the office or remotely, depending on what is best for that work day, on Mondays and Fridays. This approach maximizes in-person collaboration and interaction while simultaneously providing flexibility and applies to most roles globally with a few exceptions that require more or less time in the office. Please discuss with your Recruiter to confirm the details for this specific role.

• Resumes and portfolios (when applicable) are required as part of your application. When applying from a mobile device or tablet, you may not be able to attach a resume. If you cannot include an attachment at the time of your application, you will receive a follow up email asking you to attach your resume from a computer.

• Here at Dimensional, we strive to be an inclusive workplace for all. Even if you do not match every qualification listed, if you are interested in who we are, what we do, and why we do it, we suggest and encourage you to apply.

• If you require reasonable accommodation in completing this application, interviewing, or otherwise participating in the employee selection process, such accommodation is available upon request.

Job Description:

The Marketing department enables sales by answering, “Why Dimensional?” They partner with sales groups, investment teams, and executive leadership within Dimensional to extract, package, and spread Dimensional’s message and philosophy. Marketing teams work to best reflect Dimensional’s unique offer to clients and advance its position in the marketplace.

The Senior Associate will be a member of the Marketing Analytics team and is responsible for developing and maintaining user-friendly Power BI dashboards and reports. The role will participate in each part of our marketing data lifecycle: ensuring clean data capture, building data pipelines, providing data transformations, and extracting insights. The Senior Associate, Marketing Analytics will act as liaison between key marketing stakeholders and technology to align our data architecture and reporting with firm and marketing priorities. 

The candidate must have the ability to work efficiently with large groups of stakeholders, gaining consensus and managing timelines in a fast-paced environment, and to use sound judgment with an eye to the broader marketing data and reporting needs for the business.

Responsibilities:

• Work with marketing colleagues, business analysts, and technology to translate firm and marketing objectives into data requirements, analysis, and insights in Power BI
• Map business objectives to Power BI data layers, DAX queries and visualizations.
• Oversee dashboard user testing and tutorials with key stakeholders.
• Work with data engineers and warehouse architects to translate Power BI data requirements into Snowflake
• Ensure all data reporting is accurate and consistent.
• Analyze requests and understand total asks before engaging the appropriate department resources. Ensure proper prioritization, meet all established deadlines, and proactively resolve issues that may impact delivery of data.
• Display exceptional customer service skills and help foster an environment of teamwork.
• Understand the duties and strengths of fellow teammates. Ensure resources are aligned and everyone is working toward a common objective.
• Maintains regular communication with Marketing teams and internal clients for early detection of issues.

If the following statements resonate with you, we encourage you to apply.

• You’re curious— you’re always trying to understand the “why”, and you’re confident in digging into the underlying information in order to get there.
• You’re flexible— you understand priorities change, requiring you to shift focus when needed, while also working on multiple projects in parallel.
• You’re collaborative and you genuinely like working with people—you thrive in environments where you can partner and work closely with a variety of teams in many different locations.
• You’re positive— you love a challenge and you understand that hurdles can sometimes be defeating, but that doesn’t keep you from staying positive and enthusiastic day in and day out.
• You are an effective communicator—you possess the verbal, written, and interpersonal communication skills that are essential to translating complex requests into digestible, actionable insights. 
• You value quality—you do top-quality work, manage quality, and make everything you touch better.
• You’re a work in progress—you are not afraid to fail and learn through the experience while welcoming feedback. You are constantly growing your own knowledge and helping to grow the knowledge of others.

Qualifications:

• Bachelor’s degree in a statistical field (computer science, statistics, physics, econ, business analytics, etc.)
• Minimum of 4 years of experience in marketing and data analytics, preferably in a B2B organization
• 3+ years of experience in Data Modeling, writing complex DAX queries and producing user-friendly dashboards in Power BI
• 2+ years of experience manipulating, transforming, and analyzing data with SQL
• Working knowledge of databases, star schemas and database management. Snowflake experience is a plus
• Excellent understanding and implementation of marketing analytics concepts like media mix modeling, funnel optimization, attribution models, user segmentation/cohorts, etc
• Strong strategic thinking skills with the ability to tie marketing KPIs and analysis directly to business outcomes
• Experience working with various marketing platforms like Google Analytics (GA4), Google Search Console, LinkedIn Campaign Manager, Twitter Ads, etc.
• Strong prioritization and organizational skills, including the ability to maintain several concurrent projects while providing realistic delivery dates and managing stakeholder expectations
• Must be process-driven, but flexible
• Demonstrated ability to take initiative

#LI-Hybrid

Dimensional offers a variety of programs to help take care of you, your family, and your career, including comprehensive benefits, educational initiatives, and special celebrations of our history, culture, and growth.

It is the policy of the Company to provide equal opportunity for all employees and applicants. The Company recruits, hires, trains, promotes, compensates, and administers all personnel actions without regard to actual or perceived race, color, religion, religious practice, creed, sex, sex stereotyping, pregnancy (which includes pregnancy, childbirth, and medical conditions related to pregnancy, childbirth, or breastfeeding), caregiver status, gender, gender identity, gender expression, transgender identity, national origin, age, mental or physical disability, ancestry, medical condition, marital status, familial status, domestic partnership status, military or veteran status or service, unemployment status, citizenship status or alienage, sexual orientation, status as a victim of domestic violence, status as a victim of stalking, status as a victim of sex offenses, genetic information, political activities or recreational activities, arrest or conviction record, salary history, natural hairstyle or any other status protected by applicable law except as otherwise required or permitted by law or regulation applicable to the Company or its affiliates.