Senior Data Engineer - IT
Apply now »Date: Dec 6, 2023
Location: Lakewood, CO, US
Company: Terumo BCT, Inc.
Requisition ID: 31476
At Terumo Blood and Cell Technologies, our 7,000+ global associates proud to come to work each day, knowing that what we do impacts the lives of patients around the world.
We make medical devices and related products that are used to collect, separate, manufacture and process various components of blood and cells. With our innovative technologies and service offerings, we touch a patient’s life every second of every day and are committed to continuing to increase the number of patients we serve.
With some of the best and brightest minds in the industry, an unmatched global footprint, comprehensive benefits and a distinct culture, Terumo Blood and Cell Technologies is a great place to work, grow and be part of a team that is focused on making a difference. Consider joining our team and unlock your potential.
In this capacity, the Senior Data Engineer designs and develops systems for the maintenance of the business’s data warehouse, ETL processes, and business intelligence. Design, build, and/or modify existing data pipeline(s) for Analytics use, with eye toward best practices in enterprise data architecture. Build solutions including real-time data ingestion, data lake and data warehouse storage, and analytics in alignment with best practices for optimizing performance as well as automated integration with dashboarding products. Design and build systems for both batch and real-time data ingestion, storage, and analytics, for structured and unstructured data.
ESSENTIAL DUTIES
- Build automations and updates to data pipeline to produce regular reporting products to support business decision making.
- Work hand-in-hand with business stakeholders/ analysts/ business partners to deliver data solutions in the form of data preparation, data transformation, dashboarding, automated reporting, and automated dashboard updates that will support Terumo’s digital strategy and strategic vision.
- Strong working experience and knowledge of SQL databases building/querying databases/schemas/tables. Use state-of-the-art tools and technologies to enable full cloud optimization, seamless elasticity and end-to-end automation with considerations for both performance and architecture.
- Make modifications and updates to existing data pipelines as necessary.
- Critically review current and future data structures with an eye towards simplicity & performance. Analytical role in quickly and thoroughly analyzing business requirements for reporting and analysis and subsequently translating the emanating results into good technical data designs.
OTHER DUTIES AND RESPONSIBILITIES
- Help to foster the data-driven and technology-savvy culture across our business by serving as a tech evangelist and encourage forward thinking development.
- Participate in SAAS technology evaluations and/or collaborate with other areas of business on technology strategy—and with an enterprise mindset.
- Use knowledge and expertise to effectively and collaboratively work with vendors and other non-Terumo BCT associates on analytics planning and development.
- Participate and help guide data governance policy and practice for the data lake, data warehouse and other company repositories.
- Conduct full system testing and documentation.
MINIMUM QUALIFICATION REQUIREMENTS
Education
Bachelor’s degree in Computer Science, Statistics and/or related field, equivalent of education and experience sufficient to successfully perform the essential functions of the job may be considered.
Experience
Minimum 5 years’ experience.
Experience with Python, Java, C++, Data bricks, SQL database, Scala or similar object-oriented programming languages and using software automation/CICD tools.
Experience with R Shiny, Azure data factory, Azure Microsoft BI and/or modern data visualization technologies.
Skills
- Ability to transform data using one or more modern cloud-native ETL/ELT tools.
- Familiarity in working with cloud native technologies, such as Microsoft Azure or AWS, and in building data systems on cloud.
- Demonstrated ability to lead projects, including project management tool experience, leading project teams, and coordination with client personnel.
- Demonstrated ability to communicate effectively both verbally and in writing.
- Exposure to/ Experience with Alteryx Server a plus.
- Experience as being a member of an analytics agile team is a definite plus.
-Or-
An equivalent competency level acquired through a variation of these qualifications may be considered.
PHYSICAL REQUIREMENTS
Typical Office Environment requirements, may include reading, speaking, hearing, close vision, walking, bending, sitting, and occasional lifting up to 20 pounds.
Target Pay Range: $106,500.00 to $133,100.00 - Salary to be determined by the education, experience, knowledge, skills, and abilities of the applicant, internal equity, and alignment with market data
Target Bonus on Base: 7.0%
At Terumo Blood and Cell Technologies, we provide competitive total reward offerings that consist of compensation, benefits, recognition, along with a wealth of other well-being, work-life and recognition programs which support in unlocking the potential for you and your family. Included in our expansive list of benefits offerings are multiple group medical, dental and vision plans, a robust wellness program, life insurance and disability coverages, also a variety of voluntary programs such as group accident, hospital indemnity, critical illness, pet insurance and much more. To help you save for retirement, we offer a 401(k) plan with a matching contribution and for work-life balance we have vacation and sick time programs for associates. For us, it’s about protecting the personal welfare of our associates and their families, helping to achieve personal goals and offering those extra touches for convenience, security and overall peace of mind.
- Terumo Blood and Cell Technologies is part of Terumo Group, founded in 1921 and headquartered in Tokyo, Japan.
- In 2019, Terumo Blood and Cell Technologies reached $1 billion in revenue.
- We employ nearly 7,000 associates globally, with global headquarters in Lakewood, CO, U.S., and regional headquarters in Brussels, Buenos Aires, Singapore and Tokyo.
- We manufacture devices, disposable sets and solutions at our facilities in Belgium, India, Japan, Northern Ireland, the U.S. and Vietnam. Our global presence enables us to serve customers in more than 130 countries.
- Our core values help set our direction, guide our actions and keep us true to our corporate mission of contributing to society through healthcare.
- Respect – Appreciative of others
- Integrity – Guided by our mission
- Care – Empathetic to patients
- Quality – Committed to excellence
- Creativity – Striving for innovation
- We contribute to the Leukemia and Lymphoma Society (LLS), raising $1.3 million USD since 2007.
We are proud to be an Equal Opportunity Affirmative Action Employer. All applicants will be afforded equal opportunity without discrimination because of race, color, religion, sex, gender identity or expression, sexual orientation, marital status, order of protection status, national origin or ancestry, citizenship status, age, physical or mental disability unrelated to ability, military status or an unfavorable discharge from military service.
Terumo Blood and Cell Technologies is committed to providing a safe, healthy and secure working environment. Our Colorado campus locations are tobacco-free workplaces, and we maintain a drug-free workplace and perform pre-employment substance abuse testing and detailed background verification.
Nearest Major Market: Denver
Job Segment:
Cloud, Data Warehouse, Computer Science, Behavioral Health, Database, Technology, Healthcare