Snowflake Architect- Contractor

Description

About Dimensional :

Dimensional was built around a set of ideas bigger than the firm itself. With a confidence in markets, deep connections to the academic community, and a focus on implementation, we go where the science leads, and continue to pursue new insights, both large and small, that can benefit our clients.

The Technology Department at Dimensional leverages the rapidly evolving state of the art to engineer the platforms that power the innovative, research-driven financial and technical products to improve our client’s financial lives.

As the manager of the Network Engineering team, you will be responsible for designing, developing, and maintaining our network infrastructure and automation using industry-standard tools and best practices.

You will work closely with our development and operations teams to ensure that our infrastructure is reliable, scalable, and secure.

You may be a fit for this role if you :

• Are open-minded, curious, and resourceful.
• Are passionate about / stay current with modern technologies.
• Solve problems systematically and transparently.
• Share ideas, solicit / integrate feedback, design and solve collaboratively.
• Ability to align data architecture with business objectives and strategy.
• Strong analytical and problem-solving skills to address complex data challenges.

What you might work on :

• Work in an agile team of engineers, data analysts, product manager to modernize and scale the marketing analytics platform.
• Design, deploy, test, and manage a modern marketing analytics stack using cloud technologies like Snowflake, DBT, Airflow, Fivetran and Power BI
• Develop and implement data transformation strategies to meet the marketing business needs for advanced reporting and analytics.
• Lead architecture and tradeoff discussions when implementing data transformations and curations needed to solve business challenges.
• Develop data transformation code in technologies like DBT and schedule them using technologies like Fivetran and Airflow to run in Snowflake.
• Contribute to best practices like Data governance, Data security and handling in Snowflake and build the right FinOps guardrails for cost management.
• Manage vendor relationships and negotiate contracts to ensure cost-effective consumption of data products like Snowflake and Power BI
• Build robust data pipelines and alerts for operational excellence.

Qualifications :

• Bachelor’s degree in computer science, Information Technology, or related field; advanced degree or relevant certifications in Snowflake.
• Minimum 5 years of hands-on experience with Snowflake, including data warehousing, data modeling, and performance tuning.
• Minimum 7 years of experience in data architecture, with a solid understanding of data warehousing principles and best practices.
• At least 3 years of experience using DBT for data transformation and building data pipelines using SQL and YAML.
• Proficient in GitHub to version control transformations.
• Strong background in Infrastructure as Code (IaC)
• Demonstrated ability to lead and motivate a team, fostering an environment of accountability, innovation, and continuous improvement.
• Excellent analytical, problem-solving, and project management skills, with the ability to manage multiple priorities in a fast-paced environment.
• Basic experience in developing dashboards and reports using Power BI with Snowflake data.
• Effective communication and interpersonal skills, with the ability to engage and collaborate with stakeholders at all levels across the organization.

Preferred Competencies :

• Knowledge of Fivetran for setting up data ingestion and integration with Snowflake.
• Familiarity with scheduling DBT transformations using Airflow and Python scripting.
• Experience with ETL / ELT processes and tools. Experience consuming data from APIs.
• Understanding of data governance principles and practices.
• Proficiency in managing and forecasting costs associated with Snowflake and Fivetran usage.
• Strong understanding of data curation and transformation processes within Snowflake.
• Understanding of RBAC controls in Snowflake

Dimensional offers a variety of programs to help take care of you, your family, and your career, including comprehensive benefits, educational initiatives, and special celebrations of our history, culture, and growth.

It is the policy of the Company to provide equal opportunity for all employees and applicants. The Company recruits, hires, trains, promotes, compensates, and administers all personnel actions without regard to actual or perceived race, color, religion, religious practice, creed, sex, sex stereotyping, pregnancy (which includes pregnancy, childbirth, and medical conditions related to pregnancy, childbirth, or breastfeeding), caregiver status, gender, gender identity, gender expression, transgender identity, national origin, age, mental or physical disability, ancestry, medical condition, marital status, familial status, domestic partnership status, military or veteran status or service, unemployment status, citizenship status or alienage, sexual orientation, status as a victim of domestic violence, status as a victim of stalking, status as a victim of sex offenses, genetic information, political activities or recreational activities, arrest or conviction record, salary history, natural hairstyle or any other status protected by applicable law except as otherwise required or permitted by law or regulation applicable to the Company or its affiliates.