Position Overview: 

The Sr. Data Analyst plays a lead role on the Data Analytics’ Data Warehouse team managing and maintaining the agency’s data warehouse systems, ensuring the maximum availability and integrity of its data, and planning for and executing its continuing enhancement. 

Core Expectations: 

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: 

• Hands-on involvement in resolving any data warehouse ETL data or system related issues.
• Work with a team in a lead role capacity developing new data warehouse solutions and updating current data warehouse functions that are brought about by new and changing functionalities of the different data source applications.
• Collaborate with stakeholders to understand, define, and document business questions and needs (metrics, dimensions, charts, and dashboards).
• Create and collect feedback on data visualizations (reports/dashboards) to bring insight and answers to business problems/KPIs.
• Conceptualize and design data models for new business requirements.
• Develop and maintain data exchange solutions with CBH’s business partners.
• Master existing data warehouse databases and associated ETLs, queries, functions, and procedures.
• Champion a standard development and coding process for the data warehouse team 

Position Requirements: 

• Education: bachelor’s degree in business, computer science, statistics, mathematics or related field. 
• License/Certification: N/A
• Relevant Work Experience: Minimum of 5 years’ experience as a data warehouse developer or similar role with a strong working understanding of the Microsoft SQL Server technology.
• 5 years’ experience with ETL, Data Modeling, Data Warehousing and SSAS preferred.
• 5 years’ experience with contemporary data visualization technology (i.e.: Power BI.) preferred.
• 5 years’ experience with Excel preferred.
• Healthcare experience is preferred.

Skills:

• Capability and commitment to fully resolve data, business method and technology issues affecting all ETL and data exchange processes.
• 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. 

Additional Skills required:

• 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.

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