Business Intelligence (BI) Developer

at  Cosmetic Physician Partners

Are you passionate about building cutting-edge solutions and want to be part of something big from the ground up?
We’re Tovanah Analytics, a data analytics SaaS provider, transforming the way healthcare organizations use data with our innovative platform. Our mission is to empower clinics with advanced analytics that drive better decision-making.

JOB SUMMARY

We are seeking an experienced Business Intelligence (BI) Developer to join our data engineering team.
As one of our first software developer hires, you’ll play a pivotal role in shaping our technology and building the foundation for scalable, impactful products. This is an exciting opportunity to work directly with the founding team, make critical technical decisions, and leave your mark on a product that will change the healthcare landscape
Reporting to the CTO, you will be responsible for designing, developing, and maintaining BI solutions that transform raw data into actionable insights. This individual will work closely with Tovanah’s founders to understand reporting needs, create dashboards, and ensure the integrity of data used in decision-making processes. The ideal candidate will have strong analytical skills, experience in data warehousing, and proficiency in BI tools, data visualizations, and SQL queries and schemas.
If you’re ready to take on a challenge and create something truly meaningful, we’d love to hear from you!

REQUIRED SKILLS AND QUALIFICATIONS:

• Education: Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field.
• 3+ years of experience in business intelligence, data analysis, data visualization, or a similar role.
• Proficiency in BI tools such as Power BI, Tableau, Looker, Metabase, or similar.
• Strong SQL skills and experience in database schemas, data modeling, ETL development, and database querying.
• Experience with data warehousing concepts and tools (e.g., Google BigQuery, Snowflake, Redshift, and PostgreSQL).
• Experience with SQL query performance and optimization is a plus.
• Familiarity with programming languages such as JavaScript.
• Strong analytical and problem-solving skills with attention to detail.
• Excellent communication skills with the ability to present complex data insights to both technical and non-technical audiences.

PREFERRED QUALIFICATIONS:

• Experience in cloud platforms such as Google Cloud Platform, AWS or Azure.
• Knowledge of machine learning or advanced analytics techniques.
• Industry certifications in BI tools or data platforms.
  Work Environment: Hybrid Preferred.

COMPÉTENCES ET QUALIFICATIONS REQUISES :

• Formation : Baccalauréat en informatique, en technologies de l’information, en science des données ou dans un domaine connexe.
• 3+ années d’expérience en business intelligence, analyse de données, visualisation de données ou un rôle similaire.
• Maîtrise des outils BI tels que Power BI, Tableau, Looker, Metabase ou similaire.
• Solides compétences SQL et expérience dans les schémas de base de données, la modélisation de données, le développement ETL et l’interrogation de bases de données.
• Expérience avec les concepts et outils d’entreposage de données (par exemple, Google BigQuery, Snowflake, Redshift et PostgreSQL).
• Une expérience avec les performances et l’optimisation des requêtes SQL est un plus.
• Familier avec les langages de programmation tels que JavaScript.
• Solides compétences analytiques et de résolution de problèmes avec une attention aux détails.
• Excellentes compétences en communication avec la capacité de présenter des informations de données complexes à des publics techniques et non techniques.

QUALIFICATIONS PRÉFÉRÉES :

• Expérience dans les plateformes cloud telles que Google Cloud Platform, AWS ou Azure.
• Connaissance de l’apprentissage automatique ou des techniques d’analyse avancées.
• Certifications sectorielles dans les outils BI ou les plateformes de données.
  Environnement de travail : Hybride préféré.

• Data Analysis & Reporting:
• Gather and analyze business requirements to design BI solutions.
• Develop, maintain, and manage reports, dashboards, and visualizations using BI tools (e.g., Power BI, Tableau, Looker, or custom analytics).
• Translate complex data from multiple sources into clear, insightful visualizations that facilitate business decision-making.
• Data Integration & Modeling:
• Design and implement data models, ETL processes, and data transformations to integrate data from various internal and external sources.
• Develop optimized and efficient SQL queries to extract and transform data.
• Collaborate with data engineers and database administrators to build and maintain efficient data pipelines.
• Optimize and troubleshoot BI solutions for performance and scalability.
• Collaboration & Stakeholder Management:
• Work closely with business stakeholders, such as finance, marketing, and operations teams, to understand their reporting needs.
• Collaborate with cross-functional teams to ensure data accuracy, consistency, and reliability in BI deliverables.
• Provide technical support and training to business users to help them utilize BI tools effectively.
• Data Quality & Governance:
• Ensure that BI solutions adhere to data governance standards and best practices.
• Monitor data quality and collaborate with teams to resolve data-related issues.
• Ensure compliance with company data security policies and practices.