ETL Developer

ETL Developer
Duration: Long Term

Location
Orlando, FL
Burbank, CA

Onsite Expectations: Four days per week onsite.
Schedule Expectations: The candidate must be flexible enough to support stakeholders across multiple time zones.

The discussion highlighted:
East Coast candidates may need to work later hours.
West Coast candidates may need earlier starts.
The goal is reasonable overlap with both coasts rather than extreme schedules.

Interviews:
Most likely: Two interviews
Possible: Up to three interviews

Job Description
The Power BI Developer role is responsible for designing, building, and maintaining 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. Experience with other data visualization tools and proven experience building solutions with agentic AI is preferred

Key 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

Qualifications
Required 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
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 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
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.

Additional Notes:
The conversation explored both technical and business-facing requirements.
Core Technical Requirements Discussed
Power BI development experience
ETL experience
Snowflake knowledge
Reporting platform expertise (future-state need)
Reporting development background