Snowflake Developer

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:

Crowe is seeking a Snowflake Developer to work on our Healthcare Data Platform. The person should have at least 1-3 years’ experience of working with SQL and able to convert business requirements into code.

• Plan, design, develop and maintain the data architecture, data models and standards for various Data Integration & Data Warehouse projects in Snowflake
• Perform Data Model design, ETL/ELT development optimized for efficient storage, access, and computation to serve various use cases.
• Analyze the data quality, align technical design to data governance, address all the required non-business but operational requirements during the design and build of data pipelines
• Provide advice, guidance, and best practices around Snowflake
• Provide guidance on moving data across different environments in Snowflake
• Create relevant documentation around database objects
• Troubleshoot production support issues post deployment and come up with solutions as required
• Assist the Product Owner in identifying and estimating data tasks.
• Experience in Snowflake advanced concepts such as resource monitors, virtual warehouse sizing, query performance tuning, zero copy clone, time travel and understand how to use these features
• Ensure the highest level of security for accessing and distribution of data

Qualifications:

• Bachelor’s or master’s degree in computer science, Information Systems or related fields.
• 5+ years of experience in data Integration, ETL/ETL development, and database design or Datawarehouse design
• Experience with writing complex SQL queries, especially dynamic SQL
• Experience in Snowflake advanced concepts such as resource monitors, virtual warehouse sizing, query performance tuning, zero copy clone, time travel and understand how to use these features
• Expertise in Snowflake data modelling, ELT using Snowflake SQL , Snowflake Task Orchestration implementing complex stored Procedures and standard DWH and ETL concepts
• Experience with performance tuning and optimization of SQL queries
• Experience of working with Healthcare Data
• Experience with data security and role-based access controls
• Experience of working with Microsoft SQL Server and extensive knowledge about writing Stored procedures

Other Preferred Qualifications:

• Experience with DBT
• Experience with Azure
• Familiarity with Azure Data Factory
• Snowflake certifications are a plus

About the Team:

Product Engineering professionals at Crowe lead the software development efforts for the firm and build technology solutions in a consistent and reliable way. Product Engineering owns the software development competency for the firm, which is tied to standardized processes, practices, policies and controls for client-facing products and projects. Team members share expertise across various industries, targeting manufacturing and distribution, government, healthcare, financial services, and private equity groups based on demand from other Business Units. You will learn and build on a wide range of technologies in an environment where innovation and new ideas are highly encouraged. Hop on board to join one of the fastest growing technology consulting practices in the industry.

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!

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.