BCSTAT Senior Data Analyst - Non-Merit

This role will support Baltimore County’s data-driven performance management team, BCSTAT, with analysis and reporting related to County operations. 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., * 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.

EXAMPLES OF OTHER DUTIES:

Undertakes projects as assigned. Performs other related duties as required.

(NOTE: The duties and responsibilities listed above are for the purpose of determining a common set of minimum qualifications for all positions in this class. They may not include all of the essential job functions of each position in the class. Each position may not be required to perform all of the essential job functions listed., This position works an average scheduled workweek of 34 hours, Monday through Friday. May occasionally require additional hours, which may include weekends, evenings and holidays. 24 x 7 on call required for production problems.

Do you have experience in Mapping using GIS?, Do you have a Associate’s degree?, Associate’s degree in information technology, computer science, computer engineering, or a related field from an accredited college or university; at least two (2) years of experience working within all or part of the Essential Duties described above, excellent verbal and written communication skills, previous IT experience is required.

(Additional qualifying experience may be substituted on a year-for-year basis up to a maximum of two years for the required education. Additional education in a field listed above may be substituted on a year-for-year basis up to a maximum of two years for the required experience.) Knowledge, Skills, and Abilities (Entry-level)

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

Knowledge, Skills, and Abilities (Full Performance)

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

Proof of Licenses, Certifications and Education Applicants are required to submit proof of licenses, certifications and education beyond high school to meet the required and preferred qualifications of the position. Diplomas or transcripts must show the applicant’s major field of study. Copies and unofficial transcripts are acceptable.

Pulled from the full job description

• Health insurance
• Retirement plan
• Vision insurance
• Dental insurance
• Flexible spending account
• Life insurance
• Employee assistance program, Regular Schedule: 34 hours per week

A Non-Merit vacancy exists in the Office of Information Technology.

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., This position works an average scheduled workweek of 34 hours, Monday through Friday. May occasionally require additional hours, which may include weekends, evenings and holidays. 24 x 7 on call required for production problems. Employment Background Investigation Applicants selected for an appointment to a position in Baltimore County must successfully complete 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. Disclaimer This is only a summary of benefits and policies in Baltimore County. Any benefit or policy may be changed at any time at the discretion of the administration. This summary does not constitute an express or implied contract, nor does it constitute a guarantee that your employment relationship will continue for any specified period of time or end only under certain conditions.