Regular Schedule: 34 hours per week

A Non-Merit vacancy exists in the Administrative Office.

Non-Merit positions are not classified within the Baltimore County Government Classification and Compensation Plan.

A list of eligible applicants will be established based on the examination as outlined below.

Current and future vacancies occurring in any Office or Department of Baltimore County General Government may be filled from the list of eligible applicants.

All interested candidates must apply at this time.

List all promotions and changes in job duties due to reclassification as separate work experiences on your application. Applicants must include the dates of the promotions and reclassifications.

Note: Failure to complete all fields of the "Work Experience" section of the application will result in your application not being considered. A resume will not be considered in determining your qualifications for a position. Applicants selected for an interview may provide a resume at that time.

You can attach your transcript(s) or license(s) to your application.

Failure to submit proof of Licenses, Certifications and Education will result in your application not being considered. Proof of licenses, certifications, and/or education must be submitted with each application.

DEFINITION OF RESPONSIBILITY
This role will support Baltimore County’s data-driven performance management team, BCSTAT, with analysis and reporting related to the $160 million American Rescue Plan’s Coronavirus State and Local Fiscal Recovery Funds. The Senior Data Analyst designs, develops, tests, and maintains complex operational and analytical reports, using a variety of analysis tools, including GIS based toolsets. This role requires a leader in the data science field, including quality control, peer review, the ability to implement new processes and a knowledge of GIS fundamentals and spatial analysis techniques.

EXAMPLES OF ESSENTIAL DUTIES

• Creates complex reports using tools such as SQL Server Reporting Services, Power BI, and GIS for internal and external use.

• Gathers and documents functional and technical report requirement and translates requirements into reporting solutions.

• Develops in-depth understanding of underlying data, data structures, and business uses to ensure reports meet client needs.

• Leads quality control and peer review processes by reviewing and editing code of junior Report Writers. Creates test cases and works with QA team to ensure accurate and complete testing. Creates technical documentation of report logic and processes.

• Works with developers and analysts to understand code changes that will impact reports. Guides junior Business Intelligence Report Writers in coding and report writing best practices.

• Utilizes and assists in the development of enterprise dataset supporting business analysis and reporting.

• Supports end-user community in the use of business intelligence tools to query databases and files for report outputs. Works within and across functional and technical teams to support the acquisition of new skills and areas of expertise.

• Develops and assists with report training through the development of training tools and training of key staff.

• Hands-on knowledge of SQL Server Analysis Services, SQL Server Reporting Services and Power BI.
• Knowledge of RDBMS systems, data structures, and fundamentals, including data warehouse concepts and principles.
• Knowledge of GIS prinicples, analysis methods, and fundamentals.
• Demonstrated use of GIS tools for data analysis and presentation (both desktop and web based).
• Ability to communicate across all levels within an organization.
• Team player.
• Excellent oral and written communication skills.
• Ability to communicate business needs to technical staff as well as understand customer requirements and design user-friendly reports. Must also have the ability to work independently, and escalate issues and seek guidance as necessary.

• Proficient in the use of SQL Server Analysis Services, SQL Server Reporting Services and Power BI.
• Comprehensive experience with a variety of ETL tools supporting a variety of data manipulation and analysis functions.
• Knowledge of GIS principles, analysis methods, and fundamentals.
• Demonstrated use of GIS tools for data analysis and presentation (both desktop and web based).
• In depth understanding of enterprise data architecture, data design standards and data processes.
• Demonstrated ability to keep current with existing data technologies, through past experience, current work, and interest in professional organizations and workshops.
• Ability to communicate across all levels within an organization.
• Excellent oral and written communication skills.
• Ability to communicate business needs to technical staff as well as understand customer requirements and design user-friendly reports. Must also have the ability to work independently, and escalate issues and seek guidance as necessary.

Education, Training, and Experience
Bachelor’s degree from an accredited college or university in Business, Computer Science, Data Science, or similar field; five or more years of experience working with business intelligence systems. Experience with GIS analysis, Esri data structures and analysis tools is required. (Additional experience may be substituted on a year-for-year basis for the required education to a maximum of two years).

• 
  Experience: Two years of experience in data science, report writing, report development, spatial analysis, and business requirements gathering. One year of progressively responsible experience in data science, data warehouse support activities as well as SQL query development and reports. Experience in performing spatial analysis using GIS tools and datasets.

Employees hired after July 1, 2022 are required to participate in the Baltimore County Employees' Retirement System, with very limited exceptions.

Medical Examination and Employment Background Investigation
Applicants selected for an appointment to a position in Baltimore County must successfully complete a physical examination and drug screen and an employment background investigation, including, but not limited to a criminal background, education, and fingerprint check.

Employment Benefits for Non-Merit or Non-Classified, Part-Time Employees

Baltimore County General Government offers the following benefits to part-time, non-merit or non-classified employees. New employees are eligible for benefits upon hire, unless noted otherwise.

Equal Opportunity Employer
Baltimore County is an equal opportunity employer and encourages minority, female and disabled applicants.

Smoke free workplace
All Baltimore County offices are smoke free.

Drug free workplace
Baltimore County provides a drug free workplace. Prospective employees are required to submit to urinalysis drug testing as part of the pre-employment physical examination.

Employee Assistance Program
Our Employee Assistance Program provides confidential and professional assessment and referral assistance for employees and eligible dependents in the household who are experiencing personal problems that may be affecting work performance, job satisfaction, or overall quality of life.

Health Insurance
In order to qualify for health insurance benefits (medical, prescription, dental and vision insurance), part-time employees must be scheduled for four (4) full work days plus two (2) hours each week.

Health Insurance benefits elected become effective the first day of the month following the date of hire if the employee has completed online enrollment prior to that date. New employees must enroll within thirty (30) calendar days of hire. Plans offered include:

Medical, Prescription, Dental and Vision insurance.

Flexible Spending Accounts
Opportunity to set aside pre-tax dollars, through payroll deduction, for eligible unreimbursed medical care expenses and/or dependent care costs.

Life Insurance
In order to qualify for life insurance benefits, part-time employees must be scheduled for four (4) full work days plus two (2) hours each week.

Employees may elect basic term life insurance for themselves equal to one time the employee's annual salary, rounded to the next higher $1,000. Employees contribute a portion of the premium through monthly payroll deductions. The County also offers an Additional/Employee paid Life Insurance plan with coverage up to $100,000.

Retirement
Employees are required to participate in the Baltimore County Employees' Retirement System, with very limited exceptions.

Paid Leave
Sick Leave - Monthly sick leave earnings prorated based on the number of hours worked per week. No maximum on accrual. Accrued balance can be applied toward service credit at retirement.

Vacation Leave - Monthly vacation leave earnings prorated based on the number of hours worked per week. Earnings increase after five, ten and fifteen years of service generally.

Holidays - Part-time 30 to 39 hour non-merit or non-classified employees will generally be paid for ten holidays per calendar year. Other part-time, non-merit or non-classified employees working 29 hours per week or less will receive two paid holidays per calendar year. These holidays are the Christmas holiday and the Independence Day holiday.

Bereavement Leave
Jury Leave
Military Leave

Baltimore County Employees Federal Credit Union
Membership in Baltimore County Employees Federal Credit Union offers a full range of savings programs, loans, checking, direct deposit, payroll deduction, savings bonds, and other financial services.

Direct Deposit
Payroll through direct deposit to the financial institution selected by employee is required.

Deferred Compensation
Nationwide Retirement Solutions offers a 457 retirement plan allowing for payroll contributions of tax deferred dollars to investment options of your choice.