Snowflake Database Administrator - Caterpillar

Career Area:
Business Technologies, Digital and Data
Job Description:

Your Work Shapes the World at Caterpillar Inc.

When you join Caterpillar, you're joining a global team who cares not just about the work we do - but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable communities. We don't just talk about progress and innovation here - we make it happen, with our customers, where we work and live. Together, we are building a better world, so we can all enjoy living in it.

Snowflake Database Administrator

Role Definition:

As a Snowflake Database Administrator, you will be primarily responsible for ensuring the integrity, security, and performance of the Data platform that supports the data needs of various business units and functions.

You will work closely with the Enterprise Data Governance team and the Business Governance team to follow the standards and principles of data management and governance.

You will also collaborate with data engineers, data analysts, data scientists, and other stakeholders to provide data solutions that meet the business requirements and objectives.

What You Wil Do:

• Manage and monitor the Snowflake platform, including data ingestion, data transformation, data quality, data security, and data access.
  
• Apply the principles and policies that have been agreed with the Business Governance team regarding data source ingestion, database functional organization, and access management.
  
• Implement and enforce best practices for data modeling, data architecture, data governance, and data lifecycle management.
  
• Troubleshoot and resolve any issues or incidents related to the Snowflake platform and provide root cause analysis and recommendations for improvement.
  
• Provide technical support and guidance to data users and consumers and ensure that they have the appropriate access and permissions to the data they need.
  
• Review and approve code changes as part of the CI/CD process.
  
• Maintain and update our CI/CD Python package as required.
  
• Collaborate with Enterprise Data Lakes to ensure efficient data flows.
  
• Keep abreast of the latest developments and trends in Snowflake and other data technologies and evaluate and recommend new features or tools that can enhance the data capabilities and performance.
  
• Lead actions to maintain the infrastructure of IT systems that support the business to function efficiently.
  
• Guide the design solutions by assessing and aligning the current systems to best practices and comply to federal policies and procedures.
  
• Execute the middleware application server and automated workflow tools, work with server virtualization technologies.
  
• Administer updates, upgrades, and other maintenance tasks in both hardware and software areas, to make the network more efficient, cost-effective, and secure.
  

What You Have:

• Bachelor's degree in computer science, Information Systems, or a related field, or equivalent work experience.
  
• At least 3 years of experience as a Snowflake Database Administrator, or a similar role in data management and administration.
  
• Strong knowledge and skills in Snowflake, including data ingestion, data transformation, data security, data access, and data optimization.
  
• Experience with data governance and data quality frameworks and tools, such as Data Catalog, Data Lineage, Data Dictionary, and Data Profiling.
  
• Experience with SQL and scripting languages, such as Python, JavaScript, Shell, or PowerShell.
  
• Excellent communication, collaboration, and critical thinking skills.
  
• Ability to work independently and as part of a team in a fast-paced and dynamic environment.
  
• Certification in Snowflake or other data technologies is a plus.
  

Skills Descriptors:

Technical Excellence: Knowledge of a given technology and various application methods; ability to develop and provide solutions to significant technical challenges.

Level Extensive Experience:

• •Advises others on the assessment and provision of all technical solutions.
  
• •Engages appropriate subject matter resources to effectively resolve technical issues.
  
• •Mentors' others to enhance their technical competence and its application to achieve more effective technical solutions.
  
• •Provides effective solutions to moderate technical challenges through strong technical competence, effectively examining implications of events and issues.
  
• •Assumes accountability for personal technical performance and holds others responsible for theirs.
  

Technology Advising: Knowledge of effective advisory methods and ability to provide valued information and advice to clients regarding products, technologies, services, and solutions for a specific technology domain.

Level Working Knowledge:

• Assesses the current technology environment, expressed needs and initiatives of client organizations.
  
• Demonstrates basic competence and sound business knowledge regarding specific products, technologies, or services within a domain of technology expertise.
  
• Achieves consulting relationship rating of 'professional' by delivering timely, meaningful advice meeting client needs in a narrow set of specific technologies.
  

Hardware Infrastructure: Knowledge of computer architecture and systems programming; ability to design, build and integrate IT hardware into multi-platforms for the organization.

Level Extensive Experience:

• Evaluates IT hardware vendors in the market and selects the most suitable products for the organization.
  
• Guides employees on the integration of IT hardware throughout other organization-wide platforms.
  
• Supervises the implementation process of IT hardware ensuring consistency in productivity and overall effectiveness.
  
• Advises others on business standards and practices for IT hardware to meet designer requirements.
  
• Evaluates the advantages and disadvantages of an organization's hardware components.
  
• Diagnoses IT hardware problems and recommends dynamic solutions.
  

Requirements Analysis: Knowledge of tools, methods, and techniques of requirement analysis; ability to elicit, analyze and record required business functionality and non-functionality requirements to ensure the success of a system or software development project.

Level Working Knowledge:

• Follows policies, practices, and standards for determining functional and informational requirements.
  
• Communicates with customers and users to elicit and gather client requirements.
  
• Participates in the preparation of detailed documentation and requirements.
  

System Testing: Knowledge of system and software testing; ability to design, plan and execute system testing strategies and tactics to ensure the quality of software at all stages of the system life cycle.

Level Extensive Experience:

• Verifies the proper flow of transactions across all input, output and storage channels or devices.
  
• Evaluates interoperability of new systems with existing systems during the beta testing phase.
  
• Supervises the testing of complex, multi-platform, and distributed applications.
  
• Designs processes to ensure that the system meets and maintains requirements and expectations.
  
• Coaches end users on the development of test data and test scenarios for system validation.
  
• Manages the execution of test plans, including resources, strategies, schedules, processes, and tools.
  

Systems Software Infrastructure: Knowledge of computer architecture and system software interaction; ability to design and build a fundamental architecture of operating systems, database management systems, communications protocols, compilers, and other development tools.

Level Working Knowledge:

• Demonstrates planned software changes on the local environment.
  
• Analyzes the local software architecture components and products.
  
• Tests key features for the entire software infrastructure environment.
  

Technical Troubleshooting: Knowledge of technical troubleshooting approaches, tools, and techniques; ability to anticipate, recognize, and resolve technical issues on hardware, software, application or operation.

Level Extensive Experience:

• Emphasizes the business impact of failure and the criticality and timing of needed resolution so that problems can be avoided in the future.
  
• Creates trouble reports for all issues found and reviews solutions for completeness and correctness.
  
• Directs the resolution of communications problems in multi-vendor environments.
  
• Resolves a variety of hardware, software, and communications malfunctions.
  
• Coaches' others on advanced diagnostic techniques and tools for unusual or performance-related problems.
  
• Facilitates the distribution of releases reports and correction packages to departments or clients.
  

Technical Writing/Documentation: Knowledge of technical writing; ability to write technical documents such as manuals, reports, guidelines or documents on standards, processes, and applications.

Level Extensive Experience:

• Conducts training on alternative documentation delivery mechanisms, tools, and techniques.
  
• Manages cost items in producing and maintaining documentation.
  
• Designs and implements formal methodologies for producing documentation.
  
• Collaborates with support function managers, the product management team, and design engineers with writing projects.
  
• Supervises the analysis, design, and data collation on large documentation initiatives.
  
• Establishes and references best practices for existing and planned tools and delivery vehicles for proper documentation.
  

Additional Information:

• Location: Peoria, IL
  
• NO RELOCATION
  
• 3days MANDATORY IN OFFICE
  
• Sponsorship is not available including OPT, H4-EAD. Must be US Citizen or Green Card holder.
  

What You Will Get:

• 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 an hourly wage because we value your performance, we offer a total rewards package that provides day one benefits (medical, dental, vision, RX, and 401K) along with the potential of an annual bonus.
  
• Additional benefits include paid vacation days and paid holidays (prorated based upon hire date).
  

About Caterpillar:

• Caterpillar Inc. is the world's leading manufacturer of construction and mining equipment, off-highway diesel and natural gas engines, industrial gas turbines and diesel-electric locomotives. For nearly 100 years, we've been helping customers build a better, more sustainable world and are committed and contributing to a reduced-carbon future. Our innovative products and services, backed by our global dealer network, provide exceptional value that helps customers succeed.
  

Posting Dates:
September 19, 2024 - October 3, 2024
Any offer of employment is conditioned upon the successful completion of a drug screen.

EEO/AA Employer. All qualified individuals - Including minorities, females, veterans and individuals with disabilities - are encouraged to apply.

Not ready to apply? Join our Talent Community .PandoLogic. Keywords: Database Administrator (DBA), Location: Peoria, IL - 61606 , PL: 594747501