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 allpromotions 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. Examples of Duties DEFINITION OF RESPONSIBILITY This role will support Baltimore County's data-driven performance management team, BCSTAT, with analysis and reporting related to supporting all Baltimore County departments. 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. 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.) 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. Qualifications Education, Training, and Experience Bachelor's degree from an accredited college or university in Business, Computer Science, Data Science, or similar fieldplusthreeor 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. (Additional experience may be substituted on a year-for-year basis up to a maximum of two years for the required education.) 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. (www.WES.org) Mail or deliver documents to: ATTN: BCSTAT Senior Data Analyst 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. Conditions of Employment Employees hired after July 1, 2022 are required to participate in the Baltimore County Employees' Retirement System, with very limited exceptions. 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.