Data Strategy Analyst

Prominence Advisors•Columbia, SC

23h

About The Position

Tegra is seeking a Data Strategy Analyst to lead recurring client data operations within our Life Sciences Data Operations, Automation and Analytics practice. This role independently manages structured data workflows while contributing to solution design, automation strategy, and client-facing execution. Analysts are expected to apply strong technical judgment, navigate ambiguity, and ensure disciplined execution across data harmonization, ETL processing, reporting, and quality control. In addition to owning day-to-day operations, Data Strategy Analysts proactively improve processes to enhance scalability, data reliability, and efficiency. At Tegra, we deliver customized solutions across sales force strategy, incentive compensation design, optimization, and advanced analytics—partnering with clients to enable confident, data-driven decision-making through integrity, integration, and accountability. Who We Are Prominence Advisors, in conjunction with Tegra Analytics, helps healthcare and life sciences organizations unlock the full value of their data through enablement and strategy. We partner with leading organizations to turn complex information into actionable insights that improve outcomes, strengthen operations, and drive sustainable growth. Founded by experienced industry leaders, Prominence is an award-winning firm recognized for multiple Best in KLAS honors and over 30 Best Places to Work accolades. We guide clients through technology strategy, implementation, analytics, and governance to build trusted, scalable data ecosystems that deliver measurable impact. With more than 25 years of life sciences and commercial strategy experience, Tegra delivers customized solutions across data operations, automation, analytics, and performance optimization—combining disciplined execution with proactive, creative thinking. Together, we are united by integrity, accountability, and collaboration. We are people-first and excellence-driven—committed to doing great work, building lasting partnerships, and turning data into clarity, strategy into action, and vision into results.

Requirements

Bachelor’s degree
Strong SQL and Excel proficiency
Experience managing recurring production data workflows

Nice To Haves

2–4+ years relevant experience
Python and/or VBA automation
Power BI or Tableau experience
AWS/Azure exposure
Experience in client-facing analytics environments

Responsibilities

Lead ingestion, harmonization, and transformation of healthcare and sales datasets.
Own end-to-end recurring ETL workflows, ensuring timely, accurate and reliable delivery.
Perform advanced quality control analyses, identifying root causes and resolving data integrity issues.
Manage crosswalks, matching and deduplication logic, and data consistency across sources.
Design and implement automation solutions (e.g., SQL, Python, VBA) to improve efficiency and scalability of recurring workflows.
Optimize ETL and distribution workflows to reduce manual effort and enhance reliability.
Recommend and implement improvements to warehouse structures and governance practices to strengthen data integrity and consistency.
Lead dashboard refresh validation and implement reporting enhancements to ensure accuracy, usability, and alignment with client objectives.
Translate business requirements into structured reporting outputs.
Actively participate in client meetings, managing topics independently when needed.
Mentor Associates and review junior-level deliverables as needed to ensure consistency and adherence to team standards.