BCSTAT Senior Data Analyst - Non-Merit

Baltimore County•Towson, MD

3d•Onsite

About The Position

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.

Requirements

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
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.
Ability to communicate business needs to technical staff as well as understand customer requirements and design user-friendly reports.
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.
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.

Responsibilities

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.
Undertakes projects as assigned.
Performs other related duties as required.