Summary
The Senior BI Analyst owns and delivers reporting solutions that support the CX organization (Customer Success, Support, Forms Design, Onboarding, and Knowledge and Enablement). This role works independently, end to end, from business requirement through finished, released report, with minimal oversight required from the Senior Manager. Responsibilities include gathering and translating stakeholder requirements into technical specifications, designing data models, building ETL pipelines, developing semantic models, and delivering reports within the Power BI platform. The role also owns the operational side of the reporting function: scoping work, tracking tickets, and coordinating releases.
Key Responsibilities
Report&DashboardDevelopment
- Gatherandanalyzebusinessrequirementsfromstakeholders, translatingthemintotechnicalspecificationsandreportdesignswithinthePowerBIplatform.
- Buildtheresultingreportsanddashboards
- Applyconsistentformatting,naming,anddesignstandardsacrossdeliverables
- DeliveradhocrequestsviaExceloranapplication'snativereportingmodule(e.g.,SalesforceReports)whentherequestdoesn'twarrantaPowerBIbuild.
DataArchitecture&Modeling
- Architectsource-to-targetdatamodelsfornewreportingdomainsusingdimensional/medalliondesignprinciples
- Designsemanticmodelstructure:tables,relationships,andDAXmeasures
ETL&PipelineDevelopment
- BuildandmaintainPowerBIdataflowsacrossBronze/Silver/Goldlayers
- WriteandtroubleshootPowerQuerytransformations
- Developandmaintainmanual/spreadsheet-baseddatamaintenanceprocessesforsourceswithoutadirectsystemfeed
Release&ProcessManagement
- Scopeincomingrequestsintoticketswithclearrequirementsandacceptancecriteria
- Managereleaseschedulingandcoordinatedeploymentofdataflow,model,andreportchanges
- Maintaindocumentationfordatalineage,businesslogic,andknowndataqualityissues
StakeholderCommunication
- GatherrequirementsdirectlyfrombusinessstakeholdersacrosstheCXorganization
- Explaindatalogic,metricdefinitions,andlimitationsinnon-technicalterms
- Flagdataqualityorarchitecturalissuesthataffectmetricdefensibilitybeforetheyreachareport
- Operateindependentlyagainstambiguousorincompleterequirements,makingsoundarchitecturalandtoolingdecisionswithoutrequiringdirectionfromtheSeniorManager
- Provideoccasionaltechnicalguidanceandmentoringtootherteammembers
RequiredSkills
- 5+yearsofexperienceinBIdevelopment,reporting,ordataanalytics,withdemonstratedownershipofend-to-endreportingsolutions
- AdvancedPowerBI(PowerQuery/M,DAX,datamodeling)
- Dimensionalandmedalliondatamodeling
- Semanticmodelgovernance,includingrow-levelsecurityandworkspaceaccessmanagement
- AdvancedExcel(formulas,structureddatamaintenance,pivot-basedanalysis)
- FamiliaritywithSalesforcedatastructures(Cases,Users,Opportunities,orsimilarCRMobjects)
- Experiencewithticket-basedworktracking(Jiraorsimilar)
NicetoHave
- SQLorotherquerylanguagefluency
- ExposuretoAPIsorscriptingfordatapullautomation(AppsScript,PowerAutomate)