Snowflake Database Administrator

2 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. Keywords: Database Administrator (DBA), Location: Peoria, IL - 61606 , PL: 595071456

  • Snowflake Database Administrator

    5 days 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

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

  • Snowflake Database Administrator

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

  • Snowflake Database Administrator

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

  • Snowflake Database Administrator

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

  • Senior Database Administrator

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

  • Senior Database Administrator

    1 month ago

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

    Job SummaryWe are seeking a highly skilled and experienced Senior Database Administrator to join our team at Illinois Mutual Life Insurance Company. The successful candidate will be responsible for designing, implementing, and maintaining our database systems to ensure optimal performance, security, and scalability.Key ResponsibilitiesDesign, implement, and...

  • Data Engineer

    2 weeks ago

    Peoria, Illinois, United States Infosys Full time

    About the RoleInfosys is seeking a highly skilled Data Engineer to join our team. As a Data Engineer, you will play a key role in enabling digital transformation for our clients in a global delivery model.You will be responsible for researching technologies independently, recommending appropriate solutions, and contributing to technology-specific best...

  • Database Administrator

    4 weeks ago

    East Peoria, Illinois, United States United Facilities, Inc. Full time

    Job Title: Programmer / DBAUnited Facilities, Inc. is seeking a skilled Programmer / DBA to join our growing IT Department.Job Summary:We are looking for a highly motivated and experienced Programmer / DBA to develop and debug application programs, execute system and integration tests, and support production applications. The ideal candidate will have a...

  • ETL Engineer

    1 month ago

    Peoria, Illinois, United States Caterpillar Full time

    About the RoleCaterpillar is seeking a highly skilled ETL Engineer to join our team. As an ETL Engineer, you will be responsible for designing, developing, and implementing data integration solutions to support business intelligence and analytics initiatives.Key ResponsibilitiesDesign, develop, and implement ETL processes to extract, transform, and load data...

  • Database Systems Specialist

    6 days 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

    2 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

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

  • IT Software Engineer 4

    5 months ago

    Peoria, United States Saxon Global Full time

    Summary: The main function of a software engineer is to apply the principles of computer science and mathematical analysis to the design, development, testing, and evaluation of the software and systems that make computers work. A typical software engineer researches, designs, develops and tests operating systems-level software, compilers, and network...

  • IT Architect

    3 weeks ago

    Peoria, Illinois, United States CATERPILLAR INC Full time

    About the RoleCaterpillar Inc. is seeking a highly skilled IT Architect to join our team as a GenAI Specialist. This role will play a vital part in enabling a safe environment where the business can innovate and thrive.Key ResponsibilitiesProvide technical leadership for all aspects of environment management, including database lifecycle management,...

  • Administrative Coordinator

    2 weeks ago

    Peoria, Arizona, United States Filanc Full time

    Job Title: Administrative AssistantWe are seeking a highly organized and detail-oriented Administrative Assistant to join our team at Filanc. As an Administrative Assistant, you will provide administrative and project support to our Arizona R&M General Manager, Project Managers, Field Superintendents, and Field Employees.Key Responsibilities:Office...

  • Database Analyst

    5 months ago

    East Peoria, United States Saxon Global Full time

    Summary: Position will contribute to the understanding, implementation, and flow of data through manufacturing processes. This position will work alongside developers, customers, and digital architects to bring data to the platform through ETL or SQL development. This role will focus on developing and maintaining the governance frame to ensure the platform...

  • Digital Technical Specialist

    1 week 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

    2 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

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