Full-Time Senior Business Intelligence Engineer

Job Title: Senior Business Intelligence Engineer

Lead the design, development, and maintenance of business intelligence solutions that transform clinical, operational, and financial data into actionable insights.

This role combines technical expertise with healthcare domain knowledge to drive data-driven decision-making across the organization while ensuring compliance with healthcare regulations and data privacy requirements.

Responsibilities:

• Design, implement, and continuously expand data pipelines by performing ETL/ ELT.
• Gather requirements and business process knowledge in order to transform the data in a way that’s geared towards the needs of end users.
• Take over responsibilities for developing and maintaining Prompt’s Business Intelligence Platform.
• Enable Prompt’s BI platform to support third party data ingestion and third party data extraction.
• Make contributions towards Prompt’s overall data model.
• Maintain and improve already existing processes.
• Ensure that the data architecture is scalable and maintainable.
• Work with the business in designing and delivering correct, high quality data.
• Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions.
• Prepare documentation for future reference.
• Participate in code reviews and architecture discussions to exchange actionable feedback with peers.
• Contribute to engineering best practices and mentor junior team members.
• Help break down complex projects and requirements into sprints.
• Ability to create insightful dashboards and present findings to internal and external stakeholders.

Skills:

• 10+ YOE working with cloud based databases, data lakes, data warehouses (S3, RDS, AWS Athena, AWS Redshift etc.)
• Expert SQL knowledge (query performance tuning, index maintenance, etc.) as well as an understanding of database structure
• Knowledge of data modeling principles
• Knowledge of at least one ETL/ data transformation framework/ service (AWS Glue, Data Build Tool (dbt))
• Basic understanding of CI/CD process and systems (Gitlab Pipelines, Github Actions, etc.)

What is the last date for applying to the job?

Which countries are accepted for this remote job?