高级Snowflake架构师/开发工程师
Senior Snowflake Architect / Developer
Attain Partners 是一家创新的咨询公司，致力于打破现状，改变世界并改善我们所接触的人的生活。从战略到技术，以及中间的各个方面，我们的专家利用其独特技能，推动教育、非营利、医疗保健以及州和地方政府客户的重大使命。
我们的一切工作都以人员为中心，因此我们赋能职业发展，提供行业领先的福利包，鼓励灵活的工作环境，并培养包容性文化，以满足团队的需求。我们对使命和员工充满共同的热情。在我们的七项核心价值观——“Attain Way”的指引下，我们的愿景是文化的基石——成为并实现最佳。
Attain Partners 正在寻找一名高级 Snowflake 架构师/开发者，负责领导面向高等教育客户的基于 Snowflake 的数据解决方案的架构、设计、开发和优化。此职位需要一位能够同时担任解决方案架构师和实际开发者的人员。该人员将主导客户发现和设计研讨会，评估当前的 Snowflake 环境，解决复杂的技术问题，开发未来状态的数据模型和架构，并直接构建和优化 Snowflake 解决方案。成功的候选人应有与高等教育机构合作的先前经验，并能自如地与高管利益相关者、业务用户、数据和分析团队、应用程序负责人和技术资源进行沟通。该人员应能够将机构需求转化为可扩展的技术解决方案，并在整个实施过程中保持实际操作能力。
#### 必要技能
- 在 Snowflake 中具有扎实的实际经验，包括设计、开发和支持解决方案。
- 能够在同一项目中同时担任 Snowflake 架构师和 Snowflake 开发者。
- 具有设计可扩展 Snowflake 环境的经验，包括数据库、模式、虚拟仓库、安全模型、工作负载管理以及数据共享模式。
- 高级 SQL 开发技能，包括复杂查询、视图、存储过程、函数和数据转换逻辑。
- 在设计逻辑、物理、维度和分析数据模型方面有丰富经验。
- 能够根据不断变化的机构需求设计未来状态的企业级数据模型和架构。
- 有开发 ETL/ELT 流水线和集成的经验
查看英文原文
Attain Partners is an innovative consulting firm dedicated to disrupting the status quo to change the world and improve the lives of those we touch. From strategy to technology and everywhere in between, our experts use their unique skills to advance the important missions of education, nonprofit, healthcare, and state and local government clients.
People are at the center of all we do, and that’s why we empower career growth, provide industry-leading benefits packages, encourage a flexible work environment, and foster a culture of inclusion to support the needs of our team. We share a collective passion for our mission and our people. Guided by our seven core values, The Attain Way, our vision is the foundation of our culture—to be and _attain_ the best.
Attain Partners is seeking a Senior Snowflake Architect / Developer to lead the architecture, design, development, and optimization of Snowflake-based data solutions for higher education clients. This role requires someone who can operate as both a solution architect and hands-on developer. The individual will lead client discovery and design workshops, assess current-state Snowflake environments, troubleshoot complex technical issues, develop future-state data models and architectures, and directly build and optimize Snowflake solutions. The successful candidate will have prior experience working with higher education institutions and will be comfortable engaging with executive stakeholders, business users, data and analytics teams, application owners, and technical resources. This individual should be able to translate institutional requirements into scalable technical solutions while remaining hands-on throughout implementation.
#### Required Skills
- Strong hands-on experience designing, developing, and supporting solutions within Snowflake.
- Ability to serve as both a Snowflake Architect and Snowflake Developer within the same engagement.
- Experience designing scalable Snowflake environments, including databases, schemas, virtual warehouses, security models, workload management, and data-sharing patterns.
- Advanced SQL development skills, including complex queries, views, stored procedures, functions, and data transformation logic.
- Strong experience designing logical, physical, dimensional, and analytical data models.
- Ability to design future-state enterprise data models and architectures based on evolving institutional requirements.
- Experience developing ETL/ELT pipelines and integrating data from enterprise applications, databases, APIs, cloud platforms, and file-based sources.
- Strong troubleshooting skills with the ability to diagnose and resolve Snowflake performance, query, data-load, security, integration, and configuration issues.
- Experience with Snowflake performance and cost optimization, including warehouse sizing, workload separation, auto-suspend/resume, resource monitors, and query optimization.
- Understanding of Snowflake security capabilities including RBAC, masking policies, row-level security, secure views, and data sharing.
- Experience implementing data-quality controls, reconciliation processes, validation routines, exception handling, and monitoring.
- Demonstrated experience leading client-facing discovery, requirements, architecture, and technical design workshops.
- Ability to translate business requirements into technical architectures, data models, source-to-target mappings, and development specifications.
- Strong written and verbal communication skills with the ability to communicate effectively with both technical and non-technical audiences.
- Prior experience delivering data, analytics, data warehouse, or cloud data platform solutions within higher education.
- Ability to independently lead technical workstreams while also collaborating with client and consulting delivery teams.
#### Desired Skills
- Experience working with higher education data domains such as: - Student and academic data - Admissions and enrollment - Advancement and fundraising - Finance - Human resources - Research - Institutional reporting and analytics.
- Experience with higher education platforms such as Workday, PeopleSoft, Ellucian Banner, Colleague, Salesforce Education Cloud, Slate, Advancement CRM platforms, or similar enterprise applications.
- Experience modernizing legacy enterprise data warehouses into cloud-based Snowflake architectures.
- Experience with Snowflake capabilities such as: - Snowpark - Snowpipe - Streams and Tasks - Dynamic Tables - Secure Data Sharing - Snowflake Marketplace - Cortex or other Snowflake AI capabilities.
- Experience with orchestration and integration technologies such as Boomi, MuleSoft, Informatica, Azure Data Factory, dbt, Fivetran, Matillion, or similar platforms.
- Experience with analytics and visualization platforms such as Power BI or Tableau.
- Experience working within Azure, AWS, or GCP cloud ecosystems.
- Familiarity with data governance, metadata management, master data management, data quality, and enterprise data architecture principles.
- Experience creating architecture diagrams, future-state roadmaps, data models, technical designs, and solution documentation.
- Consulting experience working directly with multiple client stakeholders and managing competing technical and business priorities.
- Ability to mentor developers, data engineers, analysts, and client technical resources.
#### Years of Experience
8+ years of professional experience in data engineering, data architecture, data warehousing, analytics, or related data technology roles. 4+ years of hands-on Snowflake architecture and development experience.
#### Certifications
SnowPro Advanced: Architect, SnowPro Advanced: Data Engineer, SnowPro Core.
**Additional Requirements**
- Demonstrated ability to build trusted advisor relationships with clients
- Experience supporting sales and business development
- Position requires flexibility to travel periodically based on business and client needs
* * *
**Additional Information**
Attain Partners values your mental, emotional, and physical health and wellbeing. Our comprehensive benefits package starts on your first day of employment and includes benefits such as:
- Competitive health, dental, and vision coverage, HSA and FSA accounts, life and disability insurance, fertility and family planning benefits, and employee assistance and discount programs
- 11 paid federal holidays and flexible unlimited time off (UTO)
- Generous 401(k) matching with immediate vesting
- Flexible career paths – our career tracks provide advancement, mobility, and flexibility as you continue to grow with us
- A healthy environment where we value unique experiences, and care about everything that makes you, you.
Attain Partners is committed to fair and equitable compensation practices. The individual base salary for this position is unique to each candidate and will be commensurate with experience, education, and skills. In addition to base salary, this role is eligible for an annual discretionary bonus.
_Interested in this position but the compensation isn’t quite right? Let us know your expectations, and we’ll see if we can make it happen based on your qualifications._
Salary Range
$120,000—$188,000 USD
**Attain Partners is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to sex, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.**
Applicants have rights under Federal Employment Laws. For more Information visit [EEO](https://urldefense.com/v3/__https:/www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf__;!!F1XoHSs!TIdq0zG-EsH_Dg3z_rd1On_8uw1NQi5AqXf4cZ4nFMnSDJkyPC5EiL7SiKes$), [EEO Poster Supplement](https://urldefense.com/v3/__https:/www.dol.gov/ofccp/regs/compliance/posters/pdf/OFCCP_EEO_Supplement_Final_JRF_QA_508c.pdf__;!!F1XoHSs!TIdq0zG-EsH_Dg3z_rd1On_8uw1NQi5AqXf4cZ4nFMnSDJkyPC5EiBQrAYh0$), [Family and Medical Leave Act (FMLA)](https://www.dol.gov/sites/dolgov/files/WHD/legacy/files/fmlaen.pdf), and [Employee Polygraph Protection Act (EPPA)](https://www.dol.gov/agencies/whd/posters/employee-polygraph-protection-act).
If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.