Power BI Developer- Local to Colorado Job at Centstone, Denver, CO

ZXhVM3dIR2d2UUJwSFVhWkRhaENwdXJGcUE9PQ==
  • Centstone
  • Denver, CO

Job Description

Power BI Developer - Need Locals

Location: Colorado Remote/Hybrid

Duration: 9+ Months

Work Authorization: Open to qualified candidates

Job Summary

We are seeking an experienced Power BI Developer to support a Business Intelligence (BI) program. The ideal candidate will have strong experience in Power BI development, data modeling, DAX, data source connectivity, Power BI Service, and report optimization. The candidate should also be comfortable gathering requirements, collaborating with business and technical teams, and presenting data insights to non-technical stakeholders.

Key Responsibilities Requirements Gathering
  • Collaborate with business users and data analysts to understand reporting, visualization, and data requirements.
  • Identify relevant data sources, attributes, and business logic for Power BI solutions.
  • Analyze and reverse engineer existing Excel-based processes, including complex formulas, pivot tables, and manual data analysis.
  • Recommend process improvements, efficiency enhancements, and logic optimizations.
Data Modeling
  • Design and document conceptual, logical, and physical data models.
  • Develop reusable semantic data models within Power BI.
  • Create and optimize relationships between tables and data structures.
  • Implement row-level and column-level security within Power BI semantic models.
  • Use Tabular Editor Best Practice Analyzer to follow Power BI modeling and DAX best practices.
Data Source Connectivity
  • Connect Power BI to multiple data sources, including:
    • APIs
    • Google BigQuery
    • ArcGIS maps and feature layers
    • SQL databases
    • Excel files
    • Streaming datasets
  • Ensure reliable data extraction, transformation, and integration.
  • Collaborate with integration teams to leverage appropriate integration patterns.
DAX Development
  • Develop advanced DAX (Data Analysis Expressions) formulas.
  • Create calculated columns, measures, and custom calculations.
  • Optimize DAX expressions for performance and scalability.
Report & Dashboard Development
  • Design and develop interactive Power BI reports and dashboards.
  • Build effective visualizations, slicers, drill-through functionality, and interactive reporting solutions.
  • Work with streaming and ArcGIS visuals where required.
  • Analyze and optimize report performance and recommend improvements to the underlying data model.
  • Utilize DAX Studio and Power BI performance tools for troubleshooting and optimization.
Power BI Service & Deployment
  • Publish and manage Power BI reports and dashboards in Power BI Service.
  • Configure access controls and security.
  • Manage automated data refresh schedules.
  • Optimize reports and semantic models for large datasets.
  • Follow established source-control and version-control processes for Power BI files.
  • Utilize Azure DevOps as appropriate for development and deployment processes.
AI & Emerging Technologies
  • Utilize AI tools to enhance reporting, data analysis, and development workflows.
  • Familiarity with Google AI tools is a plus.
Collaboration & Communication
  • Work effectively with cross-functional business, data, integration, and technology teams.
  • Explain technical concepts and Power BI solutions to non-technical stakeholders.
  • Present complex data insights in a clear and understandable manner.
  • Participate in meetings, screen-sharing sessions, working sessions, and backlog discussions.
  • Gather and adapt to changing business and reporting requirements.
Required Skills
  • Strong Power BI development experience
  • Advanced DAX
  • Power BI semantic/data modeling
  • Power BI Service
  • Row-Level Security (RLS) and Column-Level Security
  • Power BI performance optimization
  • DAX Studio
  • Tabular Editor
  • SQL
  • Excel complex formulas, pivot tables, and data analysis
  • Experience connecting Power BI to APIs, databases, Excel, and other data sources
  • Azure DevOps / source control
  • Strong requirements gathering and stakeholder communication skills
Preferred Skills
  • Google BigQuery
  • ArcGIS maps and feature layers
  • Streaming datasets
  • Google AI tools
  • Experience optimizing large Power BI datasets
  • Experience working with enterprise BI programs

Job Tags

Local area, Remote work

Similar Jobs

XLNC Exotic

Truck Driver Job at XLNC Exotic

 ...Job description: Job Description: Owner-Operator Truck Driver (Own Truck Mandatory) Overview We are seeking a skilled and reliable...  ...-trailers, flatbeds, refrigerated trailers, tanker trucks, dump trucks, and roll-off trucks. This role involves delivering freight... 

Thrasher Group

Construction General Laborer Job at Thrasher Group

 ...of $35-$55/hour total compensation . There's no cap, so your earning potential grows with your success! The Role As a construction team member, you will: Learn. Start as an Installer, no experience required. We train you on every tool, every process, every... 

TPD

Senior Geoscientist Job at TPD

Senior GeoscientistSalt Lake City, UtahJoin a leading global mining and exploration organization dedicated to discovering the materials that power modern life and drive economic progress. As a Senior Geoscientist, you will play a pivotal role in identifying high-potential... 

Aloma Healthcare, Inc.

Care Manager Job at Aloma Healthcare, Inc.

Aloma Healthcare, Inc. seeks a talented and experienced Care Managers to join us for a full-time role as an individual contributor. The Care Manager will be responsible for leading patient care teams and ensuring provision of quality healthcare services to all patients.... 

CREOKS Health Services

Licensed Practical Nurse Job at CREOKS Health Services

 ...DescriptionJob DescriptionWe are seeking a part-time dedicated and compassionate Licensed Practical Nurse (LPN) to join our healthcare team. As an LPN, you will play a vital role in providing high-quality patient care and ensuring the well-being of our patients. If...