BCSTAT Senior Data Analyst - Non-Merit

at  Baltimore County MD

EDUCATION, TRAINING, AND EXPERIENCE

Bachelor’s degree from an accredited college or university in Business, Computer Science, Data Science, or similar field plus three or 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.

EDUCATION, TRAINING, AND EXPERIENCE

Bachelor’s degree from an accredited college or university in Business, Computer Science, Data Science, or similar field plus three or 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.

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

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

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.

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.