ETL Developer / Power BI

247Hire; Burbank (CA); On-site; USD 100,000 - 130,000; Full time

Job summary

247Hire is seeking a Power BI Developer to design and maintain enterprise reporting solutions. The role involves end-to-end dashboard delivery and data integration across systems like Smartsheet, Jira, and SAP.

The ideal candidate will have 7+ years of Power BI experience, strong technical skills, and the ability to manage complex data from various sources, ensuring insights are actionable and trusted.

Qualifications

• 7+ years of experience developing enterprise BI/reporting solutions.
• Advanced expertise in Power BI, including DAX and performance optimization.
• Strong Power Query (M) and SQL skills.

Responsibilities

• Design and develop Power BI reports and dashboards.
• Integrate and transform data from multiple upstream sources.
• Manage the Power BI delivery lifecycle and support governance.

Skills

Power BI (DAX, semantic modeling)

SQL skills

Power Query (M)

Data integration

Problem-solving

Ownership mindset

Education

Bachelor’s degree in Business, Computer Science, Information Systems, Statistics

Tools

Power BI

Smartsheet

Snowflake

SAP

SQL-based sources

Job description

Description

Seeking a Power BI Developer to design, build, and maintain enterprise reporting solutions that enable portfolio reporting within a product-centric operating model. This role will be responsible for the end-to-end delivery lifecycle for dashboards and semantic models (Power BI), integrating data from multiple upstream systems and delivering new reporting solutions as business needs evolve. You will define metrics, implement scalable reporting patterns, and ensure insights are actionable and trusted. Success in this role requires strong expertise in Power BI (DAX, semantic modeling, performance tuning, Dataflows, and deployment practices), an understanding of, and experience working with enterprise products including CoPilot Studio and Power Automate.

Responsibilities

Power BI Development & Dashboard Delivery

• Design, develop, and maintain Power BI reports, dashboards, and semantic models that support portfolio and product decision-making.
• Build and optimize DAX measures, calculated tables, and model relationships to ensure accuracy, scalability, and performance across large, multi-source datasets.
• Translate business questions into clear requirements, metrics definitions, and user-friendly visualizations—balancing technical constraints with executive reporting needs.
• Implement and enforce report/model standards (naming conventions, measure patterns, documentation) to improve maintainability and reduce reporting inconsistencies.
• Proactively identify risks and gaps in data quality, model design, and reporting logic, and drive remediation with upstream system owners.
• Deliver executive-ready insights by designing intuitive experiences (navigation, tooltips, drill-through, bookmarks) that convert complex data into clear narratives.

Data Integration, Transformation & Modeling

• Integrate and transform data from multiple upstream sources (e.g., Smartsheet, Jira, SAP, ServiceNow, Clarity PPM, SQL-based sources), ensuring consistency and reliability across reporting layers.
• Develop robust Power Query (M) transformations and dataflows, and configure gateways/refresh to meet business SLAs.
• Perform performance tuning across models and reports (cardinality management, aggregation patterns, DAX optimization) and troubleshoot refresh or dataset failures.
• Establish and maintain metric definitions and calculation logic to ensure alignment across teams and reduce ambiguity.

Platform Integration, Deployment & Solution Ownership

• Own the end-to-end reliability of the reporting ecosystem, integrating data across Smartsheet, Jira, SAP, ServiceNow, Clarity PPM, Power BI, and related platforms.
• Manage the Power BI delivery lifecycle (dev/test/prod practices, versioning, workspace and app management) and support governance including access controls and certified datasets where applicable.
• Partner with platform and process owners to improve data quality at the source and ensure solutions remain scalable and aligned with the evolving product-centric operating model.
• Build and integrate agentic AI solutions to accelerate analytics workflows (e.g., automated data quality checks, narrative generation, insight triage, and self-service assistant experiences), with appropriate controls and monitoring.

Basic Qualifications

• Bachelor’s degree in Business, Computer Science, Information Systems, Statistics, or a related field (or equivalent practical experience).
• 7+ years of experience developing enterprise BI/reporting solutions, with significant hands-on Power BI development, preferably in an Enterprise Technology organization.
• Advanced expertise in Power BI, including DAX, semantic/data modeling, calculated tables, and performance optimization across large datasets.
• Experience with Power BI administration and delivery practices (workspaces, apps, refresh/gateways, access controls) as applicable.
• Strong Power Query (M) and SQL skills, including data transformation, reconciliation, and troubleshooting of data issues.
• Hands‑on experience with Snowflake, including designing and optimizing cloud-based data warehouses, integrating Snowflake with Power BI and enterprise platforms through scalable ETL/ELT patterns, and supporting high performance, multi-source analytics and data modernization initiatives in partnership with upstream system owners.
• Demonstrated experience integrating data across multiple enterprise systems (e.g., Smartsheet, Jira, SAP, ServiceNow, Clarity PPM, SQL-based sources, custom solutions).
• Proven experience working with imperfect or inconsistent data, identifying root causes, and improving data quality across upstream systems.
• Ability to operate independently in a fast-paced, evolving environment with minimal direction.
• Systems-level thinker with the ability to understand and optimize end-to-end data flows across multiple platforms and tools.
• Strong judgment and problem-solving skills in ambiguous, evolving environments with incomplete or conflicting data.
• Ownership mindset with a track record of taking accountability for outcomes—not just deliverables.
• Ability to challenge assumptions, push back on unclear requirements, and drive alignment across stakeholders.
• Experience in delivering insights that influence strategic decisions.
• Proven ability to translate ambiguous business questions into structured data models, metrics, and insights.

Preferred Qualifications

• Experience with other data visualization tools and proven experience building solutions with agentic AI is preferred.
• Experience with other data visualization tools such as Tableau, Qlik, Looker, or advanced Excel visualization.
• Experience operationalizing AI-assisted analytics or copilots (e.g., prompt/design patterns, evaluation, monitoring, and responsible AI practices) is a plus.
• Proven experience in agentic AI (designing and deploying agentic workflows using LLMs and tools to autonomously plan, execute, and validate analytics tasks) with an emphasis on security, reliability, and human-in-the-loop controls.

Education

BS STEM +5yrs