Senior Business Intelligence Engineer
DigitalOceanabout 1 year ago
San Francisco, California, United States
Remote
Full-time
Junior Level (1-3 years)
Job Description
Position Overview
DigitalOcean is seeking a highly experienced Senior Business Intelligence Engineer to join our dynamic team. This pivotal role is perfect for a seasoned professional passionate about leveraging data to drive strategic business decisions and optimize reporting processes within our cloud computing infrastructure.
Key Responsibilities
- Strategic BI System Management: Lead the design, development, and maintenance of our comprehensive BI systems, ensuring scalability, reliability, and alignment with evolving business needs.
- BI Optimization & Innovation: Proactively identify and implement strategies to optimize existing reporting processes, enhance data visualization, and introduce innovative reporting solutions that provide actionable insights.
- Data Architecture & Modeling: Design and implement robust data models and architectures using dbt that support efficient data storage, retrieval, availability, analysis, and comprehensive BI reporting.
- ETL Development: Develop and maintain complex ETL (Extract, Transform, Load) processes to ensure data is accurately and efficiently integrated across various systems.
- Data Warehousing: Build and maintain performant data warehouses and data lakes to support advanced analytics and reporting needs.
- Data Analytics & BI Reporting: Develop and maintain BI infrastructure to enable in-depth stakeholder analysis and reporting.
- Performance Optimization: Monitor and optimize the performance of data pipelines and query execution to ensure efficient processing and analysis.
- Cross-functional Collaboration: Work closely with product managers, data scientists, marketing managers, and other engineers to translate complex business requirements into robust BI solutions.
- Documentation: Create and maintain detailed documentation of data architectures, processes, and best practices.
Required Qualifications
- Strong communication and analytical skills with the ability to derive insights from complex data patterns and present them to the executive team.
- Extensive experience with dbt, data modeling techniques, and best practices, with a proven track record of building sophisticated and optimized data models.
- Expert-level proficiency in SQL and extensive experience with relational databases (e.g., PostgreSQL, MySQL).
- Deep understanding of data architecture and best practices, including automation, governance, lineage, and dependency management.
- Significant experience with data warehousing solutions (e.g., Redshift, Snowflake, BigQuery).
- Advanced familiarity with BI tools, with Looker preferred.
- Strong experience with ETL tools and frameworks (e.g., Apache Airflow).
- Proven experience with cloud platforms (e.g., AWS, Azure, Google Cloud) and cloud-based data services.
- Demonstrated ability to independently identify and solve complex BI problems and optimize reporting workflows.
Benefits & Perks
- We innovate with purpose – join a cutting-edge technology company focused on simplifying cloud and AI so builders can create transformative software.
- We prioritize career development by providing reimbursements for relevant conferences, training, education, and access to over 10,000 LinkedIn Learning courses.
- We care about your well-being with a competitive benefits package including an Employee Assistance Program, local meetups, and flexible time off.
- Compensation: The salary range for this role is $165,600 - $249,600 based on market data, years of experience, and skills. Bonus potential and equity compensation (including eligibility for equity grants and participation in the Employee Stock Purchase Program) are also offered.
- We value diversity and inclusion, recognizing that unique perspectives strengthen our teams and deliver superior products to our customers.
- This is a remote role.
Required Skills
dbt
Apache Airflow
MySQL
ETL
Data Warehousing
Cloud Platforms
Data Modeling
PostgreSQL
Snowflake
Looker
Redshift
SQL
BigQuery