Job Summary:
The Business Intelligence Analyst works to turn data into information. Under the general supervision of the Business Intelligence/Data Warehouse Manager, the Business Intelligence Analyst oversees and conducts the conversion of data into insights that will lead to informed business and clinical decisions. The Business Intelligence Analyst will work directly with stakeholders and the organizations top management and executives to identify data needs, build the data infrastructure, and necessary reporting tools. The Business Intelligence Analyst will handle multiple tasks simultaneously, prioritize, and work well under pressure within aggressive timelines.

Supervisory Responsibilities:
None.

Essential Duties and Responsibilities:
Collaborate with executives and other business leaders to gather requirements, identify data and reporting needs, and recommend reporting/BI solutions.
Evaluate and understand information gathered from multiple sources including electronic medical records, accounting/finance, payroll, and third-party data.
Design, build, deliver and maintain mission-critical reporting and data visualizations using MS Power BI.
Build predictive models and forecasts that promote data-driven decision making.
Use knowledge of the specific data available, forecasting / analysis methods and visualization capabilities to provide insightful suggestions to business partners.
Work with the DBA and IT Analysts in the development of ETL (Extraction, Transformation and Loading) processes, data modeling, data normalization, and build/maintenance of the data warehouse, data marts, and supporting database system to ensure efficient operation.
Lead/participate in the development of data processes and standards including the data strategy, data governance, and data access and security.
Build self-service tools to allow stakeholders to drill into and analyze data.
Establish quality metrics to measure the integrity, completeness, and correctness of the data.
Create presentations and reports based on insights, recommendations, and findings.
Performs other duties, as assigned.
Must possess a valid Driver’s License from New York, or a contiguous state (i.e., Connecticut, New Jersey, Pennsylvania, and Vermont) OR Must have the ability to take ample public transportation to attend meetings in person in the community and in the office as needed.

Education and Experience:
A High School Diploma or college degree preferred in Computer Science, Management Information Systems, Mathematics, Statistics with a minimum of 3-5 years of experience in a Business Intelligence Analyst, Data Analyst, DBA or similar role.
2 years of experience with SQL; experience with other programming languages (e.g., Python, R, etc.) is a preferred.
2 years of experience of reporting and data visualization skills using MS Power BI; equivalent experience will be considered.
Knowledge of data gathering, cleaning, and transforming tools and techniques.
Understanding of data warehousing and ETL techniques.
Analytical and problem-solving skills.
Proficiency in Microsoft Excel.
Ability to set and meet deadlines.
Ability to work in high-pressure situations.
Technical writing skills.
Excellent attention to detail.
Strong written/verbal communication skills.
Absolute sense of integrity and personal commitment to serving people with I/DD and their families.
Excellent interpersonal, communication organization and demonstrated ability to manage multiple tasks simultaneously.
Ability to work autonomously.
Demonstrate professionalism, respect, and ability to work in a team environment.
Physical Requirements:
Prolonged periods sitting at a desk and working on a computer.