IT Infrastructure Administrator III - Data Engineer - Battelle Memorial Institute
BOULDER, CO
About the Job
Battelle delivers when others can’t. We conduct research and development, manage national laboratories, design and manufacture products and deliver critical services for our clients—whether they are a multi-national corporation, a small start-up or a government agency.
We recognize and appreciate the value and contributions of individuals with diverse backgrounds and experiences and welcome all qualified individuals to apply.
Company Overview
Battelle manages and operates the National Ecological Observatory Network (NEON) program, which is solely funded by the National Science Foundation. A 30+ year project dedicated to understanding how changes in climate, land use and invasive species impact ecology, the observatory’s scientists and engineers are collecting a comprehensive range of ecological data on a continental scale across 20 eco-climatic domains representing US ecosystems. Our teams use cutting-edge technology, including an airborne observation platform that captures images of regional landscapes and vegetation; mobile, relocatable, and fixed data collection sites with automated ground sensors to monitor soil and atmosphere; and trained field crews who observe and sample populations of diverse organisms and collect soil and water data. Once structures are completed, a leading-edge cyberinfrastructure will calibrate, store and publish this information. The Observatory includes more than 500+ personnel and is the first of its kind designed to detect and enable forecasting of ecological change at continental scales.
Job Summary
Responsible for the design, implementation, support, and optimization for NEON program data collection, storage, and access. Under general supervision, will evaluate business needs and objectives, analyze and organize raw data, build data systems and pipelines, and improve data quality. This position can be 100% remote.
Responsibilities
+ Provides advanced data analysis and modeling, and physical/logical design.
+ Performs complex data warehouse design.
+ Performs database development functions such as query optimization and schema design.
+ Performs database administration functions including backups, restores, maintenance, and security configuration.
+ Contributes to the development of procedures and standards for database development.
+ Identifies ways to improve data reliability, efficiency, and quality.
+ Prepares data for predictive and prescriptive modeling.
+ Assists with database integration into other applications and infrastructure components.
+ Performs needs assessment and evaluates new technology to improve and maintain core and enterprise infrastructure.
+ Engages external vendors when needed to solve complex problems or bugs.
+ Provides occasional after-hours support.
Key Qualifications
+ Bachelor’s degree in Computer Science or related field with 5 years of experience as a Data Engineer/Data Analyst or equivalent combination of education and/or experience.
+ Experience with database environments including PostgreSQL.
+ Experience with Trino query engine.
+ Experience with Apache Hive data warehouse software.
+ Experience with programming languages (Python, Java)
+ Experience with Git and CI/CD practices.
+ Ability to troubleshoot and resolve complex issues with databases and software.
+ Ability to effectively document all technical designs and solutions.
Desired Qualifications
+ Experience working in Google Cloud environment including CloudSQL and GKE
+ Experience working with MySQL, Microsoft SQL, Oracle databases.
+ Experience working in a scientific environment.
+ Experience with automation.
Salary
$83,000 - $155,000 (Depends on experience)
Benefits: Live an Extraordinary Life
We care about your well-being, not just on the job. Battelle offers comprehensive and competitive benefits to help you live your best life.
+ Take time to recharge : You get paid time off to support work-life balance and keep motivated.
+ Prioritize wellness : Stay healthy with medical, dental, and vision coverage with wellness incentives and benefits plus a variety of optional supplemental benefits.
+ Better together : Coverage for partners, gender-affirming care and health support, and family formation support.
+ Build your financial future : Build financial stability with an industry-leading 401(k) retirement savings plan. For most employees, we put in 5 percent whether you contribute or not, and match your contributions on top of that.
+ Advance your education : Tuition assistance is available to pursue higher education.
A Work Environment Where You Succeed
For brilliant minds in science, technology, engineering and business operations, Battelle is the place to do the greatest good by solving humanity’s most pressing challenges and creating a safer, healthier and more secure world.
You will have the opportunity to thrive in a culture that inspires you to:
+ Apply your talent to challenging and meaningful projects
+ Receive select funding to pursue ideas in scientific and technological discovery
+ Collaborate with world-class experts in an inclusive environment
+ Nurture and develop the next generation of scientific leaders
+ Give back to and improve our communities
Vaccinations & Safety Protocols
_Battelle may require employees, based on job duties, work location, and/or its clients’ requirements to follow certain safety protocols and to be vaccinated against a variety of viruses, bacteria, and diseases as a condition of employment and continued employment and to provide documentation that they are fully vaccinated. If applicable, Battelle will provide reasonable accommodations based on a qualified disability or medical condition through the Americans with Disabilities Act or the Rehabilitation Act or for a sincerely held religious belief under Title VII of the Civil Rights Act of 1964 (and related state laws)._
_Battelle is an equal opportunity employer. We provide employment and opportunities for advancement, compensation, training, and growth according to individual merit, without regard to race, color, religion, sex (including pregnancy), national origin, sexual orientation, gender identity or expression, marital status, age, genetic information, disability, veteran-status veteran or military status, or any other characteristic protected under applicable Federal, state, or local law. Our goal is for each staff member to have the opportunity to grow to the limits of their abilities and to achieve personal and organizational objectives. We will support positive programs for equal treatment of all staff and full utilization of all qualified employees at all levels within Battelle._
The above statements are intended to describe the nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all responsibilities, activities and skills required of staff members. No statement herein is intended to imply any authorities to commit Battelle unless special written permission is granted by Battelle's Legal Department.
For more information about our other openings, please visit www.battelle.org/careers
We recognize and appreciate the value and contributions of individuals with diverse backgrounds and experiences and welcome all qualified individuals to apply.
Company Overview
Battelle manages and operates the National Ecological Observatory Network (NEON) program, which is solely funded by the National Science Foundation. A 30+ year project dedicated to understanding how changes in climate, land use and invasive species impact ecology, the observatory’s scientists and engineers are collecting a comprehensive range of ecological data on a continental scale across 20 eco-climatic domains representing US ecosystems. Our teams use cutting-edge technology, including an airborne observation platform that captures images of regional landscapes and vegetation; mobile, relocatable, and fixed data collection sites with automated ground sensors to monitor soil and atmosphere; and trained field crews who observe and sample populations of diverse organisms and collect soil and water data. Once structures are completed, a leading-edge cyberinfrastructure will calibrate, store and publish this information. The Observatory includes more than 500+ personnel and is the first of its kind designed to detect and enable forecasting of ecological change at continental scales.
Job Summary
Responsible for the design, implementation, support, and optimization for NEON program data collection, storage, and access. Under general supervision, will evaluate business needs and objectives, analyze and organize raw data, build data systems and pipelines, and improve data quality. This position can be 100% remote.
Responsibilities
+ Provides advanced data analysis and modeling, and physical/logical design.
+ Performs complex data warehouse design.
+ Performs database development functions such as query optimization and schema design.
+ Performs database administration functions including backups, restores, maintenance, and security configuration.
+ Contributes to the development of procedures and standards for database development.
+ Identifies ways to improve data reliability, efficiency, and quality.
+ Prepares data for predictive and prescriptive modeling.
+ Assists with database integration into other applications and infrastructure components.
+ Performs needs assessment and evaluates new technology to improve and maintain core and enterprise infrastructure.
+ Engages external vendors when needed to solve complex problems or bugs.
+ Provides occasional after-hours support.
Key Qualifications
+ Bachelor’s degree in Computer Science or related field with 5 years of experience as a Data Engineer/Data Analyst or equivalent combination of education and/or experience.
+ Experience with database environments including PostgreSQL.
+ Experience with Trino query engine.
+ Experience with Apache Hive data warehouse software.
+ Experience with programming languages (Python, Java)
+ Experience with Git and CI/CD practices.
+ Ability to troubleshoot and resolve complex issues with databases and software.
+ Ability to effectively document all technical designs and solutions.
Desired Qualifications
+ Experience working in Google Cloud environment including CloudSQL and GKE
+ Experience working with MySQL, Microsoft SQL, Oracle databases.
+ Experience working in a scientific environment.
+ Experience with automation.
Salary
$83,000 - $155,000 (Depends on experience)
Benefits: Live an Extraordinary Life
We care about your well-being, not just on the job. Battelle offers comprehensive and competitive benefits to help you live your best life.
+ Take time to recharge : You get paid time off to support work-life balance and keep motivated.
+ Prioritize wellness : Stay healthy with medical, dental, and vision coverage with wellness incentives and benefits plus a variety of optional supplemental benefits.
+ Better together : Coverage for partners, gender-affirming care and health support, and family formation support.
+ Build your financial future : Build financial stability with an industry-leading 401(k) retirement savings plan. For most employees, we put in 5 percent whether you contribute or not, and match your contributions on top of that.
+ Advance your education : Tuition assistance is available to pursue higher education.
A Work Environment Where You Succeed
For brilliant minds in science, technology, engineering and business operations, Battelle is the place to do the greatest good by solving humanity’s most pressing challenges and creating a safer, healthier and more secure world.
You will have the opportunity to thrive in a culture that inspires you to:
+ Apply your talent to challenging and meaningful projects
+ Receive select funding to pursue ideas in scientific and technological discovery
+ Collaborate with world-class experts in an inclusive environment
+ Nurture and develop the next generation of scientific leaders
+ Give back to and improve our communities
Vaccinations & Safety Protocols
_Battelle may require employees, based on job duties, work location, and/or its clients’ requirements to follow certain safety protocols and to be vaccinated against a variety of viruses, bacteria, and diseases as a condition of employment and continued employment and to provide documentation that they are fully vaccinated. If applicable, Battelle will provide reasonable accommodations based on a qualified disability or medical condition through the Americans with Disabilities Act or the Rehabilitation Act or for a sincerely held religious belief under Title VII of the Civil Rights Act of 1964 (and related state laws)._
_Battelle is an equal opportunity employer. We provide employment and opportunities for advancement, compensation, training, and growth according to individual merit, without regard to race, color, religion, sex (including pregnancy), national origin, sexual orientation, gender identity or expression, marital status, age, genetic information, disability, veteran-status veteran or military status, or any other characteristic protected under applicable Federal, state, or local law. Our goal is for each staff member to have the opportunity to grow to the limits of their abilities and to achieve personal and organizational objectives. We will support positive programs for equal treatment of all staff and full utilization of all qualified employees at all levels within Battelle._
The above statements are intended to describe the nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all responsibilities, activities and skills required of staff members. No statement herein is intended to imply any authorities to commit Battelle unless special written permission is granted by Battelle's Legal Department.
For more information about our other openings, please visit www.battelle.org/careers
Source : Battelle Memorial Institute