Elevate Patient Financial Solutions has an exciting career opportunity available as a Senior Database Engineer.
JOB SUMMARY
The purpose of this position is to perform SQL Development functions including: design new or enhance existing enterprise database systems, maintain or develop critical databases processes, perform unit and system testing, perform support and help desk tasks. It also requires defining and adopting best practices for each of the SQL development functions as well as visualization and ETL processes. The position is responsible for architecting report solutions using SSRS reports by collaborating with management team. This position is also responsible for architecting ETL functions between a multitude of relational databases and external data files.
ESSENTIAL DUTIES AND RESPONSIBILITIES
• Program in T-SQL with relational databases including currently supported versions of Microsoft SQL Server
• Write high performance SQL queries using Joins, Cross Apply, Aggregate Queries, Merge, Pivot
• Design, develop and maintain Stored Procedures, Functions and Views
• Design normalized database tables with proper indexing and constraints
• Perform SQL query tuning and performance optimization on complex inefficient queries
• Provide guidance in the use of table variable, temporary table, CTE appropriately to deal with large datasets
• Analyze complex queries for any deadlock resulting due to conflicts
• Collaborate with DBA on database design and performance enhancements
• Leading in all phases of the software development life cycle in a team environment
• Debug existing code and troubleshoot for issues
• Design, develop and maintain database processes such as MPower tactics, MPower activity code restrictions and business rules, Agent Jobs, letter, and automated call logic
• Following best practices, translate business requirements into report designs by collaborating with management
• Following best practices, design and develop Microsoft SSRS reports using latest version of Visual Studio and TFS
• Create reports in tabular, matrix, chart, and free-form report layouts
• Use interactive reporting features by providing links to sub-reports and drill-through reports
• Automate report distribution through standard and data-driven subscriptions
• Design and provide a framework for maintaining existing data warehouse for reporting and data analytics
• Following best practices, design, develop, test and document ETL processes
• Develop data cleansing routines utilizing typical data quality functions involving standardization, transformation, rationalization, linking and matching
• Provide best approaches for development and maintenance of SSIS Packages
• Keep up-to-date with the latest database features, techniques, and technologies
• Support current business applications including the implementation of bug fixes as needed
• Able to multi-task and adapt to shifting priorities
• Able to meet deadlines set in project planning
• Effectively communicate progress through the project execution phase
• Follow industry and company standard coding practices
• Produce technical and application documentation
• Test database process feature enhancements and bug fixes
• Produce quality deliverables upon deployment
• Perform application support using third party Help Desk systems
• Assist support analysts with issues they are unable to resolve
• Ensure customer satisfaction by meeting customer needs in a courteous and timely manner
• Mentor junior level SQL developers
• Other duties as assigned.
QUALIFICATIONS AND REQUIREMENTS
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or abilities.
• Minimum 15 years of work-related experience in T-SQL, SSRS and ETL. If candidate has relevant education in computer science, computer information systems, or related field, lack of experience can be supplemented by education as follows:
• Microsoft Certifications – 1 year
• Associate’s Degree – 1 year
• Bachelor’s Degree – 2 years
• Master’s Degree – 3 years
• Experience in developing, maintaining, and supporting database processes using Microsoft SQL Server with emphasis on .NET technologies.
• Proficient at a senior level with the following: T-SQL, SSRS, SSIS, SSAS, Data warehousing, ETL
• Demonstrated ability to perform above listed essential job functions.
Benefits:
ElevatePFS believes in making a positive impact not only within our industry but also with our employees –the organization’s greatest asset! We take pride in offering comprehensive benefits in a vast array of plans that contribute to the present and future well-being of our employees and their families.
- Medical, Dental & Vision Insurance
- 401K (100% match for the first 3% & 50% match for the next 2%)
- 15 days of PTO
- 7 paid Holidays
- 2 Floating holidays
- 1 Elevate Day (floating holiday)
- Pet Insurance
- Employee referral bonus program
- Teamwork: We believe in teamwork and having fun together
- Career Growth: Gain great experience to promote to higher roles
The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to, internal equity, experience, education, location, specialty and training. This pay scale is not a promise of a particular wage.
The job description does not constitute an employment agreement between the employer and Employee and is subject to change by the employer as the needs of the employer and requirements of the job change.
ElevatePFS is an Equal Opportunity Employer