EHR Database Report Writer jobs in Fort Collins, CO

Our Database Administrator contributes to the overall mission and values of the City of Loveland's Information Technology Department by providing high quality service, with an innovative perspective, aligning City initiatives with service delivery methods as a partner to users. This is accomplished by configuring, maintaining and supporting the City's relational database client/server software along with creating reports based on data within the City's databases. The position plays a central role in the Information Technology Department's culture of collaboration, coordination and accountability using effective communication and problem solving skills.

The salary range for this position is $100,770 to $141,079 annually, with a hiring range of $100,770 to $120,924 annually.  

This is not a remote work opportunity.  This is an Onsite position. All functions of this job will be performed primarily in office. 

This opportunity will be available until the position is filled, with a first review of resumes on Wednesday, February, 28, 2024.

A current resume is required, and a cover letter is preferred.

This is a great opportunity to be part of a thriving technology team, responsible for a large portfolio of applications that provide support for a broad range of city services.  This position will be the City's primary Database Administrator for the organization's enterprise and departmental applications.  

Our Database Administrator will work across the whole organization, serving a variety of departments and customers, including Finance, Human Resources, Water, Wastewater, Electric, Public Safety, and Pulse, creating a varied and exciting work environment.  

Please view our video Working at Loveland to learn more about our exceptional Loveland community and the benefits of working for the City.

Essential Functions

• Collaborates with other Department representatives to provide technology services Maintains and supports all SQL Server relational databases city-wide through multiple product lifecycle environments, from development to mission-critical production systems.
• Configures and maintains database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Performs scheduled maintenance and supports release deployment activities, often after hours.
• Has experience supporting systems as a technical lead or systems analyst.
• Integrates data from other sources such as MS Access, MS Excel, CSV files, text files, etc. into databases.
• Independently analyzes, solves, and corrects issues in real time, providing problem resolution end-to-end.
• Provides backup and recovery processes on relational databases.
• Performs services such as batch processing, tuning, archiving, installing upgrades to test and production database environments.
• Assist others with complex query development and schema refinement.
• Automates and refines regular processes, tracks issues, and documents changes.
• Maintains database integrity in accordance with City standards.
• Administers database level security.
• Maintains appropriate levels of licensing for assigned software and systems.
• Coordinates contacts with departments, vendors, and/or IT staff regarding database performance, access and security.
• Evaluates user/application needs in relation to database enhancement/modifications and coordinates implementation with staff or vendors.
• Conducts research and performs needs assessments related to databases.
• Recommends database upgrades related to hardware and software.
• Prepares detailed database system specifications and Requests for Proposal requirements.
• Works with IT staff to upgrade existing and install new line-of-business database applications.
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
• Although this position does not have authority to independently approve financial commitments, the incumbent's knowledge, decisions, and recommendations are frequently the basis for the larger financial commitments that are made.
• Performs other duties as assigned.

Qualifications

Education: 4 Year / Bachelors Degree in Information Systems or related field. An equivalent combination of education and or experience may substitute for education requirements on a year for year basis.

Experience:

• 5 years:  MS SQL Server Administration experience.
• 3 years:  Experience developing and maintaining reports in SSRS.

Certifications:  MCTS/MSCA and MCITP/MSCE certifications are desired.

Knowledge, Skills and Abilities

• Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
• Experience with backups, restores and recovery models.
• Ability to develop and support reports created in SQL Server Reporting Services (SSRS).
• Intermediate to advanced knowledge of SQL Scripting Language.
• Ability to code and alter code in SQL.
• Ability to work with, assist and sometimes train other team members in areas related to database structures and SQL code manipulation.
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
• Experience working with Windows Server, including Active Directory, and Windows Updates.
• Experience with Power BI.
• Experience with scripting languages.
• Demonstrated experience in application support up to the Systems Analyst level.
• Experience with Microsoft Access application development.
• Organize and plan work independently.
• Work in a rapidly changing environment, flexible, team player.
• Multi-task and context-switch effectively between different activities and teams.
• Requires solid technical skills, excellent interpersonal and communication skills, and excellent written and verbal abilities.
• Develop and support reports developed in SQL Server Reporting Services (SSRS).

Physical Demands and Working Conditions

• All work performed will primarily be conducted in office or directly with the customer.
• Frequent:  Minimal physical effort typically found in clerical work. Primarily sedentary, may occasionally lift and carry light objects. Walking and/or standing as needed and minimal.
• Frequent: Exposure to routine office noise and equipment.
• Occasional: Exposure to hazards typically found in general office environments where there is rarely to no exposure to injury or accident.

This job description is not designed to contain a comprehensive listing of activities, duties or responsibilities that are required of the employee.

Reasonable accommodations will be made to enable qualified individuals with disabilities to perform the essential functions.

City of Loveland job descriptions are designed to describe the general nature and level of work necessary to perform well in the job; they are not intended to provide an exhaustive list of responsibilities, skills, and qualifications. City of Loveland job descriptions may be updated periodically, and additional activities, duties or responsibilities may be assigned by management as deemed appropriate.

With over 300 days of sunshine, and just 30 miles from Rocky Mountain National Park in the heart of northern Colorado, Loveland is an ideal community for anyone to call home.  Known as the Sweetheart City, this vibrant cultural hub is home to nearly 500 sculptures and public art installations, the world-famous Valentine Remail Program, and picturesque views of the Rocky Mountains.  The community is bustling with a thriving arts, brewery, foodie and shopping scene.  Enjoy headliner concert and theatre productions, professional hockey events, endless community recreation and open space opportunities, art and sculpture shows, and several local festivals.  Loveland also boasts an award-winning golf course and an inclusive library and community center. Loveland, Colorado has EVERYTHING YOU LOVE!

In 2020, Loveland was the only Colorado City to win the Governor’s Award for Downtown Excellence, is the top residential recycling City in the state for 4 consecutive years and has been ranked as one of the top places to live, work and raise a family in the U.S. and as one of the Most Idyllic Picturesque towns in America.

Apply today to join more than 800 employees who work to meet the core values of: Accountability & Integrity, Transparency & Honoring the Public Trust, Collaboration, Innovation, Safety, Excellent Service with Courtesy and Kindness.  The City of Loveland is a diverse and welcoming community organization and our employees enjoy a competitive benefits program, various opportunities for growth and development, and an exceptional work-life balance.

A vibrant community, surrounded by natural beauty, where you belong!

Benefits Information

Benefit Eligible Package Includes:

• Two (2) medical plans, Dental, Vision (for self/ spouse/ children)
• Employee Health & Wellness Center (self/family)
• Paid vacation, holidays, and medical leave
• Flexible spending including Dependent Care
• Life Insurance, AD&D, Short-term and Long-term disability, and voluntary Critical Illness Coverage
• Retirement 401a, 457, Roth (pre-& post tax) and company match
• Comprehensive Employee Assistance Program
• Voluntary 529 College Invest program
• Tuition Reimbursement
• Personal and Professional Development opportunities
• Discounted recreation passes
• Employee recognition program
• Exceptional work-life balance
• Market based pay & regular performance reviews
• Local Government employment is eligible for Public Loan Forgiveness Program

The City of Loveland provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, national origin, sex, sexual orientation, gender identity, disability, genetic information, age, or any other status protected under federal, state, and/or local law.

The City of Loveland participates in E-Verify. In accordance with E-Verify requirements, upon your date of hire the City of Loveland will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S. E-Verify Notice of Participation. Learn more about your right to work. Visit E-Verify.gov for more information.

Employment offers will be conditional on the successful completion of a criminal history background check.