ETL Developer / Power BI

Job Description

Job Description – add details here

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 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