Data Analyst

• Conducts detailed analyses of government operations, programs, and policies utilizing multiple data sources, data transformation techniques, hypothesis testing; synthesizes findings for technical and non-technical audiences
• 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 requirements and translates requirements into reporting solutions, analyses, recommendations
• Interviews stakeholders to understand business processes and design analyses based on operational need
• Develops in-depth understanding of underlying data, data structures, and business use cases to ensure analyses and/or reports meet client needs.
• Develops in-depth understanding of government operations and the translation of data analysis into meaningful strategies, programs, and policies.
• 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.
• Prepares reports, presentations, and visuals for non-technical audiences

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 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 defends complex analyses of operations, policies, and programs using a variety of analysis tools, including GIS based toolsets. The Senior Data Analyst assesses business operations; efficacy of government programs, initiatives, policies, and projects across departments; and presents findings to stakeholders throughout Baltimore County Government. 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. This role requires creative problem solving, the ability to work with a wide range of subject matter, and experience with qualitative, quantitative, and/or policy analysis., Bachelor’s degree in data science, data analytics, 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. At least six (6) months previous work experience involving analysis or evaluation is required. Additional previous experience in data analysis, research, program evaluation or similar preferred.

(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)

• Attention to detail and excellent investigative skills.
• Knowledge of experimental design, hypothesis testing, and evaluation.
• Ability to communicate across all levels within an organization.
• Team player.
• Excellent oral and written communication skills.
• Knowledge of government and civics.
• 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.
• Ability to communicate with technical as well as non-technical staff and design user-friendly reports, visualizations, and presentations.
• Must have the ability to work independently and escalate issues and seek guidance as necessary.

Knowledge, Skills, and Abilities (Full Performance)

• All aspects described in entry-level section, above.
• Ability to evaluate the efficacy of programs, policies, and operations and identify opportunities for efficiency and improvement.
• Ability to translate data analysis into meaningful, actionable recommendations for policy and/or government operations.
• 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.
• 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 effectively and with minimal guidance.
• Excellent oral and written communication skills.

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.

Applicants will be qualified based on an evaluation of their training and experience, as stated on their application. Applicants must state the dates and duties of past and present experience clearly and completely for evaluation purposes. Conditions of Employment Incumbents must be of good moral character and emotionally stable.

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