Job Title: BI Analytics Engineer Company Name: FullBloom Job Details: $100k-$115k/yrRemoteFull,Time Job Url: https://hiring.cafe/viewjob/a58qj6trhk4gy0np Job Description: Posted 6d agoBI Analytics Engineer@ FullBloomView All JobsWebsiteUnited States$100k-$115k/yrRemoteFull TimeResponsibilities:Design schemas, Gather requirements, Develop dashboardsRequirements Summary:5+ years in data modeling, BI, SQL, Power BI; strong DAX; MS Azure; AI fluency; experience with MDM and star schemas.Technical Tools Mentioned:Power BI, DAX, SQL, Azure SQL, Azure Data Factory, MS Azure, Power Platform, Zapier Company Overview: FullBloom is a national leader in child development services, dedicated to helping vulnerable children reach their full potential. Our programs support academic, behavioral, and emotional growth through evidence-based instruction and interventions delivered in schools and behavioral health centers across 42 states. We partner with over 1,100 school districts and serve more than 150,000 children annually. With a workforce of over 12,000 educators and clinicians, FullBloom operates through well-known service lines such as Catapult Learning, SESI, and Little Leaves. Together, we are building a future where every child can thrive. Overview: Overview:We are seeking a data-driven professional to design, develop, and maintain high-performance data models and Power BI solutions. You will serve as the primary link between the business and our data ecosystem, gathering requirements and translating them into iterative, high-impact visualizations. The ideal candidate possesses a deep understanding of relational database concepts and the full BI lifecycle—from SQL-based data extraction to advanced DAX modeling. Responsibilities: Key ResponsibilitiesMaster Data & Dimensional Modeling: Apply expert knowledge of Master Data Management (MDM) to design robust schemas. You must demonstrate a sophisticated understanding of Fact vs. Dimension tables, ensuring proper granularity and relationship cardinality across disparate data sources.Requirement Gathering: Partner with business stakeholders to define KPIs and reporting requirements. Facilitate design sessions to ensure technical solutions align with strategic business goals.Power BI Development: Create interactive dashboards and sophisticated DAX calculations for complex business scenarios.AI Fluency: Leverage generative AI and advanced automation tools to streamline the end-to-end BI development life cycle—including data modeling, complex DAX/SQL query generation, and dashboard UI design—to enhance efficiency and problem-solving speed.Visualization & Dashboard Design: Design and develop intuitive, high-impact visualizations that tell a clear story. You will transform complex datasets into actionable Power BI dashboards, focusing on user experience (UX) and performance optimization.Iterative Testing & UAT: Manage an iterative development cycle, assisting with User Acceptance Testing (UAT) and validating report accuracy against source systems through consistent feedback loops.Data Infrastructure: Utilize SQL for data manipulation and maintain a working knowledge of MS Azure environments to support data ingestion and governance. Qualifications: Core Skills & Qualifications:Experience: 5+ years of professional experience in data modeling, business intelligence, or a closely related analytical role.Data Architecture: Deep understanding of star schemas, including the ability to distinguish between transactional facts and descriptive dimensions to optimize model performance.Power BI & DAX: Advanced proficiency in Power BI Desktop/Service and writing complex DAX expressions.SQL Mastery: Strong ability to write, optimize, and troubleshoot SQL queries for data extraction and validation.MS Azure Knowledge: Familiarity with Azure data services (e.g., Azure SQL or Data Factory) for cloud-based reporting.Preferred Pluses:Financial Statement Literacy: Ability to interpret and analyze financial statements (P&L, Balance Sheet) to build relevant executive dashboards.System Experience: Prior experience modeling data from NetSuite (Accounting/ERP) and/or Microsoft Dynamics (CRM).Integration Tools: Proficiency with Zapier for automating workflows and connecting disparate software applications.Power Platform Expertise: Experience building Model-Driven Apps and utilizing Power Automate to streamline business processes and data flows. Posted Min Pay Rate: USD $100,000.00/Yr. Posted Max Pay Rate: USD $115,000.00/Yr.