ETL Developer​/Power BI

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.

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

• Integrate and transform data from multiple upstream sources (e.g., Smartsheet, Jira, SAP, Service Now, 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.

• Own the end-to-end reliability of the reporting ecosystem, integrating data across Smartsheet, Jira, SAP, Service Now, 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.

• 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 (work spaces, 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…