Data Engineer - Columbus, OH

Abbott•Columbus, OH

8d•$60,000 - $120,000•Onsite

About The Position

Data Engineer - Columbus, OH Abbott is a global healthcare leader that helps people live more fully at all stages of life. Our portfolio of life-changing technologies spans the spectrum of healthcare, with leading businesses and products in diagnostics, medical devices, nutritionals and branded generic medicines. Our 114,000 colleagues serve people in more than 160 countries. JOB DESCRIPTION: Data Engineer - Columbus, OH Working at Abbott At Abbott, you can do work that matters, grow, and learn, care for yourself and family, be your true self and live a full life. You’ll also have access to: Career development with an international company where you can grow the career you dream of. Employees can qualify for free medical coverage in our Health Investment Plan (HIP) PPO medical plan in the next calendar year. An excellent retirement savings plan with a high employer contribution. Tuition reimbursement, the Freedom 2 Save student debt program, and FreeU education benefit - an affordable and convenient path to getting a bachelor’s degree. A company recognized as a great place to work in dozens of countries worldwide and named one of the most admired companies in the world by Fortune. A company that is recognized as one of the best big companies to work for as well as the best place to work for diversity, working mothers, female executives, and scientists. The Opportunity Our nutrition business develops science-based nutrition products for people of all ages, from helping babies and children grow, to keeping adult bodies strong and active. Millions of people around the world count on our leading brands – including Similac®, PediaSure®, Pedialyte®, Ensure®, Glucerna® and Juven® – to help get the nutrients they need to live their healthiest life. Our location in Columbus, OH , currently has an opportunity for a Data Engineer. This position requires a balance of technical skills, teamwork, strong communication and critical thinking. Responsible for refining and maintaining the data environment for the Therapeutic Nutrition Sales Analytics team and associated field sales segments. Additionally, the position will be a key player in the development of tools to help assist management and the field sales teams in driving results for the business. The candidate must be capable of working under general direction while leveraging input from team members and functionality of available tools/resources to deliver efficient and timely results. Must demonstrate the willingness to learn the business, challenge the status quo and balance multiple priorities while keeping a positive and inquisitive mind-set.

Requirements

Bachelor's degree or equivalent experience required.
Typically requires 4-6 years of progressive finance, operations, analytics, or IT experience which includes analytics and/or sales support responsibility.
In depth knowledge Azure SQL Server/Synapse - Transact-SQL (DDL & DML)
Know how to create tables, views, stored procedures, functions using only SQL scripts
In depth knowledge of SQL Server SELECT (window functions, sub selects, recursive relationships, etc).
Understand how to performance tune / index tables, add constraints
Explain data types and general differences varchar, integer, bigint, decimal, real.
Understand and be able to explain data flow from/to a reporting tool like Tableau (possibly Power BI). ex: explain the flow of data from an Azure Synapse database all the way to an (on premise physical) Tableau server user using a web browser.
Familiarity with Azure Data Factory
Ability to convey message clearly, concisely, and accurately, both verbally and through report development.
Demonstrates initiative, critical thinking and problem-solving skills.
Strong attention to detail.
Ability to work effectively both independently and in team settings.
Willingness and aptitude to balance day-to-day responsibilities and new projects/challenges to help the business and team evolve.
Ability to form interpersonal, professional relationships across the internal and field sales teams.

Nice To Haves

Familiarity with Azure Logic Apps, Alteryx, Tableau, Power BI
Fundamental understanding of authentication/authorization concepts Example understand difference between windows and SQL Server authentication. understand concept of what “row level security” means.
Fundamental cloud concepts Difference between ETL and ELT
Fundamental data warehousing/data mart concepts. Understand and be able to explain “star schema” and why is it important?
Explain difference between OLTP and OLAP.

Responsibilities

Continuous upkeep and improvement of the data environment which requires input from multiple sources.
Consistently staying abreast of industry/company direction and evaluate different options to help shape the long-term direction of the team.
Delivering timely inputs to sales and other cross-functional teams.
Key member of informal project teams tasked with development of sales reporting, incentive measurement, customer-facing deliverables and other items as required.
Other related tasks as assigned by manager.

Benefits

Career development with an international company where you can grow the career you dream of.
Employees can qualify for free medical coverage in our Health Investment Plan (HIP) PPO medical plan in the next calendar year.
An excellent retirement savings plan with a high employer contribution.
Tuition reimbursement, the Freedom 2 Save student debt program, and FreeU education benefit - an affordable and convenient path to getting a bachelor’s degree.
A company recognized as a great place to work in dozens of countries worldwide and named one of the most admired companies in the world by Fortune.
A company that is recognized as one of the best big companies to work for as well as the best place to work for diversity, working mothers, female executives, and scientists.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume