Data Engineer l at PepperPointe Partnerships in Lexington, KY

Summary: PepperPointe Partnerships is a dental service organization focused on improving efficiency in dental practices. They are seeking a Database Engineer I to manage data integration, database maintenance, and support the company's data strategy. Responsibilities: - Develop, support, and maintain SQL jobs and SSMS packages for data imports, exports, and transformations to ensure seamless data integration and workflow automation - Monitor database systems and Airflow for performance and respond promptly to any system outages or disruptions, ensuring minimal downtime and quick recovery - Provide ongoing maintenance of database refreshes, including checking Docker Containers, backups, and performance tuning to ensure data integrity - Design and implement standards for data storage, workflow, maintenance, access, and security administration to protect sensitive information and ensure compliance - Diagnose and resolve system errors and other database-related issues, utilizing a systematic approach to troubleshooting - Run and analyze reports to identify common issues, complaints, and areas for improvement, implementing logging solutions to track issues - Install or update database software to address issues, improve functionality, and ensure compatibility with other systems - Perform other duties as assigned, contributing to the overall efficiency and effectiveness of the Analytics department - Deep understanding of the challenges and trade-offs involved in building and deploying systems to production, ensuring robust and reliable database operations - Highly skilled in identifying performance bottlenecks, detecting anomalous system behavior, and determining the root cause of incidents to maintain optimal database performance - Extensive experience with cloud environments, Windows/SQL Server, PowerShell scripting, Airflow, Linux, and virtualization technologies - Proficient in SQL, ETL processes, and database programming, with the ability to design, implement, index, and maintain efficient data solutions - Knowledge of how Microsoft SQL, Airflow, ETLs, and Dockers all interact - Strong experience with cloud networking, including network connectivity, protocols, load balancing, and related technologies to ensure seamless data flow and access - Comprehensive knowledge of computer systems, hardware, and software, enabling effective integration and troubleshooting - Strong commitment to providing exceptional customer service, ensuring user satisfaction and support - Excellent organizational abilities, ensuring efficient management of tasks and resources - Strong multitasking and time-management skills, with the ability to prioritize tasks effectively to meet deadlines - Proficient in identifying and solving problems, thinking in regards of systems, gathering and analyzing information skillfully, and developing alternative solutions Required Qualifications: - Data warehousing experience - High working knowledge of Database Structures - BASH - Linux - Python - SFTP - Microsoft SQL - Airflow - Docker Containers - API Programming - ETLs - Excellent organizational skills - Critical thinking skills - Proactive in addressing issues and concerns - Innovative methods and processes for greater efficiency and effectiveness - Develop, support, and maintain SQL jobs and SSMS packages for data imports, exports, and transformations - Monitor database systems and Airflow for performance - Provide ongoing maintenance of database refreshes - Design and implement standards for data storage, workflow, maintenance, access, and security administration - Diagnose and resolve system errors and other database-related issues - Run and analyze reports to identify common issues, complaints, and areas for improvement - Install or update database software to address issues, improve functionality, and ensure compatibility with other systems - Deep understanding of the challenges and trade-offs involved in building and deploying systems to production - Highly skilled in identifying performance bottlenecks and determining the root cause of incidents - Extensive experience with cloud environments - Windows/SQL Server - PowerShell scripting - Virtualization technologies - Proficient in SQL, ETL processes, and database programming - Knowledge of how Microsoft SQL, Airflow, ETLs, and Dockers all interact - Strong experience with cloud networking - Comprehensive knowledge of computer systems, hardware, and software - Strong commitment to providing exceptional customer service - Excellent organizational abilities - Strong multitasking and time-management skills - Proficient in identifying and solving problems Preferred Qualifications: - Bachelor's degree in Data Science, CIS, Computer Science, Software Development, Mathematics or a related field - Relevant certifications are highly desirable, including certifications focused on database management - Experience working in a dental or healthcare-related organization - Extensive experience with SQL Server, including SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) - Proficiency in cloud platforms such as AWS, Azure - Experience in cloud database services like Amazon RDS, Azure SQL Database - Strong scripting abilities, particularly in PowerShell - Proven expertise in designing and managing ETL processes - Strong skills in database design, modeling, and optimization - Comprehensive knowledge of database security best practices - Experience in developing and implementing disaster recovery plans and backup procedures - Understanding of regulatory requirements such as HIPAA, GDPR, or other data protection laws Required Skills: Database Structures, SQL, ETL Processes, Airflow, Python Important Skills: BASH, Linux, Docker Containers, API Programming, Microsoft SQL, Cloud Networking, Database Design Nice-to-Have Skills: Customer Service Orientation Benefits: Medical, dental, and vision benefits, 401K with company match