Data Strategy Analyst

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.

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.

Data Integration & Workflow Ownership

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

Automation & Process Improvement

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

Reporting & Client Engagement

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

Qualifications

Required:

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

Preferred:

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

Success Measures

• Independent ownership of recurring workflows
• Measurable automation and efficiency gains
• Reduced data defects and repeat issues
• Strong client trust and stakeholder feedback
• Contribution to scalable process improvements

Prominence is dedicated to hiring the best and brightest minds in healthcare and maintaining a culture that rewards our employees for following their passion. We’ve won Modern Healthcare’s Best Places to Work Award and have been voted to Chicago’s 101 Best and Brightest companies list three years running. Our most recent designation is being named in the top 10 by Consulting magazine as one of the Best Small Firm to Work For.

We are excited to offer the following benefits for this position:

• Competitive Compensation Plans
• Health Care Plan (Medical, Dental & Vision)
• Retirement Plan (401k)
• Life Insurance (Basic, Voluntary & AD&D)
• Paid Time Off (Vacation/Sick & Public Holidays)
• Training & Development Fund

Must be legally authorized to work in the United States without sponsorship. This online application is not intended for anyone who is currently under a non-compete agreement or has an arrangement that precludes employment at Prominence.

The world’s most talented professionals come from every background. All applicants will be considered for employment without attention to age, race, color, religion, gender identity and/or expression, sexual orientation, national origin, marital status, veteran or disability status, or any other characteristic protected by law. In addition, Prominence will provide reasonable accommodations for qualified individuals with disabilities.

If you are smart and good at what you do, come as you are. All qualified candidates are encouraged to apply.

Interested in learning more? Apply below to connect with our Talent team about immediate openings and future consulting projects.