Database Developer

United States Renal Care Incorporated - Plano, TX

Full-time

Plano, TX

Ambulatory Health Care Services

About the position

The Database Developer will play a crucial role in the design, development, and maintenance of database software that meets the functional, performance, and availability goals of the organization. This position requires a proactive approach to database management, ensuring that the systems are robust, efficient, and aligned with the strategic direction of the company. The developer will be expected to work independently while also setting a strong example for other database developers in the team. In this role, the Database Developer will be responsible for the development and management of Enterprise Data Warehouse and Data Lake processes and policies. This includes following best practices for holistic Data Architecture and ensuring that the data systems are designed to handle high-volume data sources effectively. The developer will design, develop, and implement MS SQL Server SSIS ETL jobs to meet nightly processing windows, ensuring that data is processed efficiently and accurately. The position also involves conducting analysis and design of data models for the development and maintenance of existing enterprise systems. The developer will monitor industry trends and directions, presenting substantive technical recommendations to management. Collaboration with users to define, implement, and automate data warehouse requirements based on the Microsoft SQL BI Stack is essential. The ability to communicate data modeling and process flow concepts effectively, while tailoring solutions to meet business requirements, is a key aspect of this role. Additionally, the Database Developer will be responsible for designing databases that ensure stability, reliability, and performance. This includes developing, testing, and maintaining Microsoft SQL database objects for USRC software, as well as refactoring existing database objects to support enhancements in system control and diagnostics. The developer will also investigate and support new technology initiatives to improve or enhance current database capabilities, prepare documentation for database applications and ETL processing, and work collaboratively with other database personnel, front-end programmers, and customer support as needed. Overall, this position requires a blend of technical expertise, analytical skills, and the ability to work effectively within a team to support the organization's data management goals.

Responsibilities

• 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.
• Monitor industry trends and directions and develop and present 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.
• Communicate data modeling and process flow concepts, tailoring solutions to business requirements.
• Interpret business logic and develop appropriate dataflows and data dependencies.
• Understand and design system integration as required for extracting data for reporting purposes.
• 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 documentation 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.

Requirements

• Proven experience in database development and management, particularly with MS SQL Server.
• Strong knowledge of ETL processes and tools, specifically SSIS.
• Experience with data modeling and database design principles.
• Ability to analyze and interpret business requirements and translate them into technical solutions.
• Strong communication skills to work effectively with technical and non-technical stakeholders.
• Experience in developing and maintaining data warehouse solutions.
• Familiarity with Microsoft SQL BI Stack and related technologies.

Nice-to-haves

• Experience with cloud-based database solutions.
• Knowledge of data governance and data quality best practices.
• Familiarity with programming languages such as Python or C# for data manipulation.