Business Intelligence Developer
Description
Shockwave Medical, Inc. is a pioneer in the development and commercialization of Intravascular Lithotripsy (IVL) to treat complex calcified cardiovascular disease. Shockwave Medical aims to establish a new standard of care for medical device treatment of atherosclerotic cardiovascular disease through its differentiated and proprietary local delivery of sonic pressure waves for the treatment of calcified plaque.
Position Overview
We are searching for a talented and experienced Business Intelligence Developer to join our growing team. You will be responsible for designing, building, and maintaining data pipelines using technologies like Fivetran, Azure Data Factory and Python into our Snowflake data warehouse and transforming the data using tools like dbt and Coalesce. You will also be responsible for building visualizations using Power BI.
Essential Job Functions
- Create dashboards and advanced visualizations in Power BI
- Design, develop, and maintain data pipelines using Fivetran, Python, dbt/coalesce and Airflow from varied sources.
- Primary sources include Oracle Fusion Cloud, Salesforce, among many others.
- Write efficient SQL queries to transform and clean data for optimal consumption in Snowflake.
- Implement data quality checks and monitoring processes to ensure data accuracy and consistency.
- Collaborate with data analysts and business stakeholders to understand data requirements and design data models.
- Document data pipelines and processes for maintainability and knowledge sharing.
- Monitor and optimize data pipeline performance for efficiency and scalability.
- Troubleshoot and resolve data pipeline issues to ensure data availability.
- Implement data observability tools like Monte Carlo
- Stay up to date on the latest trends and technologies in the modern data stack (Snowflake, Fivetran, dbt, etc.).
Requirements
- 5+ years of experience as a Business Intelligence Developer or similar role.
- Must have skills – Power BI and Snowflake
- Experience in design, development, and deployment of BI solutions using Power BI (datasets, DAX, RLS etc.)
- Proven experience with designing and building data pipelines.
- Experience with Snowflake, Fivetran, Airflow and dbt
- Monte Carlo or other data observability tools experience a plus
- Strong knowledge of SQL and experience with data transformation techniques.
- Excellent problem-solving and analytical skills.
- Proficiency in extracting and loading data from the following two source applications - Oracle Fusion Cloud (Finance, Supply Chain, Manufacturing), Salesforce a huge plus
- Strong communication and collaboration skills.
- Ability to work independently and as part of a team.
- Excellent project management and team leadership skills.
- Strong interpersonal and communication skills to collaborate effectively with business partners cross-functional teams.
Market Range: $107,000 - $134,000
Exact compensation may vary based on skills, expertise, and location
Benefits
Shockwave Medical offers a competitive total compensation package as well as the following benefits and perks:
Core Benefits: Medical, Dental, Vision, Pre-tax and Roth 401k options with a fully vested match, Short-Term and Long-Term Disability, and Life Insurance, Employer contribution toward Health Savings Account (HSA), Competitive PTO balance
Perks: ESPP, Calm App, Pet Insurance, Student Loan Refinancing, Spot Bonus awards
EEO Employer
Exact compensation may vary based on skills, expertise, and location
Benefits
Shockwave Medical offers a competitive total compensation package as well as the following benefits and perks:
Core Benefits: Medical, Dental, Vision, Pre-tax and Roth 401k options with a fully vested match, Short-Term and Long-Term Disability, and Life Insurance, Employer contribution toward Health Savings Account (HSA), Competitive PTO balance
Perks: ESPP, Calm App, Pet Insurance, Student Loan Refinancing, Spot Bonus awards
EEO Employer