• Oversees all stages of the business intelligence cycle including understanding business objective, collecting business requirements and translating them into data requirements. • Designing and developing reports or dashboards (code and visualization). • Scheduling and deployment of business intelligence components in accordance with supplied standards and best practices. • Collaborates with business and technology departments to understand system data and its use. • Monitors production systems for issues and resolves issues or elevate them for resolution when necessary. • Participates in and leads classroom instruction for at least 6 unique courses offered in the Revenue Cycle Course Catalog. • Identifies and provides recommendations to leadership for identified student learning opportunities.

Role Description The Business Intelligence Developer will play a pivotal role in CAI’s internal technology team. Partnering across the enterprise, this role will be instrumental in designing, developing, and maintaining reports, dashboards, and analytical views that enable data-driven decision making across CAI’s business units. We are seeking a highly skilled and experienced BI Developer (Databricks) to join our IT team. This position will be full-time, remote, and is a salaried position. This is a remote position with the requirement to work East Coast hours. What You'll Do - Design, develop, and maintain interactive reports, dashboards, and analytical views in Power BI that support business decision making across CAI’s functional areas. - Build and optimize SQL queries and data views within the Databricks Lakehouse platform to support downstream reporting and analytics use cases. - Collaborate with Data Engineers to understand data models, medallion architecture patterns (bronze/silver/gold layers), and available data assets for reporting purposes. - Partner with business stakeholders to gather reporting requirements, define key metrics, and translate business needs into clear, actionable visualizations. - Perform data validation and quality checks to ensure accuracy and reliability of reports and dashboards prior to stakeholder delivery. - Maintain and enhance existing reports and dashboards based on evolving business requirements, user feedback, and platform updates. - Contribute to the development of standardized reporting templates, naming conventions, and best practices across the BI environment. - Troubleshoot and resolve reporting issues, data discrepancies, and performance bottlenecks in a timely manner. - Participate in code reviews, sprint ceremonies, and team knowledge-sharing sessions to support continuous improvement within the Data & Analytics team. - Document report definitions, data sources, business logic, and technical decisions to maintain institutional knowledge and support team collaboration. - Support end-user adoption by providing training guidance and responding to ad hoc reporting requests as needed. Qualifications - 1–3 years of experience in business intelligence development, data analytics, or a related reporting-focused role. - Hands-on experience designing and developing reports and dashboards in Power BI, including data modeling, DAX measures, and interactive visualizations. - Proficiency in SQL for querying, transforming, and validating data from relational and cloud-based data platforms. - Familiarity with data warehousing concepts including dimensional modeling, star schemas, and ETL/ELT data flow patterns. - Strong attention to detail with the ability to validate data accuracy and troubleshoot reporting issues. - Excellent communication skills with the ability to collaborate across technical and business teams to define and deliver reporting solutions. - Ability to work independently in a remote setting while managing multiple priorities and deadlines. Requirements - Experience working with Databricks, including notebooks, Delta Lake, and SQL analytics endpoints. - Familiarity with medallion architecture patterns (bronze/silver/gold) and Lakehouse design principles. - Experience with Power BI service administration, workspace management, and scheduled refresh configuration. - Exposure to Python for data analysis or automation tasks. - Background in staffing, professional services, or SLED-focused organizations. - Microsoft Certified: Power BI Data Analyst Associate or relevant Databricks certification. - Bachelor’s degree in Business Analytics, Information Technology, Computer Science, or a related field. Benefits - Medical, dental, and vision insurance. - 401k retirement account access. - Paid time off and may also be entitled to paid sick leave and/or other paid time off as provided by applicable law. Physical Demands - Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state, and local standards. - Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc. - Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor.

• Serve as the primary operator of the GCP data environment: BigQuery, Cloud Functions, Cloud Scheduler, and Cloud Storage, in close partnership with IT on security and access • Write and maintain Python-based ETL pipelines pulling from source platforms (Toggl, Rippling, Xero, Salesforce, and others) and landing data in BigQuery • Extend the pipeline portfolio to bring new data sources online and unlock reporting capabilities that do not currently exist • Automate recurring operational workflows currently running manually or locally: scheduled data quality checks, automated exports, and replacing one-off scripts with reliable GCP functions • Own the full Tableau dashboard portfolio across all internal teams: data connections, SQL, refresh schedules, QC, documentation, and bug resolution • Build net-new dashboards for audiences that don't have reliable reporting today, including executive, director, and operational views covering project financials, service line performance, and renewal visibility • Own data integrity within the analytics layer: diagnose whether issues are pipeline problems, dashboard logic problems, or source data issues, and route accordingly • Maintain naming conventions, schema documentation, and dataset organization in BigQuery • Be the first point of contact when a dashboard breaks or a pipeline fails — own resolution, not just escalation • Partner with stakeholders across Business Operations, Finance, People & Talent, Sales, and IT to translate business needs into working data solutions

• Design, develop, enhance, and maintain interactive dashboards, visualizations, analyses, and datasets in Amazon QuickSight. • Build high-performance dashboards optimized for large data volumes, usability, refresh efficiency, and operational reliability. • Develop and maintain curated datasets, semantic reporting layers, and reusable data models that support enterprise reporting needs. • Create standardized dashboard templates, QuickSight themes, KPI definitions, calculated fields, and modular reporting components for reuse across programs and business units. • Implement row-level security, role-based access controls, and governance controls to protect data and ensure proper user access. • Collaborate with business stakeholders, analysts, and technical teams to gather requirements and translate them into scalable BI solutions. • Enable self-service analytics by developing reusable reporting frameworks, documentation, training materials, and user guidance. • Integrate and optimize data sources from AWS services such as Redshift, Athena, S3, RDS, and Glue Data Catalog, and coordinate with data engineering teams to ensure data quality and availability. • Optimize the use of SPICE and direct query approaches to balance dashboard performance, refresh schedules, and cost efficiency. • Monitor and tune query and reporting performance across source systems and datasets and provide recommendations for cost-efficient reporting architectures. • Establish and maintain BI development standards, naming conventions, version control practices, and dashboard governance processes. • Support testing, defect resolution, release activities, and continuous improvement of BI products and analytics services. • Leverage AI-assisted development tools and emerging generative AI capabilities to improve dashboard development, reporting automation, documentation, and analytics delivery while following organizational security and governance standards.