Abbott
Sr. BI Developer/Data Engineer
Job Description
JOB DESCRIPTION:
Sr. BI Developer/Data Engineer
Position Location: Alpharetta, GA
NOTE: This position is required to be in-office 4 days a week with 1 day remote. This is not a fully remote position.
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.
- Free medical coverage for employees* via the Health Investment Plan (HIP) PPO
- An excellent retirement savings plan with 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 around the world and named one of the most admired companies in the world by Fortune.
- A company that’s recognized as one of the best big companies to work for as well as a best place to work for diversity, working mothers, female executives, and scientists.
The Opportunity
The Sr. BI Developer/Data Engineer will support the Medical Devices U.S. Sales Division. You’ll develop new and/or enhance existing business-owned systems and applications. The primary business-owned applications include the source of pricing (SOP) SQL Server database, Power BI reporting and Power Apps tools that support a substantial portion of the Medical Device’s Contract Life Cycle Management (CLM) and Revenue Management System (RMS).
What You’ll Work On
- Lead, influence, and develop robust tools leveraging innovative analytical software such as Power Platform (e.g., Power Query, Power BI, Power Automate, Power Apps) for internal use by the Strategic Pricing & Contracting (SP&C) team.
- Develop new Power BI reports/dashboards for SP&C Analyst consumption.
- Develop and customize Microsoft SQL Server Integration Services (SSIS) packages to automate and refine processes.
- Administer daily/weekly ETL (Extract, Transform & Load) processes to update existing business owned applications.
- Conduct routine quality checks of data to ensure applications are highly accurate and reliable for SP&C Analyst consumption.
- Conduct routine maintenance, troubleshoot, and resolve system bugs in a timely manner.
- Collaborate with SP&C Team and identify opportunities to enhance and improve business owned applications.
- Develop detailed project plans to develop, test, implement and train end users as enhancements are implemented.
- Document new and existing workflows in well-organized and thoughtful manner.
- Create technical documentation and cross-train peers to ensure adequate back-up coverage and job redundancy.
- Proactively identify and investigate opportunities to implement new innovative technology.
- Create and demonstrate proof of concepts to assess feasibility, gain buy-in and drive adoption of new technology.
- Collaborate with DevOps as needed to test and implement enhancements to IT owned applications (i.e., SAP, Salesforce, Conga).
- Travel: 10% (domestic).
Required Qualifications
- Bachelor’s degree in business, computer science or an equivalent combination of education and work experience.
- 5+ years of related work experience with a strong understanding of specified functional area.
- Sound knowledge of database management, SQL querying, data modeling, data warehousing, and business intelligence.
- Demonstrated experience creating data-rich Power BI reports/dashboards, writing DAX expressions, and implementing row-level security.
- Demonstrated experience developing canvas and model driven Power Apps
- Demonstrated experience with Microsoft SQL Server including managing databases and the use of Microsoft SSMS/Azured data studio.
- Demonstrated experience working with Microsoft SSIS to create and deploy packages and deploy for ETL processes.
- Demonstrated experience writing and troubleshooting T-SQL statements, creating stored procedures, views, and SQL functions.
- Strong SQL coding experience with performance optimization experience for data queries
Preferred Qualifications
- Medical device or diagnostics industry experience is highly preferred.
- Salesforce and SAP experience.
- Conga CLM experience.
* Participants who complete a short wellness assessment qualify for FREE coverage in our HIP PPO medical plan. Free coverage applies in the next calendar year.
Learn more about our health and wellness benefits, which provide the security to help you and your family live full lives: www.abbottbenefits.com
Follow your career aspirations to Abbott for diverse opportunities with a company that can help you build your future and live your best life. Abbott is an Equal Opportunity Employer, committed to employee diversity.
Connect with us at www.abbott.com or on Facebook at www.facebook.com/Abbott.
The base pay for this position is
$95,000.00 – $190,000.00
In specific locations, the pay range may vary from the range posted.
JOB FAMILY:
IT Services & Solutions Delivery
DIVISION:
MD Medical Devices
LOCATION:
United States > Alpharetta : 3650 Mansell Road
ADDITIONAL LOCATIONS:
WORK SHIFT:
Standard
TRAVEL:
Yes, 10 % of the Time
MEDICAL SURVEILLANCE:
No
SIGNIFICANT WORK ACTIVITIES:
Continuous sitting for prolonged periods (more than 2 consecutive hours in an 8 hour day), Keyboard use (greater or equal to 50% of the workday)
Abbott is an Equal Opportunity Employer of Minorities/Women/Individuals with Disabilities/Protected Veterans.
EEO is the Law link – English: http://webstorage.abbott.com/common/External/EEO_English.pdf
EEO is the Law link – Espanol: http://webstorage.abbott.com/common/External/EEO_Spanish.pdf
