The Opportunity :
\\\This role is based on site at our Lexington, KY headquarters. This is not a remote position\\\
We are looking for a Database Engineer I with data warehousing experience comfortable working in a technology focused environment to join our data team.
This position will be responsible for acquisition and integration of data sources into our Data Lake, management of databases and leading the design of the company's data strategy to solve the company’s business problems. The ideal candidate will have a high working knowledge of Database Structures, BASH, Linux, Python, SFTP, Microsoft SQL, Airflow, Docker Containers, API Programming, and ETLs.
To be successful in this position, you should demonstrate excellent organizational skills and critical thinking skills. You should also have a propensity to be proactive in addressing issues and concerns to avoid crises, and constantly be looking to innovate old methods and processes for greater efficiency and effectiveness.
A Day In The Life Of :* SQL and SSMS Development:Develop, support, and maintain SQL jobs and SSMS packages for data imports, exports, and transformations to ensure seamless data integration and workflow automation.
* Systems Monitoring:Monitor database systems and Airflow for performance and respond promptly to any system outages or disruptions, ensuring minimal downtime and quick recovery.
* Database Maintenance:Provide ongoing maintenance of database refreshes, including checking Docker Containers, backups, and performance tuning to ensure data integrity.
* Data Storage and Security:Design and implement standards for data storage, workflow, maintenance, access, and security administration to protect sensitive information and ensure compliance.
* Issue Resolution:Diagnose and resolve system errors and other database\-related issues, utilizing a systematic approach to troubleshooting.
* Performance Reporting:Run and analyze reports to identify common issues, complaints, and areas for improvement, implementing logging solutions to track issues.
* Software Installation and Updates:Install or update database software to address issues, improve functionality, and ensure compatibility with other systems.
Additional Responsibilities: Perform other duties as assigned, contributing to the overall efficiency and effectiveness of the Analytics department
What You'll Bring To The Table :
* Production Deployment Insight:Deep understanding of the challenges and trade\-offs involved in building and deploying systems to production, ensuring robust and reliable database operations.
* Performance Optimization:Highly skilled in identifying performance bottlenecks, detecting anomalous system behavior, and determining the root cause of incidents to maintain optimal database performance.
* Technical Proficiency:Extensive experience with cloud environments, Windows/SQL Server, PowerShell scripting, Airflow, Linux, and virtualization technologies.
* Database Expertise:Proficient in SQL, ETL processes, and database programming, with the ability to design, implement, index, and maintain efficient data solutions.
* Systems Knowledge:Knowledge of how Microsoft SQL, Airflow, ETLs, and Dockers all interact.
* Cloud Networking:Strong experience with cloud networking, including network connectivity, protocols, load balancing, and related technologies to ensure seamless data flow and access.
* Technical Knowledge:Comprehensive knowledge of computer systems, hardware, and software, enabling effective integration and troubleshooting.
* Customer Service Orientation:Strong commitment to providing exceptional customer service, ensuring user satisfaction and support.
* Organizational Skills:Excellent organizational abilities, ensuring efficient management of tasks and resources.
* Time Management:Strong multitasking and time\-management skills, with the ability to prioritize tasks effectively to meet deadlines.
* Problem\-Solving Skills:Proficient in identifying and solving problems, thinking in regards of systems, gathering and analyzing information skillfully, and developing alternative solutions.
We’d Love It If You Also Have* Educational Background:Bachelor’s degree in Data Science, CIS, Computer Science, Software Development, Mathematics or a related field. Relevant work experience can be considered in lieu of a degree.
* Certifications:Relevant certifications are highly desirable, including certifications focused on database management (e.g., Microsoft Certified: Azure Database Administrator Associate)
* Healthcare Experience:Experience working in a dental or healthcare\-related organization is a plus, with familiarity in managing and securing health information systems.
* Technical Proficiency: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).
* Cloud Experience:Proficiency in cloud platforms such as AWS, Azure, with experience in cloud database services like Amazon RDS, Azure SQL Database.
* Scripting Skills:Strong scripting abilities, particularly in PowerShell, to automate routine database tasks and improve efficiency.
* ETL Processes:Proven expertise in designing and managing ETL (Extract, Transform, Load) processes to ensure accurate and efficient data integration.
* Database Design:Strong skills in database design, modeling, and optimization to ensure scalable and high\-performance databases.
* Security Knowledge:Comprehensive knowledge of database security best practices, including data encryption, access control, and vulnerability assessment.
* Disaster Recovery:Experience in developing and implementing disaster recovery plans and backup procedures to ensure data integrity and availability.
* Regulatory Compliance:Understanding of regulatory requirements such as HIPAA, GDPR, or other data protection laws relevant to database management.
What We’ll Offer in Return
- Medical, dental, and vision benefits
- Salary $70,000\-$80,000, DOE
- 401K with company match
- A company culture of promotions from within, with a start\-up atmosphere allowing for varied and rapid career development
About PepperPointe Partnerships
PepperPointe Partnerships is a dental service organization (DSO) with an innovative approach to proactively address the challenges and industry changes practitioners face, create efficiencies at the practice level and provide support with non\-clinical tasks, allowing practitioners to focus on providing excellent patient care. PepperPointe seeks to redefine what it means to be a DSO by fully leveraging the strengths and culture of doctor\-owned dental practices, and a growth strategy for greater synergy and protection among all dental practitioners. Through the PepperPointe platform, we offer maintained doctor ownership, a collaborative network of doctors, and help clinical teams achieve the greatest success in providing excellent patient care. PepperPointe offers doctors an optimal exit and entry strategy, with partnership opportunities for every career stage, to help preserve and extend the practice legacy, and do so on their terms.
PepperPointe is an equal opportunity employer and committed to creating an inclusive environment for all of our applicants. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics. All qualified applicants, regardless of personal characteristics, are encouraged to apply.
This job description is only a summary of the typical functions of the job, not an exhaustive or comprehensive list of all possible responsibilities, tasks, and duties.