BI Developer | Portugal

Transforming Data into Decisions – One Insight at a Time!

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 

As a BI Developer on our team, you will work in a collaborative and supportive environment to create critical reports and tools. Team members are self-motivated and demonstrate flexibility to assist on a variety of tasks. 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. 

How will you make an impact at Envision Pharma Group? 

Role responsibilities 

• Develops reports using BI application.
• Proficiently works with PostgreSQL, Mongo DB, or MS SQL Server, including the development and management of SQL scripts.
• In-depth understanding of database management systems, online analytical processing (OLAP), and ETL (Extract, Transform, Load) framework.
• Analyses and understands various data models in depth; proactively define data structures additions (views, distribution methods, intermediate tables, multidimensional cubes) that would improve performance or add value.
• Develops, distributes, and provides support for reports and or dashboards in a timely manner, prioritizing multiple requests and maintaining a support relationship with all users.
• Manages and monitors scheduled execution of routine processes and reports, diagnosing and fixing any report related issues while maintaining excellent open communication internally and externally.
• Works within established guidelines, standards and methodologies for creating BI solutions and documentation.
• Conducts validation testing of all data exchanged, migrated, archived, imported, to and from the applications.
• Maintains knowledge of industry standards, as well as, federal, state and local healthcare regulatory requirements, including but not limited to, HIPAA and IRB policies and procedures, to ensure all deliverables meet those standards.
• Supports quarterly or ad-hoc audits.
• Utilizes change management processes and techniques in an appropriate manner.
• Collaborate and contribute as a team member: understand personal and team roles; contribute to a positive working environment by building solid relationships with team members; proactively seek guidance, clarification, and feedback.

Do you have what we are looking for? 

Skills & expertise 

• CEFR English level B1 or greater required.
• Associate's Degree in Business Administration, Information Systems, Computer Science, or similar discipline required. Bachelor's degree in the same or related field preferred. An equivalent combination of experience, consisting of five (5) plus years of same or similar work experience, may substitute for minimum education requirements.
• Minimum of two (2) years of proven business analysis experience with work in a data analytics/data warehouse role and with business process re-engineering and architecture required.
• Solid SQL experience (SQL scripts, stored procedures, ETL, etc.). Experience developing reports/dashboards with any BI application, such as Power BI, Epic Cogito, Crystal Reports, Cognos, Tableau, Qlik, etc. required.
• Ability to take large data sets and summarize down to actionable levels, turning analysis into answers.
• Excellent attention to detail, patience, and a positive, customer centric attitude.
• Develops and maintains positive relationships with all customers, key stakeholders, and departmental colleagues.
• Clear demonstrations of critical thinking, technical, analytical, organizational, and problem-solving skills.
• Ability to identify the appropriate technological solutions for various reporting needs.

#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!