SQL Analyst

Supportive team. Meaningful work. Real client impact.

Work shouldn't just be something we do; it should have purpose. At Envision, we believe in creating life-changing outcomes through the work we do with our clients, giving back to our communities, while creating a company culture where our people thrive. We believe success starts with a workplace where everyone feels valued, supported, and empowered to grow. 

Being part of a collaborative team means there's no limit to what you can achieve. With us, you can be a part of a growing company you want to work for. 

Our Vision: To unleash the power of combined intelligence to accelerate patient access to life-changing treatments. 

Our Mission: Delivering smarter and faster solutions to create, communicate, and commercialize value for our clients. 

Our Values: Excellence, People, Growth 

The opportunity 

We are looking for individuals with strong analytical backgrounds and a passion for healthcare to join the Riparian team.

As an SQL Analyst on our team, you will work in a collaborative and supportive environment to create insights and value for clients. Team members are self-motivated and demonstrate flexibility to assist on a variety of tasks. 

During your first month of employment, onboarding will take place in person at our Coimbra office (doDOC Lda., IPN Incubadora 3030-199, Coimbra, Portugal), Monday through Friday. After the initial onboarding period, employees typically work from the office 2–3 days per week.

How will you make an impact at Envision Pharma Group? 

Role responsibilities 

Identify and address client needs: build relationships with clients; develop an awareness of our services; approach client in an organized manner; deliver clear requests for information; demonstrate flexibility in prioritizing and completing tasks; communicate potential conflicts to a supervisor.

• Detect outliers in data and research to identify the cause of the anomaly.
• Setting up variance thresholds, determining reasonability of results.
• Prepare monthly and quarterly pricing and rebate deliveries by defined timelines.
• High accuracy rate and compliance with applicable legal requirements and policy and procedures serving as the foundation of the SOC controls and compliance.
• Reconciliation of payments or other finance functions.
• Interpret and analyse large datasets to develop solutions to support business needs.
• Support to ongoing process and system development, especially in times of evolving government and commercial program changes.
• Set-up and on-going workflow maintenance around internal and leading industry software.
• Ability to read, research, and understand guidance from US government programs and other agencies while retaining, applying, and growing your knowledge base.

Do you have what we are looking for? 

Skills & expertise 

Ideal candidates will have a strong financial background based on a combination of education, experience, or both. Competency with data analysis tools at a minimum; a background in healthcare, pharmaceuticals or Life Sciences is a plus, as well as an ability to rapidly learn and apply new concepts.

• CEFR English level B1 or greater required.
• Bachelor or Master's degree in Technology, Computer Science, Accounting, Finance, Mathematics, or related field.
• Experience working with large data sets or proficiency with data tools such as MS Excel is required.
• Experience with SQL is required.
• Experience working with data analytical or data visualization tools such as Tableau and QlikView is a plus.
• Familiarity with database structures and ability to understand underlying tables.
• High degree of analytical and quantitative problem-solving skills.

#TogetherWeDiscover  

We turn vision into reality. Our people are integral to our success and our values reflect the Envision philosophy where our teamwork helps us all grow and our enthusiasm inspires each other. 

Our Envisionary culture is a special environment that gives every employee a voice, the space to invent, and the chance to excel. A place where, every day, people laugh, think, take risks, and are excited about the possibilities the day brings. 

Explore your place at Envision. If you have the experience highlighted above, we would love to hear from you!