Business Systems Analyst

Alpharetta GA Abbott Laboratories

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.

Business Systems Analyst

Position Location: Alpharetta, GA, Austin, TX or Minneapolis-St. Paul, MN

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 Business Systems Analyst 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.
  • Manage 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.
  • 3+ 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.
  • Demonstrated experience developing canvas Power Apps
  • Demonstrated experience with Microsoft SQL Server including managing databases and the use of Microsoft SSMS/Azured data studio.
  • Demonstrated experience writing and troubleshooting T-SQL statements, creating stored procedures, views, and SQL functions.

Preferred Qualifications

  • Medical device or diagnostics industry experience is highly preferred.
  • Salesforce and SAP experience.
  • Conga CLM experience.
  • Strong SQL coding experience developing and deploying SSIS packages for ETL processes and performance optimization.
  • Strong Power BI experience writing DAX expressions and implementing row-level security.

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

The base pay for this position is $72,700.00 – $145,300.00. In specific locations, the pay range may vary from the range posted.

To apply for this job please visit itjobpro.com.