Power BI Developer

MoodysNWC is seeking a skilled Power BI Developer with strong analytical and data visualization expertise, and a passion for GenAI-driven analytics innovation. In this role, you’ll design impactful dashboards, build optimized data models, and deliver actionable insights using Power BI, SQL, DAX, and cloud data platforms. The ideal candidate excels in data storytelling and thrives in a dynamic, fast-paced environment, with a strong drive to deliver high-value business intelligence solutions that push the boundaries of traditional analytics.

Responsibilities:

1: Perform Discovery and Determine Scope

Analyze data via SQL to assess structure, granularity, quality, and analytical fit.

Gather, document, and validate detailed business requirements.

Define innovative, actionable analytics and KPIs.

Prepare high-level project plans with activities, resources, and timeframes.

Recommend appropriate analytics delivery methods and platform options.

2: Evaluate, Prepare, and Connect to Data

Implement Power BI connections to Cloud data sources (e.g., Snowflake, Redshift, Google Cloud SQL, Azure SQL).

Collaborate with data engineers to prepare efficient, aligned data sets.

Create views and aggregate datasets within Cloud data warehouses.

Address data sourcing, connection settings, query performance, and transformation.

3: Plan and Implement Data Models & DAX

Recommend calculation methods between Power BI and Data Warehouses.

Design and develop data models with relationships, measures, hierarchies, and security.

Create DAX measures for complex calculations and optimize model performance.

4: Design Dashboards and Develop Visualizations/Reports

Implement performance best practices in dashboard development.

Create insightful, actionable visualizations aligned with business needs.

Support UAT, performance testing, and deployment activities.

Enrich reports with features like drill-throughs, slicers, exports, mobile access, and alerts.

5: Enable Insightful Analysis & AI

Enhance reports with conditional formatting, Quick Insights, grouping, and AI features.

6: Deploy Assets and Maintain Access

Qualifications:

4-7 years of relevant experience.

Advanced SQL query skills.

Strong Power BI expertise, including DAX and data modeling.

Effective client communication (both verbal and written) is a must-have.

Ability to tell stories with data and maintain analytical curiosity.

Passion for innovation and Gen AI technologies, including familiarity with ChatGPT, Custom GPTs, and other Gen AI capabilities.

Ability to work independently or in a team environment under tight deadlines.

Adaptability to a dynamic, high-paced team environment with constantly changing demands and priorities.

High attention to detail and quality.

Preferred Qualifications:

Microsoft Power BI certifications (especially PL-300 Data Analyst).

Expertise in Cloud Data Warehouses (Snowflake, Redshift, Google, Azure).

Python skills across data preparation to visualization.

About us:

MoodysNWC is a result-driven management consulting firm headquartered in the Seattle metropolitan area. We specialize in best-fit consulting based on client needs. We have an active role that we are looking to assist our premier client with and are looking for an experienced consultant with the right set of values. For us, personality fit is paramount. We are looking for self-starters who are experienced but flexible in their approach and have a customer-focused outlook. Our consultants go above and beyond, focus on the end goal and do what it takes to deliver the desired results. If you are someone who fits the above job description, then please look at the specific opportunity & let us know why you are a good fit for MoodysNWC

MoodysNWC believes in a culture of diversity, acceptance, and belonging. We are committed to being an equal opportunity employer and hiring without discrimination including based on race, color, creed, national origin, sex, marital status, age, sexual orientation, gender identity, disability, medical status, or veteran status.

Our compensation reflects the cost of labor across several US geographic markets. The salary for this position ranges from $130,000/year in our lowest geographic market up to 160,000/year in our highest geographic market. Pay is based on several factors including market location and may vary depending on job-related knowledge, skills, and experience. Other forms of compensation are offered in the form of medical, vision, and dental benefits.