Senior Business Intelligence Engineer

Summary

Join Prompt, a rapidly growing healthcare technology company, as a Senior Business Intelligence Engineer. Lead the design, development, and maintenance of business intelligence solutions, transforming data into actionable insights. This role requires expertise in data pipelines, database management, and data modeling, along with strong communication and collaboration skills. You will work with various cloud-based databases and big data technologies, ensuring data architecture scalability and maintainability. The position offers a remote/hybrid work environment, competitive salary, equity compensation potential, and comprehensive benefits package. This is a foundational role impacting product growth, team development, and company strategy.

Requirements

• 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
• Organizational skills: time management and planning
• 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.)
• Version control with Git using branching strategies and feature flags
• Good working knowledge of Docker and how to build reusable images for development and production use
• Experience with at least one backend programming language: Python/Java/Go/Ruby/PHP/etc
• Knowledge of various SQL/NoSQL data storage mechanisms and Big Data technologies
• High attention to detail
• Passionate about complex data structures, problem solving and ability to pick up new data tools and concepts quickly

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

Benefits

• Competitive salaries
• Remote/hybrid environment
• Potential equity compensation for outstanding performance
• Flexible PTO
• Company-wide sponsored lunches
• Company paid disability and life insurance benefits
• Company paid family and medical leave
• Medical, dental, and vision insurance benefits
• Discounted pet insurance
• FSA/DCA and commuter benefits
• 401k