Business Intelligence Analyst

At Heartland Family Service, we are committed to building a culture that is trauma informed and values and celebrates diversity and inclusion. We believe this allows for better service delivery and innovation, as it encourages our employees to bring various experiences and uniqueness to the workplace.

Trauma Informed Care is an approach to engaging people with histories of trauma that recognizes the presence of trauma symptoms and acknowledges the role that trauma has played in their lives.  Trauma Informed Care also acknowledges the effects of working with trauma survivors on our workforce and seeks to build collaborative and supportive working environments and relationships.

If you believe in our mission of creating healthy families and communities, and like a fast pace, collaborative and team-oriented environment, then Heartland Family Service is the agency for you. 

SUMMARY DESCRIPTION OF WORK

The Business Intelligence Analyst will work as part of a team of dynamic staff supporting the strategic use of data in a multiservice human services agency with people at all levels of IT comfort and knowledge. The purpose of this technical position is to manage and maintain the agency’s data reporting infrastructure from original data source to a data warehouse and then delivered to data consumers via the agency’s reporting platform. Responsibilities will include data ETL activities, data modeling and validation, report development, and supporting the use of data to achieve agency goals. In additional to technical skill, strong skills in communication, critical thinking, and problem solving are paramount to success in this position, as is the ability to prioritize tasks and collaborate with others.

Compensation: between $48,600 and $61,484 per year (salary is determined upon total years of relevant experience)

Work Schedule: 40 hours per week

Click to see benefits and company perks

MINIMUM QUALIFICATIONS 

• Proficient with Windows environment and standard office productivity software tools.
• Experience with relational databases (Microsoft SQL Server preferred) and data warehouse modeling principles.
• Experience with cloud-based ETL, API, data lake, and data warehouse tools, such as Azure Data Factory, DBT, Snowflake, and Power BI.
• Familiarity with SQL, DAX, M, and Python querying and scripting languages preferred.
• Experience with the Power BI desktop application and online workspace platform for report development, management, and distribution.
• Familiarity with healthcare-based data security standards and regulations, including HIPAA and 42 CFR Part 2, preferred.
• Self-starter and critical thinker with experience troubleshooting and problem-solving technical projects.
• Organized and systematic approach to task and project management.
• Valid driver’s license/ acceptable driving record.
• Bachelor’s degree and two years of relevant experience, or equivalent combination of education and experience, in a business intelligence, data science, information technology, or related field.

Essential Duties and Responsibilities

• Uses cloud-based API and ETL tools like Azure Data Factory, DBT, Snowflake, and Power BI, to manage, refresh, and maintain the agency’s data warehouse and reporting infrastructure.
• Uses querying languages like SQL, scripting languages like Python, and other tools like Power BI or Excel to develop, deliver, and support high quality business intelligence reports. 
• Uses structured project management, agile development, and version control principles and tools to organize project processes.
• Troubleshoots and resolves errors and issues in data flows from original source to end user reports.
• Maintains data security and access control to sensitive data consistent with relevant healthcare and government regulations, including HIPAA and 42 CFR Part 2, agency accreditation standards, including COA, and agency policy and procedures.
• Uses the agency’s Power BI platform to manage report development, delivery, and access, ensure data security, and facilitate a positive user experience.
• Conducts data validation and user acceptance testing to ensure that data and reports are accurate, high quality, and consistent with user needs.
• Collaborates effectively with agency staff, managers, and leadership to define and deliver data reporting projects.
• Supports user adoption of data reports and dashboards through guidance and education to encourage self-service utilization of data.
• Collaborates effective