Snowflake Architect at Caterpillar Inc.

East Peoria, Illinois, United States

Caterpillar Inc. Logo
Not SpecifiedCompensation
Senior (5 to 8 years)Experience Level
Full TimeJob Type
UnknownVisa
Technology, DataIndustries

Requirements

  • Bachelor’s Degree in related field
  • Strong troubleshooting, problem solving, conceptualization, and communication skills
  • 7+ years of experience in designing, developing and maintaining the data architecture, data models and standards for various Data Integration & Data Warehousing projects in Snowflake, combined with other technologies
  • 3+ years of experience in implementing Snowflake advanced concepts like setting up resource monitors, RBAC controls, data sharing, virtual warehouse sizing, query performance tuning, Zero copy clone, and time travel
  • Understanding of AI concepts and experience working with Snowflake AI capabilities
  • Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, and SnowAlert
  • Experience with storage & integration technologies on AWS and/or Azure
  • SnowPro Core and/or Advanced Certifications (top candidates)
  • Other cloud, data or AI certifications (top candidates)

Responsibilities

  • Provide in-depth technical architectural design and support during program/project solution analysis and design to ensure roadmap alignment
  • Design Data Quality and data security processes to ensure Data Completeness, Consistency and Accuracy
  • Collaborate with key stakeholders to ensure data architecture alignment with key portfolio initiatives on the basis of cost, functionality and practicality
  • Lead POC’s as part of implementing Snowflake features along with architecting and implementing data lake initiatives
  • Recommend solutions to improve new and existing Data Warehouse and Analytics solutions
  • Create, publish, maintain and influence the data warehouse patterns across development and architecture community in Snowflake
  • Develop best practices and training materials to accelerate onboarding and help the business grow the right way
  • Overall management of the Snowflake platform for the enterprise, including evaluation and deployment of new features, training and advisory services, architectural guidance, platform support, and advocacy with Snowflake for improvements

Skills

Snowflake
Data Architecture
ETL
Security
Cloud Data Warehousing
Data Cataloging
Performance Analysis
Analytics
Snowflake AI

Caterpillar Inc.

Manufactures heavy machinery for various industries

About Caterpillar Inc.

Caterpillar Inc. designs and manufactures heavy machinery and equipment for industries such as construction, mining, energy, and rail. Their products include a wide range of machinery and engines that help clients complete large-scale projects. Caterpillar's equipment works by providing powerful tools that can perform tasks like digging, lifting, and transporting materials. What sets Caterpillar apart from its competitors is its strong aftermarket support, which includes maintenance and repair services, ensuring that their machinery remains efficient and reliable over time. The company's goal is to deliver high-quality products while also focusing on sustainability and community development through initiatives that improve education and reduce poverty.

Irving, TexasHeadquarters
1925Year Founded
$143.5KTotal Funding
IPOCompany Stage
Industrial & Manufacturing, Social Impact, AI & Machine LearningIndustries
10,001+Employees

Benefits

Annual incentive bonus plan
Medical, dental, and vision coverage
Paid time off plan (Vacation, Holiday, Volunteer, Etc.)
401k savings plan
Health savings account (HSA)
Flexible spending accounts (FSAs)
Disability benefits
Life Insurance
Parental leave
Healthy Lifestyle Programs
Employee Assistance Programs
Voluntary Benefits and Employee Discounts
Tuition Reimbursement
Career Development

Risks

Closure of Aurora office may impact regional economy and Caterpillar's reputation.
Partnership with Anti Social Social Club could dilute Caterpillar's industrial brand focus.
Advanced technology in Cat D8 dozer may face resistance from traditional customers.

Differentiation

Caterpillar's century-long history underscores its reliability and industry leadership.
The company integrates AI and IoT to enhance machinery performance and customer satisfaction.
Caterpillar's strong aftermarket services ensure product longevity and operational efficiency.

Upsides

Growing demand for autonomous equipment boosts Caterpillar's innovation in heavy machinery.
Expansion of 5G networks enhances Caterpillar's remote operation capabilities, improving safety.
Caterpillar's commitment to sustainability aligns with the global shift towards eco-friendly practices.

Land your dream remote job 3x faster with AI