Senior Business Intelligence Engineer

Posted 3 days agoViewed

💎 Seniority level: Senior, 7+ years

📍 Location: United States

💸 Salary: 136000.0 - 170000.0 USD per year

🔍 Industry: Software Development

⏳ Experience: 7+ years

🪄 Skills: Project ManagementSQLData AnalysisETLTableauData visualizationData modeling

7+ years of strong SQL/Tableau/Looker development experience
7+ years of experience in data modeling, ETL development, data warehousing, visual report development
7+ years of hands on experience in highly collaborative analytics environments
7+ years of experience working with big data technologies (Redshift, S3, Databricks, Datalakes, DBT, etc)
2+ years experience with DBT data modeling in production environments
Knowledge of data management fundamentals and data storage principles
Strong project management experience leading multiple large projects

Gather business requirement documents and able to propose technical solutions and prototypes that can answer business questions and fostering self-service via your solutions
Experience with event level data to create aggregated data tables for analysis and reporting
Triage and optimize data reporting ETL via collaboration with data analysts and data engineers to design and build long term implementations
Collaborate with cross functional leads to build out comprehensive reporting suite that enables both analysts and business users to make fast decisions
Proactively identify areas of improvement within data modeling process, documentation, and reporting development process

Posted about 1 month ago

📍 United States, Canada

🧭 Full-Time

🔍 Healthcare

🔧 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
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

💡 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

AWSDockerPythonSQLETLGitData modeling

Posted about 1 month ago