Title: Senior Information Systems Analyst - Business Intelligence Specialization Location: Alhambra, California, 91803, United States Department: Program Positions Job Description: Salary Range: $10,214.44 - $10,678.10 Monthly SUMMARY The Data & Analytics Unit is responsible for managing, analyzing, and interpreting healthcare data to support decision-making across the Los Angeles County Department of Health Services (DHS). The unit manages patient care and operational data, using analytics to identify patterns, predict outcomes, and improve service delivery. The unit also ensures data integrity, security, and regulatory compliance. ESSENTIAL FUNCTIONS - Builds complex data models for business intelligence solutions consumption and creates dashboards and reports using data visualization tools such as Tableau and Business Objects using those models. - Applies transformations, data cleansing, normalization best practices, as well as abstraction and inheritance programming concepts to ensure quality data solutions - Responsible for eliciting and documenting user requirements for large, highly complex new systems or system enhancements; ensures functional and technical requirements are fully documented. Translates technical tasks to a non-technical audience. - Strong proficiency in ETL (Extract, Transform, Load) processes and tools, data modeling, and data architecture best practices. - Proven experience with big data technologies and frameworks (e.g., Hadoop, Spark, Kafka). - Deep understanding of cloud-based data platforms such as AWS, Azure, Google BigQuery, Oracle Cloud Infrastructure, etc. - Enhance project management processes for enterprise reporting, deep dive analyses, and ad hoc requests leveraging agile framework. - Analyze quantitative and qualitative data to uncover trends and insights, and create dashboards, visualizations, and reports for stakeholders. - Conduct statistical analyses to support program evaluation and strategic planning. JOB QUALIFICATIONS The ideal candidate for the Senior Information Systems Analyst – Business Intelligence Specialization should possess at least 4+ years of experience in analytics, data management, and data intelligence. The Senior Information Systems Analyst is part of the DHS Data & Analytics Unit, who oversees conducting advanced data analyses, responding to complex data requests, and creating data models, dashboards and reports. Strong communication and problem-solving skills are essential to drive collaboration across departments, influence decision-making, and ensure alignment with organizational priorities. Additionally, the ideal candidate should have a proven track record of translating complex data into clear, strategic recommendations and fostering a culture of data-driven decision-making. Education/Experience - Bachelor's degree or higher from an accredited institution in Computer Science, Analytics, Data Science, Information Technology/Systems or a closely related quantitative field. - 4+ years of experience creating complex data models from transactional clinical and operational data for use in interactive business intelligence solutions. - Experience using project management tools and templates, and experience using agile methodology and its application to software and data product development. - Experience developing a variety of stakeholder materials, including but not limited to dashboard reports, concise stakeholder presentations, and staff training materials/guides. Certificates/Licenses/Clearances - Successful clearing through the Live Scan process with the County of Los Angeles. Other Skills, Knowledge, and Abilities - Knowledge of JIRA and Smartsheet is a plus - 4+ years experience at writing and optimizing Transact-SQL code - 4+ years experience with data visualization tools like Tableau and PowerBI, and use of cloud data platforms PHYSICAL DEMANDS Stand: Not applicable Walk: Not applicable Sit: Frequently Handling / Fingering: Constantly Reach Outward: Constantly Reach Above Shoulder: Not applicable Climb, Crawl, Kneel, Bend: Not applicable Lift / Carry: Occasionally - Not applicable Push/Pull: Occasionally - Not applicable See: Constantly Taste/ Smell: Not Applicable Not Applicable = Not required for essential functions Occasionally = (0 - 2 hrs/day) Frequently = (2 - 5 hrs/day) Constantly = (5+ hrs/day) WORK ENVIRONMENT Hybrid EEOC STATEMENT It is the policy of Heluna Health to provide equal employment opportunities to all employees and applicants, without regard to age (40 and over), national origin or ancestry, race, color, religion, sex, gender, sexual orientation, pregnancy or perceived pregnancy, reproductive health decision making, physical or mental disability, medical condition (including cancer or a record or history of cancer), AIDS or HIV, genetic information or characteristics, veteran status or military service.

Role Description We are seeking a proactive AI Automation & Business Intelligence Systems Specialist to work directly with the founder in building an intelligent, automated, and scalable business environment. This is a hands-on role focused on: - Power BI development - AI-driven automation - Systems integration - Digital operations support You will design, implement, and continuously improve tools, workflows, and data systems that improve efficiency and decision-making. The role requires strong problem-solving skills, independence, and the ability to work effectively in ambiguity. This is a full-time, non-client-facing position working closely with a senior stakeholder in a remote setup. The ideal candidate is proactive, highly accountable, and able to identify and build improvements independently. This is a foundational role with a strong opportunity to shape how the business operates and scales. Key Responsibilities - Power BI & Business Intelligence - Design and maintain Power BI dashboards (DAX, modelling, reporting) - Build a unified daily business snapshot integrating Microsoft 365, Xero, ProjectManager, and Hubspot (CRM) data - Develop scalable reporting frameworks for performance, financials, and operations - AI Automation & Systems Integration - Design and implement AI-driven workflows and automation systems - Build API-based integrations across business platforms - Identify and remove manual processes through automation utilising existing available tools including Microsoft Suite - Automated Intelligence & Reporting - Develop systems that generate daily intelligence on: - Energy markets and pricing - Regulatory and policy updates - Financial and macroeconomic indicators - Grants, funding, and industry activity - Deliver structured automated summaries for decision-making - Executive & Operational Support - Support executive workflows including action tracking, meeting preparation, and documentation automation - Build systems enabling effective business management across desktop and mobile - Project task management support through online ProjectManager application - Establish short AI generated imagery and videos for client proposals utilising company branding guidelines - Microsoft 365 & Systems Optimisation - Optimise Microsoft 365 (Outlook, Teams, SharePoint, OneDrive, Excel, Copilot) - Improve document structure, workflow efficiency, and accessibility across devices - LinkedIn & Market Intelligence - Support LinkedIn as a business intelligence and insight channel - Extract and summarise industry activity, trends, and opportunities - Support posting of pre-prepared content where required - Systems Support & Innovation - Provide remote IT and systems troubleshooting support - Coordinate external technical support where required - Support development of lightweight internal tools and automation prototypes Qualifications - Minimum 3-5 years’ experience in data, business intelligence, automation, or systems integration roles - Strong Power BI experience (DAX, data modelling, dashboards) - Proven experience in AI automation and workflow design - Strong understanding of AI tools including ChatGPT and Microsoft Copilot - Experience with API integrations and multi-platform system connectivity - Strong understanding of data reporting and business intelligence principles - Advanced Microsoft 365 capability - Experience with CRM and business systems (HubSpot, Xero) from a data integration/reporting perspective - Strong analytical and problem-solving skills - Excellent written and verbal English communication - Ability to work independently in a remote, founder-led environment Tool Experience Expectations - Microsoft Power BI – dashboards, DAX, data modelling, reporting (core delivery tool) - Microsoft Excel (Advanced) – data analysis, transformation, and reporting - Microsoft 365 suite – Outlook, Teams, SharePoint, OneDrive - AI tools (ChatGPT / Microsoft Copilot) – automation support and workflow enhancement - API / Integration capability – connecting systems and automating data flows - HubSpot – ability to extract and integrate data for reporting dashboards - Xero – ability to extract financial data and automate reporting dashboards - WordPress – ability to support automation such as website health checks, monitoring, or reporting tools - ProjectManager – client will provide access; no subscription required - Norton – awareness only; no hands-on experience required Preferred/Nice-to-Have - Experience building automated intelligence or monitoring systems (market, regulatory, or financial data) - Exposure to energy, infrastructure, or sustainability sectors - Workflow automation across multiple business systems - Understanding of industrial communication protocols (BACnet, Modbus, CSIP) - Experience in early-stage or small business digital transformation environments - Remote IT or systems administration experience Work Arrangement & Expectations This is a remote role that will be set up as an independent contractor engagement. To ensure alignment and transparency, successful candidates will be expected to: - Disclose any existing ongoing roles or client work - Reflect this engagement on their LinkedIn profile (clearly marked as “Independent Contractor”)

• Support internal specialty team with data analytics and reports. • Manage relationship with venders providing specialty care for specific medical conditions. • Transform monthly payer financial data into standardized accounting format. • Use your skills to make an impact

• Design and develop analytics models and tools to optimize transportation cost, speed, and network performance • Own and enhance key tools including carrier dashboards, routing optimizers, chargeback systems, and cost benchmarking engines • Deliver predictive and real-time reporting on key KPIs such as transit time, on-time delivery, and freight spend • Provide fast, ad hoc decision support with clear focus on business drivers and actionable insights • Collaborate cross-functionally and support automation efforts while contributing to scalable, high-impact analytics solutions