Mango Sciences

Role Overview

We are seeking a Senior SQL Developer & ETL Engineer with 5+ years of experience for a 100% remote opportunity.

Please Note: This is not a pure Data Engineering role. We are looking for a true SQL Specialist. Your core strength must lie in relational database development, schema design, and writing high-performance database logic with Python, ETL, Cloud. SQL mastery and database architecture are the absolute heart of this role.

If you are a database developer who loves diving into query execution plans, refactoring messy stored procedures for 10x performance, and building clean data models from scratch, this role is for you.

Key Responsibilities

1. Database Architecture & Schema Design

• Design, implement, and maintain robust relational database schemas.
• Architect optimal data models for both operational (OLTP) and analytical (OLAP/Data Warehousing) workloads.
• Implement Normalization (3NF) and dimensional modeling (Star/Snowflake schemas) as required.

2. Advanced Database Programmability

• Write, debug, and optimize highly complex Stored Procedures, Functions, Triggers, and Views to handle core business logic at the database level.
• Utilize advanced SQL techniques such as CTEs, Window Functions, and complex analytical queries to solve business problems.

3. Performance Tuning & Indexing

• Analyze query execution plans, identify performance bottlenecks, and implement advanced indexing strategies (B-Tree, Clustered/Non-Clustered, Partitioning).
• Refactor legacy SQL code and manage statistics, locking, and concurrency mechanisms to ensure sub-second response times.

4. Python & Cloud ETL/ELT Pipelines

• Develop, schedule, and maintain scalable data ingestion and transformation pipelines to connect disparate data sources.
• Leverage Cloud Data Platforms alongside modern Python libraries to build efficient data movement workflows.

5. Data Integrity & Governance

• Establish strict database constraints, data validation routines, and automated quality checks to guarantee absolute data accuracy.

Required Technical Skills

• Expert-Level SQL & DB Programmability (5+ Years): Mastery of writing server-side logic (Stored Procedures/Functions) and complex queries in enterprise platforms like PostgreSQL, SQL Server, Oracle, or MySQL.
• Advanced Database Optimization: Deep, under-the-hood understanding of database engines, execution plans, indexing strategies, and concurrency/locking control.
• Python for Data Engineering (3+ Years): Proficient in writing clean, modular Python scripts for API integration, data manipulation, and ETL processing (using libraries like Pandas, SQLAlchemy, or custom database connectors).
• Cloud Data Experience: Hands-on experience working with, migrating to, or developing within major cloud environments (AWS, Azure, GCP) and modern cloud data warehouses (Snowflake, BigQuery, or Redshift).
• Data Modeling Methodologies: Practical experience designing Star/Snowflake schemas, handling Slowly Changing Dimensions (SCD), and balancing normalization vs. denormalization.

Remote & Soft Skills

• Legacy Refactoring Mindset: You genuinely enjoy opening up a massive, poorly optimized 500-line legacy stored procedure and refactoring it for maximum efficiency.
• Autonomous Execution: Proven ability to manage your own time, architecture tasks, and deliverables without micromanagement in a fully remote setup.
• Asynchronous Communication: Exceptional written and verbal English communication skills to collaborate seamlessly across time zones.

Nice-to-Haves

• Experience migrating legacy on-premise infrastructure and stored procedures to modern cloud data warehouses.
• Familiarity with workflow orchestration tools like Apache Airflow or Prefect.
• Hands-on experience with dbt (data build tool) for in-warehouse transformations.

Job description:

Role Overview

We are seeking a Senior SQL Developer & ETL Engineer with 5+ years of experience for a 100% remote opportunity.

Please note: This is not a standard Big Data / Infra-heavy Data Engineering role. We are specifically looking for a SQL Specialist. Your core strength must lie in relational database development, schema design, and writing high-performance database logic. Python will be your primary tool for moving and orchestrating data, but SQL and database architecture are the heart of this role.

Key Responsibilities

• Database Architecture & Schema Design: Design, implement, and maintain robust relational database schemas, ensuring optimal data modeling (OLTP and OLAP/Data Warehousing).
• Advanced Database Programmability: Write, debug, and optimize complex Stored Procedures, Functions, Triggers, and Views to handle core business logic at the database level.
• Performance Tuning & Indexing: Analyze query execution plans, identify bottlenecks, and implement advanced indexing strategies, partitioning, and query refactoring to ensure sub-second response times.
• Python ETL/ELT Pipelines: Develop, schedule, and maintain scalable data ingestion and transformation pipelines using Python to connect disparate data sources.
• Data Integrity & Governance: Establish constraints, data validation routines, and automated quality checks to guarantee absolute data accuracy.

Required Technical Skills

• Expert-Level SQL & DB Programmability (5+ Years): Mastery of writing complex queries (CTEs, Window Functions, Analytical queries) and server-side logic (Stored Procedures/Functions) in platforms like PostgreSQL, SQL Server, Oracle, or MySQL.
• Advanced Database Optimization: Deep understanding of how databases work under the hood—specifically indexing (B-Tree, Hash, Clustered/Non-Clustered), execution plans, statistics, and locking/concurrency mechanisms.
• Python for Data Ingestion (3+ Years): Proficient in writing clean, modular Python scripts for data manipulation, API integration, and ETL processing (using libraries like Pandas, SQLAlchemy, or custom database connectors).
• Data Modeling Methodologies: Practical experience designing Star/Snowflake schemas, Normalization (3NF), and handling Slowly Changing Dimensions (SCD).

Remote & Soft Skills

• Autonomous Execution: Proven ability to manage your own time, architecture tasks, and deliverables without micromanagement.
• Asynchronous Communication: Exceptional written and verbal English communication skills to collaborate seamlessly across time zones.
• Legacy Refactoring Mindset: You enjoy opening up a massive, poorly optimized 500-line stored procedure and refactoring it for 10x performance.

Nice-to-Haves

• Experience migrating legacy on-premise stored procedures to modern cloud data warehouses (Snowflake, BigQuery, Redshift).
• Familiarity with workflow orchestration tools like Apache Airflow or Prefect.
• Experience with dbt (data build tool).

Work Location: Remote

We are seeking a forward-thinking professional who can manage technology projects related to development of healthcare data and AI platforms, drive agile process management for product development success, plan and track team resource allocation and task progress, and engage and communicate with company leadership.

As part of a Health Tech company, this role is critical in articulating how our AI-powered solutions unlock data access, interoperability, and generation of insights, models, and product value — transforming healthcare operations, patient outcomes, revenue opportunities with payer and biopharma clients and executive decision-making.

Key Responsibilities:

●    Technology Project Management

○    Lead internal teams and stakeholders in process to plan, execute, track, and evaluate performance in executing on projects delivering company healthcare data platform and AI products.

○    Develop agile project processes and workflows using Jira and other project and development tools that drive successful, timely, and efficient delivery of technical contributions to company products and services.

○    Work with team leads and management to engage new projects, allocate and track team effort, tasks, deliverables, and outcomes.

●    Project Portfolio Strategy and Roadmap

○    Contribute to technical & operational capabilities into clear business outcomes for executive decision-makers.

○    Proactively engage, monitor project portfolio health and mitigate risks.

●    Product Demonstrations

○    Deliver tailored demos showcasing how technical solutions transform healthcare workflows and decision-making.

○    Highlight AI-driven use cases such as predictive analytics, automated reporting, and intelligent data integration.

○    Support sales cycles with compelling, executive-ready presentations.

Qualifications:

●    Bachelor’s degree in engineering or other technical field.

●    5+ years of experience in project management, delivering technology products and services.

●    Strong experience with stakeholder management and managing project delivery with multiple teams.

●    Strong understanding of modern IT systems, data flows, value creation through insights and models developed governance.

●    Familiarity with AI/ML concepts, especially generative AI applications in healthcare.

●    Exceptional leadership, teamwork coordination, and communication skills.

Success Metrics:

●    Retention and satisfaction of strategic healthcare accounts.

●    Growth & expansion in hospital partnerships through CIO engagement.

●    Demonstrated adoption of advanced technologies & GenAI solutions tied to data access and utilization.

●    Demo-to-conversion success with executive stakeholders.

Job description:

Product Manager – Healthcare Technology (AI & Data Platforms)Position Overview

We are seeking a highly strategic, entrepreneurial, and impact-driven Principal Product Manager with 7 to 12 years of experience to lead the vision, strategy, and execution of our AI-powered healthcare technology and data platforms.

In this role, you will bridge the gap between complex health data systems and scalable product solutions. You will own the lifecycle of products designed to unlock clinical insights from massive, real-world data assets (EHR, EMR, and patient-level datasets), with a strong focus on scaling GenAI, AutoML, and advanced analytics frameworks. Operating at the intersection of technology, engineering, and business growth, you will drive cross-functional alignment and build data products that ultimately optimize care delivery, predict clinical trends, and expand healthcare access.

Key Responsibilities

• Product Strategy & Vision: Define and execute the end-to-end product strategy and roadmap for advanced healthcare analytics platforms, translating complex technical and clinical capabilities into intuitive, high-value user experiences.
• GenAI & AutoML Innovation: Act as the strategic product champion for next-generation AI initiatives. Conceptualize and scale GenAI tools (e.g., natural language interfaces, automated dataset generators) and AutoML pipelines to drastically reduce insight generation turnaround times.
• Lifecycle Management: Lead cross-functional alignment across engineering, data science, data solutions, UI/UX, and commercial teams to deliver data ingestion, predictive ML model deployment, and visualization dashboards from scratch.
• Cross-Functional & Team Leadership: Matrix-manage or directly guide cross-functional squads of up to 15–20 engineers, data scientists, and business analysts. Champion agile product development methodologies and build internal alignment across complex stakeholder landscapes.
• Stakeholder Management & Growth: Partner with executive leadership and external clients to uncover market requirements. Support business development efforts by prototyping rapid-response solutions that secure enterprise-level contracts and partnerships.

Required Experience & Qualifications

• Experience: 7 to 12 years of overall experience, with a proven track record as a Product Manager delivering complex, high-impact data science, AI, or B2B SaaS solutions within the Healthcare Technology, Digital Health, or Life Sciences domains.
• Education: MBA from a premier institute (e.g., IIM or equivalent) with a strong strategic/analytical focus, paired with a solid foundational background in Computer Science, Engineering, or Statistics.
• Domain & Data Expertise: Deep knowledge of healthcare data ecosystems, electronic health records (EHR/EMR), and the nuances of handling anonymized patient-level datasets (e.g., IQVIA, Optum, Truven, Komodo, or similar health data repositories).
• Technical & Analytical Acumen: * Strong familiarity with data infrastructure, machine learning pipelines, and cloud environments (Databricks, AWS, or Dataiku).
• Hands-on familiarity with analytical visualization applications (Power BI, Spotfire, Tableau) and database querying (SQL, Python).
• Ability to converse deeply with data engineers and ML scientists regarding algorithmic structures, prompt engineering, and LLM implementations.
• Core Competencies: Exceptional storytelling and executive presentation skills. A natural problem-solver with an entrepreneurial mindset who thrives in fast-paced environments and can drive alignment across global teams.

Work Location: Remote