What are the responsibilities and job description for the Business Intelligence Specialist (Closes 2/28/2025) position at Allegheny County Department of Human Services?
At Allegheny County Department of Human Services (ACDHS), our mission is to improve the welfare of the County’s most vulnerable residents. We operate, influence, and fund essential services worth over $1 billion that more than 200,000 residents depend on each year, including treatment for mental health and addiction, homeless housing, and child and older adult protective services. Over the past 20 years, we have built a national reputation for being on the cutting edge of state and local governments using analytics and technology to deliver more effective and efficient public services. Above all, we are convinced that there remain significant opportunities for data and technology to improve the lives of our clients.
The Business Intelligence (BI) Specialist supports Tableau Desktop and Server users by aiding in creating, publishing, and troubleshooting analyses. This role acts as a bridge between data engineers and analysts, focusing on configuring, monitoring, and upgrading BI platforms, developing governance policies, maintaining automation, and delivering training. This BI Specialist should also exhibit an interest in public service and promote effective data usage for decision-making.
Essential Duties and Responsibilities Tableau Administration and Development
- Troubleshoot Tableau Desktop and Server issues, submitting support tickets as needed.
- Refine best practices for analyst workflows.
- Automate Tableau Server processes using Python, PowerShell, REST API, and GraphQL.
- Administer Tableau Server sites and build dashboards using PostgreSQL data.
- Configure, test, and deploy new data pipelines.
- Deliver training on Tableau features and best practices.
Rundeck Administration
- Configure and monitor Rundeck services for capacity and performance.
- Troubleshoot issues and collaborate with support to resolve them.
- Maintain Rundeck logs and performance metrics.
- Assist in evaluating and configuring Rundeck runner architecture.
Power BI Support
- Develop Power BI workflows and governance.
- Provide support for Power BI analysts in creating visualizations and troubleshooting issues.
Other Responsibilities
- Support Identity Access Management (IAM) tools, such as Okta and Microsoft Entra ID.
- Conduct training sessions to encourage BI tool adoption.
- Assist in automating ETL and other jobs in Rundeck.
- Contribute to cross-functional initiatives and support evolving organizational needs as required.
Knowledge, Skills, and Abilities
- Expertise in Tableau, including Tableau Server and Desktop.
- Familiarity with relational databases (Oracle, SQL Server) and SQL scripting.
- Understanding of data modeling techniques and visual reporting best practices.
- Experience with Python, PowerShell, and automation tools.
- Strong analytical, organizational, and communication skills.
- Ability to multitask, work independently, and adapt to changing priorities.
Job Location
This is an onsite, office position based at the Allegheny County Department of Human Services in downtown Pittsburgh, PA.
Education and Experience Requirements
- Bachelor’s degree in a related field with 2 years of experience in human services programs.
- At least 1 year of experience with Tableau and SQL.
- Experience with Power BI, Rundeck, and Docker is a plus.
- Equivalent combinations of education and experience are acceptable.
Preferred certifications:
- Tableau Desktop Specialist
- Tableau Certified Data Analyst
- Tableau Certified Associate
- Tableau Server Architect
Willingness to obtain these certifications is encouraged.
Why Allegheny County DHS?
- It is innovative. Most recently, the national attention and awards we’ve gotten are for how DHS integrates data and uses it to improve the safety and well-being of children through tools that support front-line staff in making decisions (using predictive analytics).
- DHS is committed to equity – for our staff, our providers, and community members.
- You can make a big impact here. We stand out as one of the best human services organizations in the country. But we need problem-solvers, innovators, and terrific leaders to make sure we are smart in how we use our funding so that we reach the people who most need our help to make their lives better.
“DHS strives to be the kind of place where a diverse mix of talented people want to come to grow and do their best work.”
- From the organization’s statement on Equity and Inclusion
AN EQUAL OPPORTUNITY EMPLOYER -M/F/V/D
