What are the responsibilities and job description for the Sr. Data Analyst position at Community Behavioral Health.?
- Family Planning, Fertility, Adoption Benefits
- 403B Retirement Plan
- PTO Days/Sick Days
- Wellness Program
- Employee Assistance Program
- Health, Dental, Vision Insurance
- Medical, Prescription Drug Insurance
- Tuition Reimbursement
- Commuter Benefits
- Flexible Spending
The Sr. Data Analyst plays a key role on the Data Analytics’ Data Warehouse team to define requirements, understand business needs and workflows, and work with various business units to provide Data Analysis, Reporting, Business Intelligence (BI) and Database Backend solutions as needed by the organization.
Community Behavioral Health (CBH) will hold each employee accountable for the following expectations which align with our mission, vision, and corporate code of conduct.
- Perform key responsibilities as detailed in this job description in a dependable, responsible, and positive manner, consistent with all state and federal guidelines.
- Serve as a role model by exemplifying professional behavior, language, skills, and attire in order to promptly and accurately serve the needs of stakeholders, members and their families.
- Assure adherence to CBH policies and procedures so that all work is of the highest quality and delivered in the most culturally competent and cost-effective manner.
- Promote and manage diversity and acceptance within CBH and with all members and stakeholders by honoring and respecting their individuality, dignity and rights.
- Offer suggestions and develop solutions to help promote effective and efficient work processes and innovative programs.
- Actively participate in required meetings and complete all mandatory trainings.
- Maintain high levels of advocacy and member confidentiality to ensure the success of CBH and our mission.
- Assist in assuring both internal and external program integrity by being alert to and reporting suspected instances of provider and employee fraud, waste or abuse.
- Evaluate/learn tools to help inform which tools best suit solutions.
Essential Functions:
- Collaborate with stakeholders to understand, define, and document business questions needs (metrics, dimensions, charts, and dashboards).
- Create and collect feedback on data visualizations (reports/dashboards) to bring insight and answers to business problems/KPIs.
- Serve as primary report writer for all business units.
- Responsible for recurring monthly, weekly, daily, and ad hoc reporting needs.
- Collect and interpret data from multiple sources, both internal & external.
- Develop, create, analyze and distribute management reports as required.
Position Requirements:
- Education: Bachelor’s degree in business, computer science, statistics, mathematics or related field.
- Relevant Work Experience: Minimum of 5 years of experience as a reporting or data analyst, report writer or similar role with a strong understanding of SQL and data modeling.
- 5 years of experience with ETL/ELT development, Data Modeling, Data Warehousing and SSAS preferred
- 5 years of experience with contemporary data visualization technology (i.e.: Power BI.) preferred
- 5 years of experience with Excel preferred
- Healthcare experience is preferred
Skills:
- Extract data and create reports using tools such as SQL, SSIS, SSRS, Excel, or Access
- Ability to tell stories using data & visualizations
- Plan, design and build ETL/ELT solutions for the Data Warehouse in a SQL Server environment
- Knowledge of modern trends, tools and approaches to collection, reporting and visualization
- Excellent written and oral communication skills
- Strong interpersonal skills with a customer service orientation
- Ability to communicate effectively between subject matter experts (SME) and developers to ensure accurate translation of business needs to implementation efforts
- Solid presentation skills for both technical and non-technical audiences
- Excellent training and mentoring skills
- Ability to work independently and in a team environment
- Ability to work under tight project deadlines
- Ability to plan, schedule and organize multiple priorities and high volume of work
Work Conditions:
- Regularly requires walking, standing, stooping, bending, sitting, reaching, pushing, pulling and/or repetitive wrist/hand movements for various lengths of time throughout the day.
- Ability to utilize computers and office equipment to complete daily work responsibilities.
- Requires continuous, normal hearing and vision.
- Regularly works inside in areas that are adequately lighted and ventilated. Some fluctuation in temperature. No protective equipment is routinely needed.
- Must be able to adapt to continuous changes/demands of the job.
Core Competencies:
- Teamwork and Collaboration: Build and sustain relationships with co-workers and stakeholders and support efforts and deliverables. Encourage unity and help remove barriers to productivity and success.
- Respect: Treat each other and our members and stakeholders with respect and sensitivity, recognizing the importance of diversity.
- Member Centric: Focus on the needs of our members by providing value-added services, promoting strong relationships and going beyond basic expectations to achieve the best possible outcomes.
- Honesty and Integrity: Be open and honest in all we do. Maintain the highest level of integrity at all times.
- Commitment to Service Excellence: Challenge ourselves to be forward-thinking and committed to providing total member and stakeholder satisfaction, first-in-class service and high quality, innovative programs.
- Compassion and Empathy: Demonstrate a deep appreciation for another’s situation and point of view. Pay attention to emotional cues, listen effectively and show an exceptional level of caring about each person’s perspectives and circumstances.
- Problem Solving: Build and implement logical solutions to resolving challenges/issues by using individual knowledge and experience while taking resources, constraints and CBH values into consideration.
- Initiative and Self-Directed: Proactively manage time and resources in a way that ensures that all work is done in the most efficient manner while identifying and implementing initiatives without interventions from co-workers, supervisors or stakeholders.
- Flexibility and Adaptability: Adjust approaches and behaviors in order to meet the constantly changing environment head-on and accomplish CBH and individual goals. Strive to adapt to, accept and embrace change within areas of responsibility.
- Communication: Effectively and appropriately share thoughts, ideas and information - both written and oral. Respectfully listen to co-workers and stakeholders to gain a full understanding of issues/situations.
Philadelphia Residency Requirement:
- The successful candidate must be a current Philadelphia resident or become a resident within six months of hire.
U.S. Authorization Requirement:
- CBH does not provide sponsorship for applicants requiring future work authorization. All candidates must be legally authorized to work in the United States without requiring sponsorship now or in the future.
Equal Employment Opportunity:
- We strive to promote and sustain a culture of diversity, inclusion and belonging every day. CBH is an equal opportunity employer. We do not discriminate in recruiting, hiring, promotion, or any other personnel action based on all qualified individuals. This is without regard to race, ethnicity, creed, color, religion, national origin, age, sex/gender, marital status, gender identity, sexual orientation, gender identity or expression, disability, protected veteran status, genetic information or any other characteristic protected individual genetic information, or non-disqualifying physical or mental handicap or disability in each aspect of the human resources function by applicable federal, state, or local law.
Requesting An Accommodation:
- CBH is committed to providing equal employment opportunities for individuals with disabilities or religious observance, including reasonable accommodation when needed. If you are hired by CBH and require an accommodation to perform the essential functions of your role, you will be asked to participate in our accommodation process. Accommodations made to facilitate the recruiting process are not a guarantee of future or continued accommodation once hired.
- If you would like to be considered for employment opportunities with CBH and have accommodation needs for a disability or religious observance, please send us an email at CBH.Recruitment@Phila.gov
Salary : $75,600 - $83,800
