About OpenLoop
OpenLoop was co-founded by CEO, Dr. Jon Lensing, and COO, Christian Williams, with the vision to bring healing anywhere.
Our telehealth support solutions are thoughtfully designed to streamline and simplify go-to-market care delivery for companies offering meaningful virtual support to patients across an expansive array of specialties, in all 50 states.
Funciones del cargo
- Data Modeling and Transformation: Design and maintain efficient data models (star/snowflake schemas) to support self-service analytics and dashboard creation.
- Data Transformation: Work with raw data from various sources and ensure proper transformation and enrichment before visualization.
- Dashboard and Report Development: Build and optimize dashboards and visualizations using tools such as Power BI, Tableau, or Zoho Analytics, with performance and scalability in mind.
- Dashboard Optimization: Support performance and scalability of dashboards; help automate data refreshes and improve usability.
- Data Integration Support: Collaborate with data engineers to validate data pipelines and ensure correct ingestion and transformation of data sources.
- Stakeholder Collaboration: Partner with BI Analysts and business teams (finance, ops, customer success) to understand reporting needs and translate them into scalable technical solutions.
- Performance Metrics: Develop and track key performance indicators (KPIs) to measure the success of business initiatives.
- Documentation and Best Practices: Maintain technical documentation and advocate for BI standards and best practices within the organization.
- Performance Optimization: Troubleshoot and optimize dashboard performance, SQL queries, and data refresh cycles.
- Other duties as assigned.
Requerimientos del cargo
- 2–4 years of experience in analytics, BI, or data roles.
- Bachelor's degree in Data Science, Engineering, Statistics, Computer Science, or a related field.
- Strong skills in SQL and data transformation (e.g., dbt, Snowflake, or similar).
- Experience with BI tools (Power BI, Tableau, Looker, or Zoho Analytics).
- AWS skills
- Understanding of dimensional modeling and semantic layer concepts.
- Coding experience (e.g., Python) is a plus, but not mandatory.
- Strong communication and collaboration skills with both technical and non-technical teams.
- Self-driven, autonomy, teamwork and strategic mindset.
- Strong analytical skills with attention to detail and accuracy.
Opcionales
Condiciones
- Contract under a Peruvian company ID(Planilla).
You will receive all the legal benefits in Peruvian soles (CTS, Gratificaciones, etc).
- Monday - Friday workdays, full time (9 am - 6 pm).
- Unlimited Vacation Days - Yes We want you to be able to relax and come back as happy and productive as ever.
- EPS healthcare covered 100% with RIMAC --Because you, too, deserve access to great healthcare.
- Oncology insurance covered 100% with RIMAC
- AFP retirement plan—to help you save for the future.
- We'll assign a computer in the office so you can have the best tools to do your job.
- You will have all the benefits of the Coworking space located in Lima - Miraflores (Free beverage, internal talks, bicycle parking, best view of the city)