BCSTAT Senior Data Analyst - Non-Merit

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

DEFINITION OF RESPONSIBILITY

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.

EXAMPLES OF ESSENTIAL DUTIES

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. Education, Training, and Experience 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 elevate 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. 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. Proof of Degree Equivalency Applicants who have obtained a degree from outside the United States of America are required to submit degree equivalence documentation from World Education Services, Inc. ( Address ATTN: BCSTAT Senior Data Analyst - Non-Merit Office of Human Resources Baltimore County Government 308 Allegheny Ave. Towson, MD 21204

EXAMINATION PROCEDURE

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. Incumbent Requirements Incumbents must be of good moral character and emotionally stable. Work Schedule 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. #J-18808-Ljbffr Baltimore County, MD