Job Position: Power BI / Salesforce Business Intelligence Developer
Schedule: US Business Hours
Project Overview
We are seeking a hands-on Power BI / BI Developer to build, integrate, and maintain analytical reporting, automated data pipelines, and executive dashboards across Salesforce and underlying billing/operational systems. The developer will work under the technical direction of the CIO to translate business requirements into production-ready dashboards and scalable data models.
Required Technical Skills & Qualifications
- Power BI & DAX: 3–5+ years of dedicated hands-on experience building production Power BI reports, semantic models, and advanced DAX calculations
- Salesforce Data Structure: Strong understanding of Salesforce data architecture (standard and custom objects, SOQL queries, Salesforce reports, and export/sync utilities)
- SQL & Data Transformation: Proficient in SQL and Power Query (M) for data extraction, transformation, data cleaning, and staging
- Security & Administration: Direct experience configuring Power BI Service workspaces, Row-Level Security (RLS), app publishing, and gateway connectivity
- Attention to Detail & QA: Proven track record of reconciling report numbers against source databases to ensure 100% financial and operational accuracy before deployment
Key Responsibilities
- Design, build, and optimize interactive Power BI dashboards, KPI scorecards, and operational reports tailored for leadership and operational teams
- Connect Power BI to Salesforce (Objects, Custom Fields, Reports, and REST APIs/Direct Connectors) to track pipeline, client onboarding, operational queues, and performance metrics
Data Modeling & DAX
- Develop robust star-schema semantic data models, complex DAX measures, calculated columns, and table relationships
Row-Level Security (RLS) & Governance
- Implement role-based and multi-tenant security filters ensuring data confidentiality across internal business units and external client environments
- Configure scheduled incremental data refreshes, manage Power BI Gateway connections, and ensure data hygiene and reconciliation against source systems