Overview
We are seeking a dynamic and highly skilled Senior Power BI / SAP Datasphere Technical Lead to drive the design, development, and implementation of advanced business intelligence solutions. In this pivotal role, you will lead cross-functional teams to craft scalable data architectures, optimize data management processes, and deliver insightful analytics that empower strategic decision-making. Your expertise will be instrumental in integrating diverse data sources, leveraging cloud technologies, and ensuring high-performance data solutions that meet evolving business needs. Join us to shape innovative data strategies and elevate our analytics capabilities to new heights!
Role: - Senior Power BI / SAP Datasphere Technical Lead
Location: - San Diego, CA
Client: - Port Of San Diego
Job Description:
Education/ Certification Mandatory:
· Bachelor’s degree in Computer Science, Information Technology, Information Systems, Data Analytics, Business Analytics, or a related field; equivalent combination of education, professional certifications, and extensive relevant experience may be considered.
Work Experience Mandatory:
· 10+ years of overall BI/Analytics experience; 7+ years of hands-on Power BI development; 3+ years working with SAP BW and BEx Queries; demonstrated experience with SAP Datasphere; proven experience with SAP BW/BEx-to-SAP Datasphere, BW-to-HANA, or comparable SAP analytics migration; advanced DAX, Power Query/M, data modeling, reconciliation, and performance optimization experience.
Education/Certifications Nice to Have:
· Relevant certifications preferred/required for verification where applicable, including Microsoft Certified: Power BI Data Analyst Associate (PL-300), Microsoft Certified: Fabric Analytics Engineer Associate (DP-600), SAP Datasphere certification, SAP BW/4HANA certification, SAP HANA Data Modeling certification, or equivalent relevant professional certifications. Copies or verifiable evidence of any claimed certifications must be available upon request.
Work Experience Nice to Have:
· Prior experience with a public agency, port authority, municipality, or special district; SAP Analytics Cloud experience; Power BI performance optimization against SAP sources; DirectQuery vs. Import trade-off analysis; Power BI deployment pipelines; source control using PBIP/TMDL; familiarity with California Public Records Act implications
References/Certificates/Diplomas Required:
· No specific references, certificates, or diplomas are explicitly required; however, candidates must provide verifiable evidence of any education, certifications, and relevant experience claimed on their resume upon request.
Roles And Responsibilities:
· Review, analyze, and document existing Power BI reports and dashboards, including their SAP BW InfoProvider, BEx query, data connection, transformation, and dependency structures.
· Assess the technical complexity of each report and develop a structured migration and conversion approach, including effort estimates, risks, assumptions, and dependencies.
· Lead the end-to-end technical delivery of the SAP BW/BEx to SAP Datasphere migration for the Port's Power BI reporting portfolio.
· Repoint existing Power BI reports from legacy SAP BW/BEx data sources to Port-provided SAP Datasphere Graphical Views (GVs).
· Analyze and rebuild report functionality that does not automatically carry forward during the source migration.
· Rebuild and optimize complex business logic using Advanced DAX and Power Query/M, including calculations, restricted and calculated key figures, query variables, default values, hierarchy handling, exception aggregation, and currency or unit conversions, as required.
· Update and optimize data transformations, field mappings, data models, relationships, measures, calculated columns, filters, slicers, Row-Level Security (RLS), and report visualizations.
· Lead the conversion and remediation of complex, high-impact, and multi-source Power BI reports and dashboards.
· Perform detailed data validation and reconciliation between legacy SAP BW/BEx outputs and the converted SAP Datasphere-based reports at the row, aggregate, and filtered-view levels.
· Identify, investigate, document, and resolve data discrepancies, conversion issues, functional defects, and performance concerns.
· Coordinate closely with the Port's Business Intelligence Analyst and SAP Datasphere modeling team to address source-data issues, Graphical View dependencies, and technical defects.
· Provide technical leadership, mentoring, guidance, and quality oversight to supporting Power BI developers assigned to the engagement.
· Conduct technical and quality reviews of converted reports to ensure accuracy, functionality, performance, maintainability, and alignment with business requirements.
· Support system testing, user acceptance testing (UAT), defect remediation, and final validation of all converted reports.
· Develop new Power BI reports and dashboards in accordance with Port requirements and approved technical standards.
· Modify and enhance existing Power BI reports and dashboards to accommodate evolving business and operational requirements.
· Optimize Power BI datasets, data models, DAX calculations, queries, refresh processes, and report performance.
· Support and maintain Power BI technical components, including gateways, dataset refresh, deployment pipelines, workspace configuration, and Row-Level Security, as required.
· Maintain comprehensive conversion tracking documentation, technical design artifacts, discrepancy logs, validation evidence, and implementation records.
· Ensure compliance with applicable Port IT security, data handling, access control, change-management, and governance requirements.
· Support knowledge transfer and develop sufficient technical documentation to enable Port staff to maintain and support the converted Power BI reporting environment.
· Provide technical leadership throughout the engagement by developing effort estimates, identifying delivery risks, recommending mitigation strategies, and advising on technical decisions.
Required Technical Experience and Expertise
The ideal candidate should possess strong hands-on experience in:
· SAP BW and BEx Queries, including InfoProviders, InfoCubes, DataStore Objects, InfoObjects, attributes, and BEx query components.
· SAP Dataspherz, including Spaces, Graphical Views, semantic modeling, associations, and consumption of Datasphere data through Power BI.
· Microsoft Power BI Desktop and Power BI Service, including enterprise report and dashboard development.
· Advanced DAX, including measures, calculations, time intelligence, context transition, and performance optimization.
· Advanced Power Query / M, including query folding, parameterization, error handling, and data transformation patterns.
· SAP BW/BEx-to-SAP Datasphere migrations, or comparable SAP analytics source migrations involving the repointing and validation of downstream Power BI reports.
· Data reconciliation and validation, including comparison of legacy and converted reports and investigation of numerical discrepancies.
· Power BI data modeling, including star schema design, relationships, cardinality, role-playing dimensions, composite models, and aggregations.
· Power BI performance tuning and optimization, particularly when working with SAP data sources.
· Power BI gateways, dataset refresh, deployment pipelines, workspace management, and Row-Level Security (RLS).
Core Technical Requirement
· The selected resource must be capable of managing the complete end-to-end report conversion lifecycle, rather than simply changing or repointing data connections.
· The candidate must have the technical capability to analyze existing SAP BW/BEx report dependencies and determine which business logic must be rebuilt within the Power BI environment.
· This may include rebuilding BEx calculations, restricted and calculated key figures, variables, hierarchies, exception aggregation, transformations, and other reporting logic using DAX and Power Query/M.
· The candidate must also be able to validate and reconcile the converted Power BI reports against the legacy SAP BW/BEx environment, investigate and resolve discrepancies, and ensure that the final SAP Datasphere-based reports meet the required standards for accuracy, functionality, performance, and maintainability
Pay: $65.00 - $75.00 per hour
Application Question(s):
- Are you a U.S. Citizen?
- Have you worked directly for the Port of San Diego or one of the following related public agencies: City of San Diego, County of San Diego, SANDAG, San Diego County Water Authority, San Diego County Regional Airport Authority, MTS, NCTD, Caltrans, or another San Diego-area public agency?
- Please identify the San Diego-area public agency/Port-related organization where you gained your experience and briefly describe your role.
- How many years of hands-on Power BI development experience do you have?
- How many years of hands-on SAP BW and BEx Query experience do you have?
- How many years of hands-on SAP Datasphere experience do you have? Please describe your experience with Spaces, Graphical Views, semantic modeling, and Power BI integration.
- Have you personally performed or led an SAP BW/BEx-to-SAP Datasphere migration involving existing Power BI reports?
- Do you have hands-on experience rebuilding complex BEx/business logic using Advanced DAX and Power Query/M, including calculations, variables, hierarchies, exception aggregation, and transformations?
- Have you performed row-level, aggregate-level, and filtered-view reconciliation between legacy SAP BW/BEx reports and converted Power BI/Datasphere reports?
- Do you have hands-on experience optimizing Power BI performance against SAP data sources, including DAX, data models, queries, DirectQuery/Import, and refresh performance?
- Are you currently located in the San Diego, CA metropolitan area or within reasonable commuting distance to the Port of San Diego?
Work Location: In person
