Kodiak Database Administrator - Snowflake

Description

:Database Administrator (SQL Server)

About the Role
We are seeking a highly skilled and experienced Database Administrator to join our team. The ideal candidate will have a strong background in database administration, with a specialization in Microsoft SQL Server.

A successful candidate will be responsible for the design, implementation, monitoring and maintenance of our SQL Server databases, ensuring its performance, security, and reliability. This role will work closely with our product teams to help identify areas of improvement, and to help our applications best grow to align with industry best practices. The hired candidate will be responsible for proactively managing our database instances rather than only supporting the databases.

About Kodiak Solutions

This is an exciting time to join our growing Kodiak Solutions team!Recently, Crowe LLP reached a decision to divest its Crowe Healthcare Consulting practice, now Kodiak, in a sale to TPG, a global asset management firm that will be the perfect partner to take Kodiak to the next level.The story around Kodiak is an impressive one.Derek Bang, the practice founder and inventor of the group’s flagship software product for net revenue reporting, Revenue Cycle Analytics (RCA) came to Crowe nearly 20 years ago with an idea for a strategic pursuit in the Healthcare Industry through his previous experience as a Healthcare Auditor at a Big 4 firm.Crowe invested in the idea, providing the resources and support necessary to launch the RCA product and organically grow the practice to its current state, now offering a broad suite of software and services that help healthcare CFOs solve challenges across financial reporting, revenue cycle, and risk and compliance.Kodiak currently services more than 1,800 hospitals and 200,000 practice-based physicians across all 50 states. Due to the unique complexities of the business such as technology and data security, it is time for a new partner with the appropriate expertise and resources to invest in the future growth of Kodiak.The transaction will enable Kodiak to operate with greater flexibility and focus, positioning it to accelerate growth and expand its technology portfolio to better serve healthcare provider organizations across the county.

About the Role

We are seeking a highly skilled and experienced Database Administrator to join our team. The ideal candidate will have a strong background in database administration, with a specialization in Snowflake.

A successful candidate will be responsible for the design, implementation, monitoring and maintenance of our Snowflake databases and warehouses, ensuring its performance, security, and reliability. This role will work closely with our product teams to help identify areas of improvement, and to help our applications best grow to align with industry best practices.

Key Responsibilities

• Administer, maintain, and support the Snowflake data warehouse environment, including data storage, data transfers, and computing resources to ensure optimal performance and efficiency.
• Ensure the performance, security, and reliability of the database.
• Troubleshoot and resolve database issues.
• Collaborate with other teams to ensure database integration with other systems.
• Contribute to RBAC and row level security best practices.
• Design and implement role hierarchies.
• Implement and manage secure access controls, roles, and permissions to safeguard sensitive data and comply with regulatory requirements.
• Monitor and optimize query performance, identifying and resolving bottlenecks in the data loading processes and SQL queries.
• Analyze execution plans and provide feedback to development teams.
• Coordinate with Snowflake support for issue resolution, upgrades, and new feature implementations.
• Manage data retention policies and perform data lifecycle management to optimize storage costs and compliance.
• Lead disaster recovery planning and execution, ensuring data availability and business continuity.
• Stay updated with the latest industry trends and advancements in cloud data warehousing technologies, applying new features and improvements to the Snowflake environment.

Qualifications/Requirements

• Bachelor’s degree in computer science or related field.
• 5+ years of experience in database administration.
• Advanced expertise in SQL and database scripting.
• Strong experience with Snowflake, including SnowSQL, SnowPipe, and Snowflake Data Sharing.
• Experience with Row level security, RBAC, masking policies
• Experience with Streams and Cloning
• Experience with query profile analysis, database performance tuning and optimization.
• Strong problem-solving and analytical skills.
• Excellent communication and collaboration skills.
• Experience with database design, data modeling, ETL processes, and BI tools integration.
• Dimensional modeling and data vault database design experience is nice to have.
• Familiarity with data security and compliance standards (GDPR, CCPA, HIPAA, etc.).

Preferred Qualifications

• Snowflake SnowPro Certification.
• Experience in managing large-scale data warehousing projects.
• Experience with DevOps tools and practices in a data warehousing context.

#LI-Hybrid

We expect the candidate to uphold Crowe’s values of Care, Trust, Courage, and Stewardship. These values define who we are. We expect all of our people to act ethically and with integrity at all times.

Our Benefits:

At Crowe, we know that great people are what makes a great firm. We value our people and offer employees a comprehensive benefits package. Learn more about what working at Crowe can mean for you!

How You Can Grow:

We will nurture your talent in an inclusive culture that values diversity. You will have the chance to meet on a consistent basis with your Career Coach that will guide you in your career goals and aspirations. Learn more about where talent can prosper!