This position is responsible for designing and implementing solutions related to business intelligence including reporting, analytics, data modeling and integration, and other business intelligence requests. Present actionable information to help executives, managers and other end users make informed business decisions for the association. Involved in the development, modification and maintenance of data and reports sourced in both relational and analytic databases. Responsible for building new SSRS Reports, Crystal Reports, Charts and Graphs.
Essential Duties and Responsibilities:
Perform full lifecycle of business intelligence development
Maintain the design and development standards for business intelligence
Elicit, document, and analyze reporting needs and requirements. Analyze data and reporting solutions to understand business impact, correlations/discrepancies, and to propose changes/alternate solutions.
Develop and maintain a variety of report types, including but not limited to tabular, drill down, matrix, charts
Work with Report Requester and to evaluate and clarify requests. Evaluate uniqueness of data request and offer alternative solutions where applicable, including non-automated methods of retrieving the requested information
Delivery of report changes, testing, and deployment with adequate documentation in relation with the request for change or additional requirements.
Test and validate reports to insure accuracy and quality
Business analysis of reporting requirements.
Provide technical documentation on the recommendation made and on the modification to existing reports due to the new user requirements.
Preparation of technical and user documentation, as well as production training materials.
Analyze tables to establish knowledge of data for accurate retrieval and use in report writing
Write queries, views, or stored procedures to extract data
Create scripts for importing, exporting, analyzing, mapping and converting data
Monitor performance of reports and taking corrective action to optimize or improve the performance of the reports when necessary
Creation and maintenance of application software within MS SQL Server and web-based reporting environment.
Bachelor’s degree in relevant topic area (e.g. Computer Science) and/or equivalent experience.
1-3 years of experience working with Microsoft SQL Server, Microsoft SQL Server Reporting Services (SSRS), building database queries, stored procedure writing and report creation, charts and graphs.
Expert skills in MS SQL Server & SSRS, Crystal Reports.
Advanced knowledge of Microsoft .Net Framework and ASP.NET web development using C#.
Experience with Microsoft GP
Must have supported various client reports using an AMS and application based on MS SQL Server platform.
Query tuning experience, knowledge of Microsoft SQL Server utilities, functions, procedures, triggers, and RDBMS data modeling.
Database Administration (Indexing, log shipping, DAG) or the willingness to learn
About The Academy of General Dentistry
The Academy of General Dentistry (AGD) is a professional association of more than 40,000 general dentists dedicated to providing quality dental care and oral health education to the public. AGD members stay up-to-date in their profession through a commitment to continuing education.
Founded in 1952, the AGD is the second largest dental association in the United States, and it is the only association that exclusively represents the needs and interests of general dentists. A general dentist is the primary care provider for patients of all ages and is responsible for the diagnosis, treatment, management, and overall coordination of services related to patients’ oral health needs.