Colorado State SQL Report Developer/Database Manager in Denver, Colorado
SQL Report Developer/Database Manager
SQL Report Developer/Database Manager
$4,693.00 - $7,500.00 Monthly
Department of Law
9/25/2020 11:59 PM Mountain
Find a rewarding career making a difference: Join the Office of the Attorney General!
If your goal is to advance your career in a State agency dedicated to serving Colorado and its people, consider joining the Office of the Attorney General! The SQL Report Developer/ Database Manager position is a great opportunity to develop your report writing and database skills as well as the opportunity to learn industry specific technology tools. You'll work as part of a small team supporting application development for end users in the Department of Law/Office of the Attorney General. If you're drawn to public service and a stable work environment, we invite you to submit an application so we can learn more about you!
The Office of the Attorney General/Department of Law is committed to serving as the "People's Lawyer." The Attorney General, Phil Weiser, was elected by the people of Colorado and is the State's chief lawyer and law enforcement official. Our purpose is:
"Together, we serve Colorado and its people, advancing the rule of law, protecting our democracy and promoting justice for all."
Our core values drive our actions and demonstrate that we are:
Principled – maintain highest ethical standards, rigorous legal analysis, careful evaluation of facts
Public Servants – ensure our work is not about us, it's about the people of Colorado
Innovative – identify the best approach, make deliberate decisions, always look to improve
Better Together – support each other, partner with others
The Attorney General has primary authority for enforcement of consumer protection and antitrust laws, prosecution of criminal appeals and some complex white-collar crimes, the Statewide Grand Jury, training and certification of peace officers, and most natural resource and environmental matters. The Attorney General serves as counsel to all state officials, departments, boards and commissions. Visit our website to learn more: https://coag.gov/.
In addition to the challenging and impactful work being done at the Office of the Attorney General, there are many other benefits to joining our team:
Medical and dental health plans
Employer-paid life insurance
Paid vacation and sick leave earned each month
10 paid holidays per year
Public Service Loan Forgiveness – A borrower may qualify for forgiveness by making 120 on-time payments while employed full-time in public service, if they have certain kinds of federal loans in a qualifying repayment plan
Free access to an on-site fitness center
Strong, flexible retirement benefits including 401K and 457 plans
Distinctive career advancement opportunities throughout the State personnel system
Excellent work-life programs, such as flexible work schedules, professional development opportunities, and an employee discount program
To learn more about our benefits visit: https://www.colorado.gov/dhr/benefits.
The Office of the Attorney General/Department of Law is an equal opportunity employer and understands that a diverse work force adds quality and perspective to the services we provide to the public. We encourage candidates with diverse qualities, backgrounds, and abilities to apply.
Description of Job
This position is open only to Colorado state residents.
The SQL Report Developer/Database Manager will support Department of Law reporting needs as well as SQL Server Integration Services, maintain department SQL Database environments and provide Microsoft Access database support.
The position is primarily responsible for providing reporting and data mining services for database applications using Microsoft SQL Server Reporting Services (SSRS), Thomson Reuters ProLaw and/or other reporting tools to access databases and generate data in an actionable form for business unit decision making. The SQL Report Developer/Database Manager will:
Work with end users to gather requirements for reports; design and implement reports with end user input and final approval while maintaining standard DOL reporting parameters; provide feedback on reports usefulness and provide insight on ways to combine reports.
Maintain database reports and troubleshoot access and performance issues working with application developers and network administration staff to determine and address root cause issues.
Provide and maintain a reporting portal for end users to access reports; provide end users training on accessing reports including using parameters for data filtering.
Establish Microsoft SQL Server Reporting services report subscriptions, creating subscription parameters, configurations, and schedules and troubleshooting issues with this technology.
Provide data access and mining via database queries and data extract, transform, and load services; use the TransAct-SQL language to query SQL databases and export that data in a usable form for end users.
Perform analysis of data extracts to assist with business decision making.
As the database manager, the position will support the SQL Server database to include backup and recovery, database development, SQL server tuning, database security, and troubleshooting performance issues. Additionally, the SQL Report Developer/Database Manager will support business needs utilizing MS Access and other products, demonstrating best practices for relational database design; develop complex Excel spreadsheets, reports, ERD diagrams, and work flow diagrams as needed for end user analysis; The position will utilize Visual Basic for Applications (VBA) to develop clear coding for newly developed Access databases, and import and link data from various data sources, such as Excel and other Access databases.
Minimum Qualifications, Substitutions, Conditions of Employment & Appeal Rights
Minimum Qualifications: Please document all relevant experience in detail in the work history section of your application. Experience will not be inferred or assumed. Any part-time experience listed will be prorated. It is in your best interest to be descriptive about your qualifications.
Bachelor's degree from an accredited institution in computer information systems, computer science, management information systems, data science, or other related field AND
one year of professional experience which includes a combination of both 1) providing reporting and data mining services for database applications using Microsoft SQL Server Reporting Services and 2) database management experience including backup, recovery, and troubleshooting performance.
Necessary Competencies: Proficiency with MS Office applications including Outlook, Word, and Excel is required.
Preferred Qualifications: In addition to the minimum qualifications, the preferred applicant will demonstrate:
Experience using Microsoft SQL Server Reporting Services, Thomson Reuters ProLaw and/or other reporting tools to access databases and generate data in an actionable form for business unit decision making
Working knowledge of the integration between SSRS and ProLaw including the effect API's have on reports;
More than one year of professional experience supporting SQL Server databases to include backup and recovery, database development, SQL server tuning, database security, and/or troubleshooting performance issues.
Knowledge and experience with MS Access 2007 or higher
Knowledge and experience with Visual Basic for Applications
Experience working directly with end users to gather requirements for technical projects
Strong interpersonal skills and ability to work as part of a team
Ability to teach technical information to a variety of end users
Strong analytical and problem-solving skills
Conditions of Employment: Applicants must pass a thorough background investigation prior to appointment.
Substitutions: Professional work experience that includes a combination of providing reporting and data mining services for database applications using Microsoft SQL Server Reporting Services AND database management experience will substitute for the required bachelor's degree on a year-for-year basis. A master's degree in computer information systems, computer science, management information systems, data science, or other technology related field may substitute for the the required experience.
Note: Candidates possessing a foreign degree must submit a translation (evaluation) of their degree from an accredited institution, such as The National Association of Credential Evaluations Services in order to be given credit for the degree.
Required Application Materials
A completed State of Colorado Application: Applicants are responsible for ensuring that the application provided is fully completed and clearly describes their education, training and experience as it relates to this position. Only your State of Colorado job application will be reviewed during the initial screening to ensure you meet the minimum qualifications. If you attach a resume and cover letter, those materials will be reviewed in later stages of the selection process. Applications left blank or marked "See Resume" will not be considered.
Cover Letter: A detailed cover letter explaining your interest in the position, any information regarding your skills, qualifications, accomplishments, etc. and how you meet the listed preferred qualifications is due at the time of application.
Current Resume: The purpose of the resume and cover letter, in addition to the job application, is to provide you with an opportunity to fully highlight your experience and skill sets as they relate to the minimum qualifications and preferred qualifications for the job. Note: Failure to include both a resume and cover letter with your application will disqualify you from being considered for this position.
Veteran's Preference: In order to be considered for veteran's preference you must attach a copy of your DD214 forms as well as any documentation required to prove disability or marital status.
Your application will be reviewed by a qualified Human Resources Specialist to determine if you meet the minimum qualifications for this position. If your application does not demonstrate that you meet the minimum requirements, you will not proceed in the selection process for this position. You will be notified of the results of the application review. If your application is rejected and you have questions, you may contact Susie Esparza at email@example.com. You must contact us within two days of the date you receive the application rejection notice.
Colorado Revised Statutes require that all state employees be hired and promoted through comparative analysis of merit and fitness. Upon meeting the minimum qualifications, the next phase of the process is typically a structured application/resume review by a panel of subject matter experts against the job duties and/or preferred qualifications in this job announcement to determine technical competence, depth and breadth of experience and potential job fit.
Technical Competence – Technical experience as it relates to the duties outlined in this job announcement.
Depth and Breadth of Experience – Experience that covers multiple areas outlined in this job announcement and demonstrates the level of responsibility assigned.
Job Fit – Experience will be evaluated to determine how well experience aligns with and meets the business needs of this position. Current experience is preferred.
It is imperative that the "Work Experience" section of your application is complete and specifically addresses your qualifications, experience, work product, and accomplishments as they relate to the Description of the Job, Minimum Qualifications, and Preferred Qualifications as listed above. Resumes and "see resume" statements will not be accepted in lieu of the "Work Experience" section of the application. Upload additional pages if necessary, to fully explain your experience and accomplishments. Failure to include adequate information or follow instructions by the closing date may result in your application not being accepted and/or may affect your inclusion in the final pool of eligible applicants as the materials may be used to identify a top group for additional assessment or establish an eligible list for referral to the hiring manager for final consideration
Appeal Rights: If you receive notice that you have been eliminated from consideration for the position, you may protest the action by filing an appeal with the State Personnel Board/State Personnel Director within 10 days from the date you receive notice of the elimination. If you wish to challenge the selection and comparative analysis process, you may file an appeal with the State Personnel Board/State Personnel Director within 10 days from the receipt of notice or knowledge of the action you are challenging. A standard appeal form is available at www.colorado.gov/spb.
Refer to Chapters 4 and 8 of the State Personnel Board Rules and Personnel Director's Administrative Procedures, 4 CCR 801, for more information about the appeals process. The State Personnel Board Rules and Personnel Director's Administrative Procedures are available at www.colorado.gov/spb.
If you appeal, your appeal must be submitted in writing on the official appeal form, signed by you or your representative, and received at the following address within 10 days of your receipt of notice or knowledge of the action: Colorado State Personnel Board/State Personnel Director, Attn: Appeals Processing, 1525 Sherman Street, 4th Floor Denver, CO 80203, Fax: 303-866-5038. Phone: 303-866-3300. The ten-day deadline and these appeal procedures also apply to all charges of discrimination.
The State of Colorado believes that equity, diversity, and inclusion drive our success, and we encourage candidates from all identities, backgrounds, and abilities to apply. The State of Colorado is an equal opportunity employer committed to building inclusive, innovative work environments with employees who reflect our communities and enthusiastically serve them. Therefore, in all aspects of the employment process, we provide employment opportunities to all qualified applicants without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity or expression, pregnancy, medical condition related to pregnancy, creed, ancestry, national origin, marital status, genetic information, or military status (with preference given to military veterans), or any other protected status in accordance with applicable law.
The Department of Law is committed to the full inclusion of all qualified individuals. As part of this commitment, our agency will assist individuals who have a disability with any reasonable accommodation requests related to employment, including completing the application process, interviewing, completing any pre-employment testing, participating in the employee selection process, and/or to perform essential job functions where the requested accommodation does not impose an undue hardship. If you have a disability and require reasonable accommodation to ensure you have a positive experience applying or interviewing for this position, please direct your inquiries to our ADAAA Coordinator, Julie Christopher, at Julie.Christopher@coag.gov or call 720-508-6511 .