Business Intelligence Analyst (5989)
Summary
On-site Business Intelligence Analyst in Albany, NY serving as the primary reporting/analytics resource for a youth and family services agency. Day to day: build Power BI dashboards and automated reports, write and optimize SQL against systems like myEvolv and Paycom, validate data quality, and explain insights to program leaders under HIPAA-compliant data governance.
Turn Data into Decisions That Support Families
At Together for Youth, we believe children and families do best when the people and systems around them work together.
As a Business Intelligence Analyst, you’ll help our teams understand what their data is telling them and use that knowledge to strengthen the work we do with youth and families. You’ll serve as our primary reporting and analytics resource, partnering with operational and administrative teams to turn complex information into clear, useful insights.
Using Power BI, SQL, myEvolv, Paycom and other enterprise systems, you’ll build reports and dashboards that help leaders understand program needs, identify opportunities and make informed decisions. You’ll work closely with the people who use those insights, listening to their questions and helping them put the findings into practice.
This is an opportunity for an analytical professional who enjoys solving problems, building useful tools and seeing their work support a meaningful mission.
What You’ll Do
- Make data useful. Design, develop and maintain interactive Power BI dashboards, reports and visualizations that answer practical questions for program and agency leaders.
- Bring information together. Write and optimize SQL queries to extract, validate and analyze data from myEvolv, Paycom and other enterprise applications.
- Start with the right questions. Partner with operational and administrative teams to understand their reporting needs, business processes and challenges, then translate those requirements into data models and reporting solutions.
- Help teams see what matters. Identify trends, patterns and opportunities that support operational priorities and longer-term agency decisions.
- Build trust in the numbers. Support data integrity through validation and quality assurance across reporting platforms, with close attention to accuracy and consistency.
- Make reporting more efficient. Build and maintain automated reporting processes that reduce repetitive work and improve the reliability of information.
- Connect insights to action. Explain findings to technical and non-technical colleagues, answer questions and offer recommendations they can use.
- Keep knowledge accessible. Document reports, queries, data sources and reporting processes so others can understand and maintain the work.
- Protect sensitive information. Follow HIPAA requirements and agency data governance policies when accessing, analyzing and reporting protected information.
What You’ll Need
· A bachelor’s degree in Computer Science, Data Analytics, Business Analytics, Healthcare Information Management, Information Systems or a related field.
· Two to four years of experience in business intelligence, data analytics, reporting, business systems analysis or a related role.
· Demonstrated experience developing SQL queries and working with relational databases.
· Proven experience building reports, dashboards and visualizations in Power BI.
· Experience supporting, administering or reporting from an electronic health record system, such as myEvolv, Epic, myAvatar, Credible, athenahealth, MEDITECH or a comparable platform.
· Advanced Microsoft Excel skills, including data analysis and reporting functions.
· Strong analytical, problem-solving and critical-thinking skills, with attention to detail and a commitment to accurate data.
· Ability to explain technical concepts and findings clearly to non-technical audiences and collaborate with stakeholders at all levels.
· Understanding of HIPAA Privacy and Security requirements.
What Will Help You Thrive
- Experience with Tableau or other business intelligence and data visualization tools.
- Experience working with healthcare, behavioral health, child welfare, foster care, human services or related industry data.
- Knowledge of Paycom reporting and workforce analytics.
- Experience with healthcare billing, Medicaid reporting, claims analysis or financial reporting.
- A collaborative approach that starts with listening and turns colleagues’ questions into useful reporting solutions.
- Curiosity, a willingness to learn new systems and the ability to manage multiple priorities as agency needs evolve.