Data Engineer - Columbus, OH

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 diagnostics, medical devices, nutritionals and branded generic medicines. Our 114,000 colleagues serve people in more than 160 countries.

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

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®, Pedia Sure®, 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.

• Continuous upkeep and improvement of the data environment which requires input from multiple sources. The candidate must possess the ability to understand key performance indicators and metrics through engagement with various cross‑functional partners, develop efficient methods of preparing the data and the ability to clearly communicate effective use of the data to team members.
• Consistently staying abreast of industry/company direction and evaluate different options to help shape the long‑term direction of the team. Key contact for internal IT and all third‑party data tool vendors.
• 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.

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

• Familiarity with Azure Logic Apps, Alteryx, Tableau, Power BI
• Fundamental understanding of authentication/authorization concepts – e.g., 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 it is important.
• Explain difference between OLTP and OLAP.

Learn more about our benefits that add real value to your life to help you live fully:

Follow your career aspirations to Abbott for diverse opportunities with a company that provides the growth and strength to build your future. Abbott is an Equal Opportunity Employer, committed to employee diversity.

The base pay for this position is $60,000.00 – $. In specific locations, the pay range may vary from the range posted.