Snowflake Database Administrator

4 weeks ago

Peoria, United States Caterpillar Full time
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, Dallas, TX or Nashville, TN
  • 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.
Visa Sponsorship is not available for this position. 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.
Posting Dates:
October 15, 2024 - October 28, 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. Category: , Keywords: Database Administrator (DBA)

  • Snowflake Database Administrator

    3 weeks ago

    Peoria, Illinois, United States Caterpillar Full time

    About the RoleCaterpillar is seeking a highly skilled Snowflake Database Administrator to join our team. As a key member of our data platform team, you will be responsible for ensuring the integrity, security, and performance of our data platform.Key ResponsibilitiesManage and monitor the Snowflake platform, including data ingestion, data transformation,...

  • Snowflake Database Administrator

    4 weeks ago

    Peoria, United States Caterpillar Full time

    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...

  • Senior Database Administrator

    4 weeks ago

    Peoria, Illinois, United States Illinois Mutual Life Insurance Company Full time

    Job SummaryThe Illinois Mutual Life Insurance Company seeks a highly skilled Senior Database Administrator to provide technical support for the database environment, oversee the development and organization of the Company's databases, and implement new technologies to drive business growth.This role requires a strong understanding of database technology,...

  • Database Systems Specialist

    3 weeks ago

    Peoria, Illinois, United States Illinois Mutual Life Insurance Company Full time

    Job DescriptionAt Illinois Mutual Life Insurance Company, we are seeking a highly skilled Database Administrator to join our team. The successful candidate will be responsible for providing technical support for our database environments, organizing our databases, and implementing new technologies to improve our data management capabilities.Key...

  • Python Developer

    4 weeks ago

    Peoria, Illinois, United States CATERPILLAR INC Full time

    Job DescriptionCareer Area: Business Technologies, Digital and DataJob Title: Python DeveloperJob Summary:We are seeking a highly skilled Python Developer to join our team in Peoria, IL, Dallas, TX, or Nashville, TN. As a Python Developer, you will be responsible for maintaining our Python ETL package and developing new functionalities.Key...

  • Application Support

    3 weeks ago

    Peoria, United States TEKsystems Full time

    Description: Position’s Contributions to Work Group: - Triage & Resolve support tickets as per the defined Service Level agreement - Works on critical application/technical problem identification and resolution, including responding to off-shift and weekend support calls. - Tickets investigation; statistical analyses, testing and analysis of application...

  • Administrative Assistant

    2 weeks ago

    Peoria, United States JR Filanc Construction Company Full time

    Essential Functions: Provide administrative and project support to the Arizona R&M General Manager, Project Managers, Field Superintendents and Field Employees as needed with confidentiality and professionalism. Responsibilities: Office Administration Manage all calls and correspondence for the Arizona office. Check and sort mail daily. Receive and...

  • Digital Technical Specialist

    4 weeks ago

    Peoria, Illinois, United States Elite Mente LLC Full time

    Job DescriptionJob Title: Digital Technical SpecialistLocation: Peoria, ILVisa: AnyDuration: 12+ Months ContractPrimary Skills:Snowflake, Grafana, AWS Cloud Formation, API, Technical SupportDescription:The Digital Technical Specialist is responsible for monitoring overall performance of assigned digital products and handling customer issues through...

  • Senior IT Professional

    4 weeks ago

    Peoria, Illinois, United States Next Level Business Services, Inc. Full time

    Job SummaryThe ideal candidate will possess a strong background in IT, with a focus on technical solutions and project management. This role will involve coordinating work with others, managing assignments, and ensuring timely completion of tasks.Key responsibilities will include:Managing and coordinating work assignmentsCoordinating with team members to...

  • Administrative Assistant

    2 months ago

    Peoria, United States FILANC Full time

    DEssential Functions:Provide administrative and project support to the Arizona R&M General Manager, Project Managers, Field Superintendents and Field Employees as needed with confidentiality and professionalism. Responsibilities:Office AdministrationManage all calls and correspondence for the Arizona office.Check and sort mail daily.Receive and ship...

  • Digital Technical Support Specialist

    4 weeks ago

    Peoria, Illinois, United States Randstad Full time

    Job Summary:The Digital Technical Analyst is responsible for monitoring overall performance of assigned digital products and handling customer issues through resolution. This role requires a strong understanding of relational databases, cloud computing, and high availability architecture.Responsibilities: Triage and resolve support tickets as per the defined...

  • Digital Technical Support Specialist

    4 weeks ago

    Peoria, Illinois, United States Goli Tech Full time

    Job OverviewWe are seeking a highly skilled Digital Technical Support Specialist to join our team at Goli Tech. The successful candidate will be responsible for monitoring the performance of assigned digital products and resolving customer issues in a timely and efficient manner.Key Responsibilities:Triage and resolve support tickets in accordance with our...

  • SharePoint Developer/Information Technology

    5 months ago

    Peoria, United States Next Level Business Services, Inc. Full time

    The position manages the completion of its own work assignments and coordinates work with others. Based on past experiences and knowledge, the incumbent normally works independently with minimal management input and review of end results. Typical customers include Caterpillar customers, dealers, other external companies who purchase services offered by...

  • Digital Technical Analyst

    4 weeks ago

    Peoria, Illinois, United States Randstad Full time

    Job Summary:The Digital Technical Analyst is responsible for monitoring overall performance of assigned digital products and handling customer issues through resolution.Key Responsibilities:Triage and resolve support tickets as per the defined Service Level agreementWork on critical application/technical problem identification and resolution, including...

  • Administrative Assistant/Data Specialist

    3 weeks ago

    Peoria, Arizona, United States Illinois Central College Full time

    Job SummaryThe TRIO SSS Administrative Assistant will provide administrative support to the TRIO SSS Program at Illinois Central College. This role requires a friendly and professional demeanor, with the ability to maintain confidentiality and work independently.Key ResponsibilitiesAssist with preparing team meetings, reports, and other materialsComplete the...

  • Data Governance Specialist

    1 month ago

    Peoria, Illinois, United States Caterpillar Full time

    Job Title: IT Analyst III-ApplicationsCaterpillar Inc. is seeking a highly skilled IT Analyst III-Applications to join its team. As a key member of the data analytics group, you will work closely with developers, customers, and digital architects to bring data to the platform through ETL or SQL development.Key Responsibilities:Develop and maintain the...

  • Medical Support Assistant

    4 weeks ago

    Peoria, Illinois, United States VETERANS HEALTH ADMINISTRATION Full time

    Job SummaryThe VETERANS HEALTH ADMINISTRATION is seeking a highly skilled Medical Support Assistant to join our team. As a Medical Support Assistant, you will play a critical role in providing administrative support to our healthcare team, ensuring the smooth operation of our clinic and providing exceptional patient care.Key ResponsibilitiesCoordinate with...

  • Data Governance Specialist

    4 weeks ago

    Peoria, Illinois, United States Caterpillar Full time

    Career Opportunity: As a Data Governance Specialist at Caterpillar Inc., you will play a critical role in shaping the company's data management strategy. You will work closely with developers, customers, and digital architects to bring data to the platform through ETL or SQL development. Your focus will be on developing and maintaining the governance frame...

  • Administrative Assistant

    2 weeks ago

    Peoria, United States Artists ReEnvisioning Tomorrow Inc Full time

    Organization Description Artists ReEnvisioning Tomorrow Inc "ART Inc", founded in 2018 by Jonathon and Nikki Romain, is Peoria's foremost arts education non-profit organization. ART Inc provides arts education opportunities to nearly 500 students and teaching artists each year. The staff, board, volunteers, and teaching artists of ART Inc work tirelessly to...

  • Data Scientist

    4 weeks ago

    Peoria, Illinois, United States Caterpillar Full time

    About the Role:Caterpillar is seeking a Data Scientist to join our Earthmoving Division, a multi-billion dollar division. As a Data Scientist, you will be responsible for developing analytical tools to provide valuable financial and operational insights to Senior Leadership.Key Responsibilities:Directing the data gathering, data mining, and data processing...