(DATA) Business Intelligence Manager

  • Full-time

Company Description

A best-in-class city that attracts best-in-class talent, Philadelphia is an incredible place to build a career. From our thriving arts scene and rich history to our culture of passion and grit, there are countless reasons to love living and working here. With a workforce of over 30,000 people, and more than 1,000 different job categories, the City of Philadelphia offers boundless opportunities to make an impact.

As an employer, the City of Philadelphia values inclusion, integrity, innovation, empowerment, and hard work above all else. We offer a vibrant work environment, comprehensive health care and benefits, and the experience you need to grow and excel. If you’re interested in working with a passionate team of people who care about the future of Philadelphia, start here.

The Office of Innovation and Technology (OIT) oversees most major technology projects for the City of Philadelphia (CoP), ensures continuity of the City's technology operations, and finds new ways to help the public interact meaningfully with technology. OIT uses technology to help City employees do their work better and helps residents get what they need from municipal government.

What We Offer:

Impact - The work you do here matters to millions.

Growth - Philadelphia is growing, why not grow with it?

Diversity & Inclusion - Find a career in a place where everyone belongs

Benefits - We care about your well being

Job Description

The mission of the Department of Behavioral Health and Intellectual disAbility Services (DBHIDS) is to educate, strengthen, and serve individuals and communities so that all Philadelphians can thrive. We work with persons recovering from mental health and/or substance use, individuals with intellectual disabilities, families, and service providers to ensure that high quality services are accessible, effective and appropriate. We are committed to developing a system of care that is data-driven, employs evidence-based practices, promotes cultural competence and eliminates health care disparities.

Data Manager will successfully apply their years of experience in data analysis to support the Associate Director and/or Senior Leadership on any of our myriad of clients within the health and wellness industry. Paramount to this success will be the ability to utilize the many data sources at the disposal of the BI/data team to not only analyze data active in the marketplace, but also the ability to translate these learnings into realistic goals for our teams. 

While every engagement is unique, typical engagements require the person to:
•    Act as Lead Data Manager on studies being conducted in-house, this including, but not limited to query review and generation, database build (design and UAT) and revisions, study metrics, database administration, manual and electronic validations, data transfer specifications and other accompanying tasks.
•    Synthesize the data available into insights/recommendations about the success of our programs in transforming the behavior of our target audience (most likely healthcare professionals, patients/prospects or a combination of the two) while identifying opportunities for program optimization and enhancement.
•    Conduct analytical and statistical study of business processes; synthesize and interpret information to aid fiscal & operational teams effectively. 
•    Perform data exploration, cleaning, and analysis as well as identifying key patterns, trends, and anomalies in the data.
•    Translate complex quantitative and qualitative data as provided by data analysts , into visuals and reports for varying audiences.
•    Provide data management oversight for studies that have been contracted to a vendor, liaising with the vendors on multiple studies of moderate complexity (with minimal supervision or direction).
•    Analyze & study data metrics to continually assess both data quality and study progress; share these metrics and escalate issues whenever necessary for timely resolution of data issues.
•    Assist in tracking and reporting on key performance indicators for programs and projects.
•    Interpret data & analyze results using statistical techniques and provide ongoing reports.
•    Work with departmental staff and agency officials in contract compliance.
•    Provide input to optimize internal processes and documentations, templates and work instructions.
•    Ongoing analysis and preparation of periodic reports on program activities and progress of contracts
•    Prepare regular and special budget reports such as the Business Associate checklist to ensure compliance with the Health Insurance Portability and Accountability Act (HIPAA)
•    Annually and per revisions review and assess provider contracts to determine their level of activity with the City of Philadelphia.
•    Serve as Box Group Admin responsible for creating and monitoring IDS data and information for all its users within IDS office. Box is a cloud application for content and file sharing. DBHIDS utilizes Box to manage content and sharing files securely among the department employees. 
•    Ongoing review and assessment of IDS Scope of Work narratives from contracted providers to insure service compliance with program contract
•    Acquire knowledge of all past and current financial reports. Utilize reporting tools to create interactive customized reports/dashboards to fit the current needs. 
•    Participation internally and externally on committees, cross-systems groups, teams, and initiatives.
•    Establish and maintain a working environment which fosters open communication, collaboration, integration, and teamwork.
•    Performs other duties as assigned

Competencies, Knowledge, Skills and Abilities
•    Ability to use computer software packages, including but not limited to: Microsoft Office and advanced understanding of Excel, moderate to advanced understanding of SPSS or R.
•    ability to use ArcGIS in the Competencies, Knowledge, Skills and Abilities section. Also add Qlik, the department's analytic software.
•    Excellent quantitative and data analysis skills
•    Ability to initiate and drive projects to completion, with minimal guidance.
•    Extremely strong attention to detail and accuracy
•    Strong knowledge and experience with statistics, evaluation, and analysis
•    Excellent written and verbal communication skills with the ability to collaborate and work with others.
•    Ability to prioritize and respond to requests with speed and agility.
•    Ability to effectively communicate theoretical and analytical concepts and findings, both oral and written
•    Knowledge of addiction services network/community resources
•    Knowledge of practices and procedures used in the examination of fiscal documents and records.
•    Knowledge of principles, practices and procedures used in preparing annual program budgets.
•    Ability to gather, correlate and analyze budgets, funding streams, financial allocations and other relevant data.

Qualifications

•    All candidates MUST possess the following: Completion of a bachelor’s degree program at an accredited college or university in the social or behavioral sciences, education, public health, public administration, information management, or related field of study. Experience with performing data analytics, modeling and statistical analyses.
•     Total work experience may be replaced by Master’s level degree in public health, public administration, psychology, law, social work, human services, social policy, or a related field with 5 years’ experience. At least 5 years’ experience working with system coordination and organizational development.
•    We’re seeking an experienced Manager of Business Intelligence/ Data, to ensure our data is best utilized by our department to optimize our performance. You will be an integral part of a cross functional team that ensures the right data is pushed to the right teams in the right way. The ideal candidate knows how to structure data, create useful metrics and present to stakeholders in user friendly ways. 

Additional Information

Salary Range: $85,000 - $95,000

Did you know?

  • We are a Public Service Loan Forgiveness Program qualified employer
  • 25% tuition discount program for City employees (and sometimes spouses and dependents as well) in partnership with area colleges and universities
  • We offer Comprehensive health coverage for employees and their eligible dependents
  • Our wellness program offers eligibility into the discounted medical plan
  • Employees receive paid vacation, sick leave, and holidays
  • Generous retirement savings options are available

*The successful candidate must be a city of Philadelphia resident within six months of hire

Please note that effective September 1, 2021 the City of Philadelphia is requiring all new employees to present proof of vaccination against COVID-19. 

The City of Philadelphia is an Equal Opportunity employer and does not permit discrimination based on race, ethnicity, color, sex, sexual orientation, gender identity, religion, national origin, ancestry, age, disability, marital status, source of income, familial status, genetic information or domestic or sexual violence victim status. If you believe you were discriminated against, call the Philadelphia Commission on Human Relations at 215-686-4670 or send an email to faqpchr @phila.gov. For more information, go to: Human Relations Website: http://www.phila.gov/humanrelations/Pages/default.aspx