What are the responsibilities and job description for the BI Developer position at Caravel Autism Health?
We are seeking a highly skilled BI Developer with deep expertise in Power BI to design, develop, and maintain advanced business intelligence solutions that enable data-driven decision-making across the organization. The ideal candidate will have extensive experience with enterprise data modeling, report development, performance optimization, and best practices in BI governance.
Key Responsibilities
Power BI Development & Optimization
- Design, build, and maintain advanced Power BI reports, dashboards, and paginated reports.
- Develop efficient data models optimized for Power BI performance and scalability.
- Implement row-level security (RLS) and governance standards to ensure data integrity and compliance.
- Drive consistent use of KPIs and metrics across business units by maintaining a unified semantic model.
Data Mart Integration
- Collaborate with data engineers to design and maintain reliable data marts and data warehouse layers.
- Ensure data sources are structured for efficient refresh, query performance, and data accuracy.
- Write and optimize SQL queries and transformations to support reporting and analytics needs.
Documentation & Standards
- Maintain detailed documentation of Power BI datasets, reports, and data lineage.
- Manage and catalog reports, dashboards, and data sources in a centralized inventory.
- Develop and enforce BI standards, naming conventions, and best practices.
Cross-Functional Collaboration
- Partner with stakeholders across Operations, Finance, Marketing, and other business lines to define and refine KPIs, metrics, and dashboards.
- Translate business requirements into effective, scalable BI solutions.
Continuous Improvement
- Monitor and troubleshoot Power BI refreshes, gateways, and performance issues.
- Stay current with Microsoft Fabric, DAX enhancements, and Power BI roadmap developments.
- Recommend and implement improvements to BI workflows, governance, and automation.
Qualifications
- Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field.
- 5 years of experience in BI development, with expert-level proficiency in Power BI.
- Strong skills in DAX, Power Query (M), and SQL.
- Experience with semantic modeling, DirectQuery, and large dataset optimization.
- Knowledge of data warehousing concepts, star/snowflake schema design, and dimensional modeling.
- Excellent communication skills and ability to work cross-functionally with technical and non-technical stakeholders.
Salary : $95,000 - $125,000