Kodiak Database Administrator - Snowflake
Chicago, IL  / Cleveland, OH  / Columbus, OH  / Oakbrook Terrace, IL  / Fort Wayne, IN  / Grand Rapids, MI  / Austin, TX  / Atlanta, GA ...View All
View Less
Share
Posted 3 days ago
Job Description

Your Journey at Crowe Starts Here:

At Crowe, you have the opportunity to deliver innovative solutions to today's complex business issues. Crowe's accounting, consulting, and technology personnel are widely recognized for their in-depth expertise and understanding of sophisticated process frameworks and enabling technologies, along with their commitment to delivering measurable results that help clients build business value. Our focus on emerging technology solutions along with our commitment to internal career growth and exceptional client value has resulted in a firm that is routinely recognized as a "Best Place to Work." We are 75 years strong and still growing. Come grow with us!

Job 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 peopleare 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!

More about Crowe:

Crowe (www.crowe.com) is one of the largest public accounting, consulting and technology firms in the United States. Crowe uses its deep industry expertise to provide audit services to public and private entities while also helping clients reach their goals with tax, advisory, risk and performance services. Crowe is recognized by many organizations as one of the country's best places to work. Crowe serves clients worldwide as an independent member of Crowe Global, one of the largest global accounting networks in the world. The network consists of more than 200 independent accounting and advisory services firms in more than 130 countries around the world.

Crowe LLP provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

Crowe LLP does not accept unsolicited candidates, referrals or resumes from any staffing agency, recruiting service, sourcing entity or any other third-party paid service at any time. Any referrals, resumes or candidates submitted to Crowe, or any employee or owner of Crowe without a pre-existing agreement signed by both parties covering the submission will be considered the property of Crowe, and free of charge.


EOE M/F/D/V

 

Job Summary
Company
Start Date
As soon as possible
Employment Term and Type
Regular, Full Time
Required Education
Bachelor's Degree
Required Experience
5+ years
Email this Job to Yourself or a Friend
Indicates required fields