Career Area:
Information Technology
Job Description:
Your Work Shapes the World
Whether it be groundbreaking products, best in class solutions or creating a lifelong career, you can do the work that matters at Caterpillar. With a 95-year legacy of quality and innovation and 150 locations in countries around the world, your impact spans the globe.
At Caterpillar, a brand recognized the world over, your office could be closer than you ever realized. Caterpillar's highly flexible work environment fosters a culture to inspire unconventional ideas to accomplish remarkable results. With life demands ever-changing, Caterpillar provides employees the autonomy to choose their work location based on their daily commitments and how/where they work most efficiently and effectively. It's time to start building what matters most, your career!
When you join Caterpillar, you are joining a team of makers, innovators and doers. We are the people who roll up our sleeves and do the work to build a better world. We don't just talk about progress and innovation. We make it happen. And we are proud of that because it helps our customers build and power the world we live in - the roads, hospitals, homes and infrastructure. Without a dedicated workforce Caterpillar could not effectively meet our customer's needs. Join us.
Job Purpose:
Caterpillar is looking for a Snowflake Architect (SA) to be part of a team that is responsible for technical deployments and implementing new features of Snowflake to our business partners. SA must be a self-starter and should conduct hands-on development, configuration, or system setup for early-stage POCs/POVs. SA must have a passion to solve customers data driven challenges. SA should have a broad range of skills and experience ranging from data architecture to ETL, security, Cloud data warehouse, data cataloging, performance analysis, analytics, API's, etc. SA would work towards the creation and implementation of data lake Initiatives.
Description:

• 7 plus 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 plus year 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
• Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, and SlowAlert
• Provide in-depth technical architectural design and support during program/project solution analysis and design to ensure road-map 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
• Snowflake Certified Professional

Basic Requirements:

• College or university degree required
• Strong troubleshooting, problem solving and conceptualization skills
• 7 plus years of experience in designing, developing and maintaining the data architecture, data models and standards

Additional Details:

• Location: Dallas, Texas; Nashville, Tennessee; East Peoria, Illinois
• Relocation is offered

Employee benefit details:
Our goal at Caterpillar is for you to have a rewarding career. Our teams are critical to the success of our customers who build a better world.
Here you earn more than just a salary, because we value your performance. We offer a total rewards package that provides day one benefits [medical, dental, vision, RX, and 401(k)] along with the potential of an annual bonus.
Additional benefits include paid vacation days and paid holidays (prorated based upon hire date).
Final details:
Please frequently check the email associated with your application, including the junk/spam folder, as this is the primary correspondence method. If you wish to know the status of your application - please use the candidate log-in on our career website as it will reflect any updates to your status.
This employer is not currently hiring foreign national applicants that require or will require sponsorship tied to a specific employer, such as H, L, TN, F, J, E, O. As a global company, Caterpillar offers many job opportunities outside of the U.S. which can be found through our employment website at www.Caterpillar.com/Careers
Relocation is available for this position.
EEO/AA Employer. All qualified individuals - Including minorities, females, veterans and individuals with disabilities - are encouraged to apply.
Not ready to apply? Submit your information to our Talent Network here .