Job Description
Tegra is seeking an Associate Data Strategy Analyst to support recurring client data operations within our Life Sciences Data Operations, Automation and Analytics practice. This entry to early career role is ideal for candidates looking to build technical depth while working within structured frameworks that emphasize disciplined execution, data harmonization, ETL processing, reporting refreshes, and rigorous quality control. Associates contribute to incremental automation improvements while developing independence and strong analytical foundations. Based in Columbia, SC or Doylestown, PA with an initial in person work arrangement and potential hybrid or remote flexibility, this role offers the opportunity to grow within a firm rooted in integrity, integration, and accountability. At Tegra, we deliver customized solutions across sales force strategy, incentive compensation design, optimization, and advanced analytics, partnering with clients to make confident strategic decisions through creativity, proactive thinking, and long-term relationship building.
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.
Key Responsibilities
Data Integration & ETL Support
- Ingest and harmonize healthcare and sales-related datasets in accordance with established rules and data mappings.
- Execute and monitor recurring ETL workflows to ensure timely and accurate data processing.
- Perform structured quality control checks, including record counts, reconciliations, and trend validation, to ensure data integrity.
- Clearly document data issues and escalate risks or inconsistencies to senior team members as appropriate.
- Maintain organized file structures, naming conventions, and workflow documentation in alignment with team standards.
Reporting & Tools
- Refresh and validate dashboards (e.g., Power BI) to ensure accuracy and alignment with defined reporting standards.
- Prepare recurring, stakeholder-ready reports in Excel, ensuring data accuracy and clear presentation of insights.
- Support CRM data extracts and incentive compensation reporting processes in collaboration with senior team members.
- Assist with web-based tool data imports, performing validation checks to ensure completeness and accuracy.
Automation & Governance
- Contribute to the development and maintenance of reusable scripts and templates (SQL, Python, VBA).
- Execute data warehouse refresh routines in accordance with established governance standards and team processes.
- Maintain and update runbooks and process documentation as needed.
Collaboration
- Participate in client and internal meetings as applicable.
- Communicate task completion clearly and efficiently, proactively identifying and escalating blockers or risks to team.
Qualifications
Required:
- Bachelor’s degree
- Strong Excel proficiency
- Working knowledge of SQL
Preferred:
- Python and/or VBA
- Power BI or Tableau exposure
- Familiarity with AWS/Azure
- Understanding of MDM and data privacy concept
Success Measures
- Reliable, on-time workflow execution
- Low defect rate through disciplined QC
- Clear documentation and escalation
- Demonstrated technical growth and increasing independence
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
Employment Eligibility
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.
Commitment to Equal Opportunity
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.
