Business Intelligence Developer

JOB DESCRIPTION
Max Bill Rate:
-***
Role Summary:
-We are seeking a versatile BI Developer to join The Collective. This role is critical in transforming raw data from Snowflake and MS Fabric into actionable executive insights. You will be responsible for the full lifecycle of data deliveryfrom initial requirements gathering with leadership to the engineering of complex data models and the final presentation of high-impact Power BI dashboards. The ideal candidate is a technical powerhouse who speaks the language of business.

Key Responsibilities:
Data Engineering & Architecture
-Fabric & Snowflake Ecosystem: Build and optimize end-to-end data pipelines leveraging MS Fabric (Lakehouse/Warehouse) and Snowflake to support real-time and batch reporting.
-Advanced Modeling: Design, implement, and maintain robust data models (Star Schema) that ensure high performance and data integrity across the organization.
-Optimization: Perform root-cause analysis on slow-running reports; optimize SQL queries in Snowflake and DAX expressions in Power BI to ensure sub-second response times.
Power BI Development
-Visualization Excellence: Design "Executive Grade" dashboards that prioritize UX/UI, ensuring that complex data is digestible and visually compelling.
-DAX & Power Query: Author advanced DAX measures and utilize Power Query (M) for sophisticated data shaping and business logic implementation.
-Security & Governance: Administer Power BI workspaces and implement Row-Level Security (RLS) to ensure data is accessible only to authorized stakeholders.
Leadership & Strategic Partnership
-Requirements Discovery: Lead collaborative sessions with senior leadership to define KPIs and translate business objectives into technical specifications.
-Data Storytelling: Present and demo reports to executive stakeholders, focusing on "the why" behind the data and providing recommendations based on findings.
-Agile Collaboration: Work within Azure DevOps to track stories, manage backlogs, and provide transparency into the development roadmap.
Required Technical Skills:
-Power BI: Expert-level proficiency (DAX, Power Query, Service).
-Snowflake: Experience with SnowSQL, partitioning, and warehouse optimization.
-MS Fabric: Familiarity with OneLake, Data Factory, and the Fabric environment.
-SQL: Expert-level SQL for complex data transformation and validation.
Required Soft Skills:
-Executive Presence: Confidence in presenting to and taking feedback from C-suite leadership.
-Curiosity: A proactive desire to understand the business operations behind the data.
-Clarity: Ability to explain complex technical concepts to non-technical audiences.
Preferred Qualifications:
-Experience with Azure DevOps for project tracking.
-Certification in PL-300 (Microsoft Data Analyst) or Snowflake Pro Core.
-Prior experience in a "client-facing" or "leadership-facing" internal consultancy role.