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 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:
  • . click apply for full job details

  • Snowflake Database Administrator

    3 weeks ago

    Peoria, Illinois, United States Caterpillar Full time

    About the RoleCaterpillar Inc. is seeking a highly skilled Snowflake Database Administrator to join our team. As a key member of our data management and administration 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...

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

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

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

  • Snaplogic Snowflake Data Engineer

    4 weeks ago

    Peoria, Illinois, United States Infosys Full time

    About the RoleWe are seeking a highly skilled Snaplogic Snowflake Data Engineer to join our team at Infosys. As a key member of our digital transformation team, you will play a critical role in enabling our clients to navigate their digital journey.As a Data Engineer for Digital Transformation, you will be responsible for researching and recommending...

  • Data Engineer

    4 weeks ago

    Peoria, Illinois, United States Infosys Full time

    About the RoleWe are seeking a highly skilled Data Engineer to join our team at Infosys. As a Data Engineer, you will play a critical role in enabling digital transformation for our clients by designing, building, and maintaining large-scale data systems.Key ResponsibilitiesDesign and implement data pipelines using Snowflake and SnaplogicDevelop and maintain...

  • Senior Database Administrator

    3 weeks ago

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

    Job Title: Senior Database AdministratorWe are seeking a highly skilled Senior Database Administrator to join our team at Illinois Mutual Life Insurance Company. As a key member of our IT department, you will be responsible for designing, implementing, and maintaining our database systems to ensure optimal performance and security.Key Responsibilities:Design...

  • Senior Database Administrator

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

  • Database Systems Administrator

    4 weeks ago

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

    Job Title: Database AdministratorAt 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, ensuring the organization and maintenance of our Company's databases, and implementing new technologies...

  • Data Engineer

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

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

  • Data Integration Specialist

    4 weeks ago

    Peoria, Illinois, United States Caterpillar Full time

    About the RoleCaterpillar Inc. is seeking a highly skilled ETL Engineer to join our team. As an ETL Engineer, you will play a critical role in extracting, transforming, and loading data from various sources into our Business-oriented Snowflake database.Key ResponsibilitiesDesign, develop, and maintain ETL processes using Python to ensure data accuracy and...

  • ETL Engineer

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

  • Data Engineer

    4 weeks ago

    Peoria, Illinois, United States Caterpillar Full time

    About the RoleCaterpillar Inc. is seeking a highly skilled ETL Engineer to join our team. As an ETL Engineer, you will play a critical role in extracting, transforming, and loading data from various sources into our Business-oriented Snowflake database.Key ResponsibilitiesDesign, develop, and maintain ETL packages using Python to ensure efficient data...

  • Data Engineer

    3 weeks ago

    Peoria, Illinois, United States Caterpillar Full time

    About the RoleCaterpillar Inc. is seeking a highly skilled ETL Engineer to join our team. As an ETL Engineer, you will play a critical role in extracting, transforming, and loading data from various sources into our Business-oriented Snowflake database.Key ResponsibilitiesDesign, develop, and maintain ETL packages using Python to ensure efficient data...

  • Senior SQL Database Engineer

    3 weeks ago

    Peoria, Illinois, United States Contact Government Services, LLC Full time

    Job Title: Sr. SQL Engineer Secure ReleaseCGS is seeking a highly skilled Sr. SQL Engineer Secure Release to join our team supporting a wide-ranging technical support initiative for a large Federal agency.We are looking for a motivated and experienced professional who can contribute to government innovation, appreciate collaboration, and anticipate the needs...

  • 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

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

  • ETL Engineer

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

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