Apply on Employer Site

Abbott · 8 hours ago

Data Engineer - Columbus, OH

Columbus, OH

Full-time

Onsite

Mid Level

$60K/yr - $120K/yr

4+ years exp

Abbott is a global healthcare leader that helps people live more fully at all stages of life. They are seeking a Data Engineer to refine and maintain the data environment for the Therapeutic Nutrition Sales Analytics team, develop tools for management and field sales teams, and communicate effectively with cross-functional partners.

BiotechnologyEmergency MedicineGeneticsHealth CareHealth DiagnosticsManufacturingMedicalMedical DeviceNutritionPharmaceutical

H1B Sponsor Likely

Responsibilities

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

Qualification

Azure SQL Server/SynapseTransact-SQLData flow explanationAzure Data FactoryTableauPower BICritical thinkingProblem-solvingAttention to detailTeamworkCommunication skills

Required

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

Preferred

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

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.

Company

Abbott

Glassdoor3.8

Abbott is a healthcare company that produces diagnostic kits, medical devices, nutritional products, and branded generic medicines.

Founded in 1888

Illinois City, Illinois, USA

10001+ employees

https://www.abbott.com

H1B Sponsorship

Abbott has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2021 (1)