Current employees: Please apply through the employee portal to be considered for this opportunity.
Pay Range:
$41.51 - $51.03 HourlyDepartment:
Health DepartmentJob Type:
Regular RepresentedExemption Status:
United States of America (Non-Exempt)Closing Date (Open Until Filled if No Date Specified):
September 03, 2024
The Opportunity:
THIS WORK MATTERS!
As the Reporting - Data Analyst Senior for the Deflection Center, duties will include:
Database and Report Development
Use senior level SQL coding skills, SQL server stored procedure design, back-end database development (mapping relationships between tables, views and queries), and advanced Microsoft SSRS development skills to build complex reports necessary for critical business functions and compliance with funding requirements.
Design and develop complex reports containing advanced formulas and mathematical modeling necessary to comply with Federal regulatory reporting requirements and BHD Management team, County Budget Office, County and State auditors, State Office of Mental Health and Addiction Services, other County departments, and external committees and regulatory agencies.
Develop, review and update analysis of data collection work flows and redesign processes for the Addiction Services Programs.
Provide daily, weekly, monthly, quarterly, semi-annual, and annual data reports to meet requirements of the Addiction Services Programs. Includes using a variety of tools such as SSRS, Tableau and data extracts.
Complex Data Processes
Design, develop, test and implement data processes and reports utilizing CIM data, SQL Queries, and SQL Server Reporting Services (SSRS). This may involve integrating data from MS Access 2003/2007, Excel, and SQL Server databases.
Extract complex information and data from multiple systems across Addiction Services Programs and provide ad-hoc reports and data analysis to meet business needs.
Work as a liaison between the Addiction Services Programs and Decision Support Teams (Evolv Support, Billing Support, and the Reporting Team) in the development, implementation, and maintenance of complex data systems, data extracts and reports.
Identify opportunities for workflow and process improvements to enhance and maximize functionality of the reporting for Addiction Services Programs.
Staff Training
Provide training and team leadership for provider data entry.
Provide technical assistance for provider staff to ensure the accurate, timely and complete entry of all necessary information, and to resolve data related problems.
Assist program staff in data system development and data analysis.
Multnomah County offers an exceptional benefits package, including employer-funded retirement savings; health and dental insurance at very low cost to full-time employees and their dependents; paid parental leave; wellness programs; a focus on work-life balance; and much more. Find more details on our benefits website.
TO QUALIFY:
We will consider any combination of relevant work experience, volunteering, education, and transferable skills as qualifying unless an item or section is labeled required. Please be clear and specific about how your background is relevant. For details about how we typically screen applications, review our overview of the selection process page.
Required Minimum Qualifications:
Education/ Experience:
High school diploma/ GED with seven (7) to ten (10) years of qualifying training and/or experience, OR
Associate’s Degree with three (3) to six (6) years of experience that demonstrates the ability to perform the duties of the position.
Other:
This position requires a background investigation, which may include being fingerprinted.
Preferred Qualifications/ Transferable Skills*: You do not need to have the following preferred qualifications/ transferable skills to qualify. However, keep in mind we may consider some or all of the following when identifying the most qualified candidates. Please clearly explain on your application how you meet any of the following preferred qualifications/transferable skills.
Evolv Reporting, Electronic Health Record (EHR)
Senior SQL coding skills, SQL server stored procedure design, back-end database development (mapping relationships between tables, views and queries), and advanced Microsoft SSRS development skills to build complex reports necessary for critical business functions and compliance with funding requirements.
Power BI
Ability to maintain a safe and healthful workplace.
High degree of resilience, is outcome driven and can thrive in an environment of rapid change while effectively managing pressure in an effective and professional manner.
*Transferable skills: Your transferable skills are any skills you have gained through education, work experience (including the military) or life experience that are relevant for this position. Be sure to describe any transferable skills on your application and clearly explain how they apply to this position.
SCREENING & EVALUATION:
REQUIRED:
The Application Packet: You must submit ALL requested items below. Failure to do so will be deemed as an incomplete application.
1. Attach a Resume demonstrating you meeting minimum qualifications; AND
2. Attach a Cover Letter addressing the following:
Demonstrate your experience working with diverse vulnerable populations; and
How you meet the qualifications for this position
Why are you interested in this position
Note: The application, resume and cover letter should demonstrate your work experience/skills and how it is related to those shown in the ‘Overview’ and ‘To Qualify’ sections of the job announcement. Please be thorough, as these materials will be scored and determine your eligibility to advance in this recruitment process.
The Selection Process: For details about how we typically screen applications, review our overview of the selection process page. We expect to evaluate candidates for this recruitment as follows:
Initial review of minimum qualifications
An evaluation of application materials to identify the most qualified candidates
Consideration of top candidates/interviews
Background, reference, and education checks
Note: Application information may be used throughout the entire selection process. This process is subject to change without notice.
ADDITIONAL INFORMATION:
Type of Position: This represented position is eligible for overtime
Type: Represented
FLSA: Non-exempt
Note: The eligible list created from this recruitment may be used to fill regular, full or part time, temporary, and limited duration assignments for other available Data Analyst Senior positions.
Salary/Pay: Please be advised that the pay range listed for this position is intended to provide general guidance on the earning potential for the role. However, actual compensation will be determined in accordance with the Oregon Equal Pay Law and will take into account factors such as the candidate's relevant experience and education. Candidates should expect that initial offers will be made within the listed pay range and may not be at or near the top of the range.
Our Commitment to Safety, Trust and Belonging: Multnomah County is committed to developing, nurturing and continually improving workforce equity by identifying and addressing the structural and policy barriers to equal employment opportunity faced by our employees and communities. County employees across the organization have stepped forward to develop a strategic plan and help create a workplace where everyone can reach their full potential. Learn more by reading our Workforce Equity Strategic Plan and exploring our Core Competencies for all County employees
Serving the Public, Even During Disasters: Everyday, Multnomah County staff work together to serve as a safety net for our communities. During a disaster, this safety net becomes even more critical. All County employees have a role in serving the public during inclement weather, natural disaster, or other types of community emergency response. During these emergency responses, while typically there begins with a call for volunteers, county employees may ultimately be reassigned from their current position to a role in the emergency response in order to support the critical needs presented by our communities. For more information, please visit the Disaster Service Worker Information page.
Diversity and Inclusion: At Multnomah County, we don't just accept difference; we value it and support it to create a culture of dignity and respect for our employees.
We are proud to be an Equal Opportunity Employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran or protected veteran status, genetic information and other legally protected characteristics. The EEO Know Your Rights poster is available for your reference. Multnomah County is a VEVRAA Federal Contractor. We request priority protected veteran referrals.
Veterans’ Preference: Under Oregon Law, qualifying veterans may apply for veterans’ preference. Review our veterans’ preference page for details about eligibility and how to apply.
Accommodation under the Americans with Disabilities Act: We gladly provide reasonable accommodation to anyone whose specific disability prevents them from completing an application or participating in this recruitment process. Please contact the recruiter below in advance to request assistance. Individuals with hearing or speech impairments may contact the recruiter through the Telecommunications Relay Service by dialing 711.
Questions?
Recruiter:
Jon MarquardtEmail:
jon.m.marquardt@multco.usPhone:
+1 (503) 9888647 x88647Application information may be used throughout the entire selection process. This process is subject to change without notice.
Disclaimer: This announcement is intended as a general descriptive recruitment guide and is subject to change. It does not constitute either an expressed or implied contract.
Job Profile:
6456 - Data Analyst Senior