Database Developer

U.S. Renal Care; Northern (KY); On-site; USD 98,000 - 131,000; Full time

Benefits offered by this job

Medical / Pharmacy

Dental

Vision

Voluntary benefits

401k with employer match

Virtual Care

Life Insurance

PTO

Job summary

U.S. Renal Care is seeking a Database Developer to create and maintain database software, focusing on performance, availability, and enterprise data warehouse alignment.

You will design MS SQL Server SSIS ETL jobs to process high-volume data sources and meet nightly windows, while developing data models for existing systems. Collaborate with analysts and developers to translate business requirements into scalable data structures, SOPs, and documentation.

Qualifications

• 5+ years of experience working with data in a healthcare related field - Clinical and Billing a plus.
• 5+ years of experience writing reports against Microsoft SQL Server databases.
• 2+ years of experience with a source control system (e.g., GIT, SVN, TFS, etc.)
• Strong knowledge and experience writing T-SQL queries and Stored Procedures.
• Experience with SSIS, SSRS, Tableau and other visualization tools, and creating/managing ETL processes.
• Bachelor's degree in Computer Science, Information Systems, Health Care Administration, Business, or equivalent experience, preferred
• Strong ability to quickly understand complicated and highly normalized databases and reporting structures
• Critical thinking and analytical skills

Responsibilities

• Create and maintain database software to meet performance and availability goals.
• Support peers, follow standards, and make technical recommendations.
• Design, develop, and implement MS SQL Server SSIS ETL jobs for high-volume data sources.
• Develop data models for enterprise systems and data warehouses.
• Communicate data modeling and process flow concepts to business stakeholders.
• Build data structures, functions and views for data integration and consumption by other systems.
• Prepare documentation and SOPs for future use.
• Learn new applicable programming techniques as needed.
• Work with developers/analysts and customer support as needed.
• Be available to address critical software issues as they arise.
• Write documentation for ETL processing and database applications.
• Investigate new technology initiatives to enhance database capabilities.

Skills

Analytical skills

Critical thinking

Data modeling

Education

Bachelor's degree in Computer Science, Information Systems, Health Care Administration, Business, or equivalent experience

Tools

SSIS

SSRS

Tableau

ETL processes

Git/SVN/TFS

Job description

Responsibilities

The Database Developer will be responsible for creating and maintaining database software to meet functional, performance, and availability goals. Additionally, the developer will be expected to support peers, follow standards, and make technical recommendations.

Essential Duties and Responsibilities include the following. Other duties and tasks may be assigned.

• Perform in an independent capacity and set a strong example for other database developers.
• Responsible for the development and management of Enterprise Data Warehouse / Data Lake processes and policies, following strategic direction on best practices for holistic Data Architecture.
• Design, develop, and implement MS SQL Server SSIS ETL jobs to effectively process high-volume data sources and meet nightly processing windows.
• Conduct analysis and design of data models for the development and maintenance of existing enterprise systems.
• Monitors industry trends and directions and develops and presents substantive technical recommendations to management.
• Work with users to define, implement and automate data warehouse requirements based on Microsoft SQL BI Stack.
• Build data structures, functions and views for source data integration, data management, and consumption by other systems
• Ability to communicate data modeling and process flow concepts, while tailoring solutions to business requirements
• Ability to interpret business logic and develop appropriate dataflows and data dependencies
• Understand and design system integration as required for extracting data for reporting purposes
• Ability to work with and communicate with a team of Developers/Analysts and non-technical Business Stakeholders.
• Design databases and ensure stability, reliability, and performance.
• Develop, test, and maintain Microsoft SQL database objects for USRC software.
• Refactor existing database objects to support enhancements of system control, diagnostic and other research subject areas.
• Investigate and support new technology initiatives to improve or enhance current database capabilities.
• Prepare documentations for database applications and ETL processing.
• Learn new applicable programming techniques as needed.
• Work with other database personnel, front end programmers and customer support as needed.
• Be available, as needed, should critical software issues arise.
• Write documentation and SOPs for future use.
• Experience with
  • SSIS,
  • SSRS,
  • Tableau and other visualization tools,
  • Creating and managing ETL processes
• Bachelor's degree in Computer Science, Information Systems, Health Care Administration, Business, or equivalent experience, preferred
• Strong ability to quickly understand complicated and highly normalized databases and reporting structures
• Critical thinking and analytical skills

Qualifications

Qualifications/Requirements:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.

Requirements include:

• 5+ years of experience working with data in a healthcare related field - Clinical and Billing a plus
• 5+ years of experience writing reports against Microsoft SQL Server databases.
• 2+ years of experience with a source control system (e.g., GIT, SVN, TFS, etc.)
• Strong knowledge and experience writing T-SQL queries and Stored Procedures (i.e., correlated sub queries, inline SQL....)
• Experience with
  • SSIS,
  • SSRS,
  • Tableau and other visualization tools,
  • Creating and managing ETL processes
• Bachelor's degree in Computer Science, Information Systems, Health Care Administration, Business, or equivalent experience, preferred
• Strong ability to quickly understand complicated and highly normalized databases and reporting structures
• Critical thinking and analytical skills

All Full Time employees are eligible for the following benefits:

• Medical / Pharmacy
• Dental
• Vision
• Voluntary benefits
• 401k with employer match
• Virtual Care
• Life Insurance
• PTO

All Part Time employees are eligible for the following benefits:

• 401k with employer match
• PTO

Pay Range

USD $98,000.00 - USD $131,000.00 /Hr.