Solution Architect, Snowflake Data

About us (Ensono)

Ensono is an expert technology adviser and managed service provider. As a relentless ally, we accelerate clients’ digital transformation to achieve business outcomes that stand to last. Our dedicated team helps organizations optimize today’s systems across any hybrid environment with services such as consulting, mainframe and application modernization, public cloud migration and cloud-native development. With certified experts in AWS, Azure and Google Cloud and recognized as Microsoft Datacenter Transformation Partner of the Year, Ensono has over 3500+ associates globally and is headquartered in greater Chicago.

We care about your success, offering comprehensive strategic and managed services for mission-critical applications. Our Advisory and Consulting services can help upfront with an application strategy or find the right places for your applications – whether it’s public, multi or hybrid cloud, or mainframe. And because we span across all mission-critical platforms, we can meet you wherever you are in your digital transformation journey, with 24/7 support when you need it. We are your relentless ally, flexing with you when challenges emerge so you don’t feel stuck in place. With cross-platform certifications and decades of experience, our technology experts become an extension of your team so you’re continuously innovating – doing more with less while remaining secure. And that’s just the beginning.

Job Summary: 

A Snowflake Data Architect is a senior professional who will play a key role in designing and implementing data architectures using Snowflake’s cloud data platform. Snowflake Data Architect has a crucial role in forming how data is organized, processed, and leveraged within an organization. Your strategic vision and technical expertise contribute to successful data-driven outcomes.

Ensono needs a hands-on solution architect for a Snowflake-based environment.

Here are the key responsibilities and skills associated with this position:

Job Responsibilities:

• Candidate should work with internal customers to shape data and analytics solutions, explore possibilities, and design solutions
• He/She should able to design data models and ETL approaches for the solutions.
• Work with the reporting team to ensure final products (reports, dashboards, apps, etc) meet business needs and make appropriate use of the data solutions.
• He/She should have ability to POC data solutions, deliver some of the more challenging components, and support the rest of the team on their efforts.
• Candidate should work with tool administrators to keep the tools working and optimized.

Experience Level

• Bachelor’s / master’s degree in computer science
• 10+ years in analytics deliver at large organizations.
• 5+ years designing ETL solutions.
• 3+ years leading development teams

Technical Skills (Mandatory Skills)

• Strong background in data lake / warehousing concepts, ETL development, data modeling, metadata management and data quality
• 5+ years hands-on with Snowflake
• 3+ years of hands-on experience as solution architect
• Snowflake Certified Architect preferred.
• Certifications for any of the cloud services like AWS, GCP or Azure
• 3+ coding in python

Good to have Skills

• Solution Design – Work with internal customers to shape data and analytics solutions, explore possibilities, and design solutions.
• Data Design – Design data models and ETL approaches for the solutions.  
• Reporting Design – Work with the reporting team to ensure final products (reports, dashboards, apps, etc) meet business needs and make appropriate use of the data solutions.
• Development – Ability to POC data solutions, deliver some of the more challenging components, and support the rest of the team on their efforts. 
• Platform Architecture – Work with tool administrators to keep the tools working and optimized.  

Shift Timing:

    1:30 PM to 10:30 PM