Power BI Designer / Developer

4-7 years relevant experience

Skillsets Required:

Domain 1: Perform Discovery and Determine Scope

Analyze data via SQL queries to assess structure, granularity, quality, and fit for analytics.

Gather, document, and validate detailed business requirements.

Discover, define, and document innovative, actionable analytics and KPIs.

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

Given a scenario, recommend the appropriate analytics delivery method.

Know and understand how and when to recommend Power BI platform, mobile, and Embedded Analytics options.

Domain 2: Evaluate, Prepare, and Connect to Data

Plan and implement Power BI connections to data sources, particularly Cloud data warehouses such as Snowflake, Redshift, Google Cloud SQL, and Azure SQL.

Collaborate with data engineers and architects to prepare efficient data sets aligned with requirements.

Create views and aggregate data sets within Cloud data warehouses such as Snowflake & Redshift.

Data Sourcing, including data connections, settings, queries, and query performance issues.

Clean, transform, and load data.

Domain 3: Plan and Implement Data Models & DAX

Recommend an efficient calculation method ? via Power BI or Data Warehouse.

Analyze and validate results.

Design a data model, including table definitions, relationships, measures, hierarchies, cardinality, granularity, and performance considerations.

Develop a data model, including filtering, calculated tables/columns, and row-level security.

Create measures by using DAX for complex calculations, filters, time intelligence, statistics, etc.

Optimize model performance thru aggregations and other methods.

Domain 4: Design Dashboards and Develop Visualizations/Reports

Plan and implement performance best practices.

Recommend and develop optimal visualizations for insightful, actionable business use.

Design dashboards based on visual analytics best practices and business requirements.

Collaborate with business stakeholders to design and iterate insightful dashboards.

Support User Acceptance Testing (UAT), performance testing (load times), and deployment.

Develop robust visualizations/reports/dashboards with the full range of functionality.

Create dashboards including mobile access, Q&A, data alerts, and other features.

Enrich reports for usability, including drill-through, drilldown, slicers, and exports.

Domain 5: Enable Insightful Analysis & AI

Enhance reports to expose insights through conditional formatting, top N analysis, Quick Insights, etc.

Perform advanced analysis via grouping, bins, AI Insights, and other methods.

Domain 6: Deploy Assets and Maintain Access

Manage datasets including scheduled refreshes, group security, user access, dependencies, etc.

Create and manage workspaces including role assignments, app configuration, pipelines, subscriptions, promotion of content, and lifecycle strategy.

Other Expectations:

• Five years of relevant experience.
• Advanced skills in SQL queries.
• Effective client communications, both written and verbal.
• Data story-telling abilities and analytical curiosity.
• Work independently and/or in a team under time constraints.
• Openness to coaching from team leads/senior consultants.
• Adaptable to changing priorities and client direction.
• Strong attention to detail.

Other Desired Qualifications:

• Microsoft Power BI certifications, particularly PL-300 Data Analyst.
• Strong knowledge of Cloud Data Warehouses ? e.g., Snowflake, Redshift, Google, Azure.
• Python skills in full-stack environments (data preparation to visualizations).

Must have strong communication skills to be able to understand requirements with hands-on reports design/development experience.

The pay range that the employer in good faith reasonably expects to pay for this position is $34.67/hour - $54.18/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis.

Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.

Salary : $35 - $54