Snowflake Architect

Company Description

Miratech helps visionaries change the world. We are a global IT services and consulting company that brings together enterprise and start-up innovation. Today, we support digital transformation for some of the world's largest enterprises. By partnering with both large and small players, we stay at the leading edge of technology, remain nimble even as a global leader, and create technology that helps our clients further enhance their business. We are a values-driven organization and our culture of Relentless Performance has enabled over 99% of Miratech's engagements to succeed by meeting or exceeding our scope, schedule, and/or budget objectives since our inception in 1989.
Miratech has coverage across 5 continents and operates in over 25 countries around the world. Miratech retains nearly 1000 full-time professionals, and our annual growth rate exceeds 25%. 

Job Description

We are seeking an experienced Snowflake Architect to lead the design, development, and optimization of scalable, high-performance data architectures. The ideal candidate will have expertise in Snowflake, Azure Data Lake, ETL processes, and Tableau, working cross-functionally to deliver actionable insights. This role supports two key projects: Workforce Management Data Migration, where the architect will transition data from an on-prem SQL Server to Azure Data Lake and Snowflake, replacing the existing ETL process with a more sustainable architecture and optimizing SQL queries. Additionally, the Cloud Vendor Data Integration project requires developing a seamless data pipeline, shifting from daily flat file deliveries to efficient Parquet/S3 or streaming solutions for improved data flow and integration.

Responsibilities:

• Architect and implement scalable, efficient, and robust data architecture solutions utilizing Snowflake.
• Integrate Snowflake with Azure Data Lake to enable seamless data flow and storage.
• Develop, optimize, and maintain ETL processes to ingest and transform data into Snowflake.
• Collaborate with data engineers, analysts, and business stakeholders to understand data needs and deliver actionable solutions.
• Optimize Snowflake performance, focusing on best practices such as data partitioning, query tuning, and resource scaling.
• Ensure compliance with data security and regulatory standards.
• Create and maintain comprehensive documentation for data architecture, processes, and workflows.
• Leverage Tableau to design dynamic dashboards and reports, delivering interactive data visualizations to business stakeholders.
• Mentor junior team members and promote best practices across the team.
• Stay current with the latest trends in data architecture, Snowflake, and analytics to drive continuous improvement.

Qualifications

• 3+ years as a Snowflake Architect or in a similar role.
• 3+ years of hands-on experience with Snowflake, including data modeling, query optimization, performance tuning, and security best practices.
• Strong expertise in integrating Snowflake with Azure Data Lake.
• 3+ years of experience with ETL tools and complex data workflows.
• Experience with big data frameworks like Hadoop, Spark, and Hive.
• Advanced proficiency in Tableau for building interactive dashboards and reports.
• Strong problem-solving skills with the ability to resolve complex technical challenges.
• Excellent communication and collaboration skills to engage with technical and non-technical stakeholders.
• Ability to thrive in a fast-paced environment while maintaining high-quality deliverables.

Nice to have:

• Familiarity with programming languages like Python, JavaScript, or Node.js.
• Experience with automated testing practices for data pipeline reliability.

We offer:

• Culture of Relentless Performance: join an unstoppable technology development team with a 99% project success rate and more than 30% year-over-year revenue growth. 
• Competitive Pay and Benefits: enjoy a comprehensive compensation and benefits package, including health insurance, and a relocation program. 
• Work From Anywhere Culture: make the most of the flexibility that comes with remote work. 
• Growth Mindset: reap the benefits of a range of professional development opportunities, including certification programs, mentorship and talent investment programs, internal mobility and internship opportunities. 
• Global Impact: collaborate on impactful projects for top global clients and shape the future of industries. 
• Welcoming Multicultural Environment: be a part of a dynamic, global team and thrive in an inclusive and supportive work environment with open communication and regular team-building company social events. 
• Social Sustainability Values: join our sustainable business practices focused on five pillars, including IT education, community empowerment, fair operating practices, environmental sustainability, and gender equality. 

* Miratech is an equal opportunity employer and does not discriminate against any employee or applicant for employment on the basis of race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity, or any other protected status under applicable law.