Business Intelligence Engineer
Posted Updated
Description
As a Business Intelligence Engineer, you'll design, build, and deploy BI solutions and reliable, accurate data marts that drive business growth and make operations more efficient. This is a hands-on role: you'll own ETL development, write the SQL behind reports and data models, build dashboards, and support the analytics platforms in production. With 5-7 years of experience, you translate business needs into technical specifications and deliver solutions that internal and external customers rely on.
What You'll Do:
- Design, build, and deploy BI solutions and data marts for internal and external customers
- Build dashboards and custom reports using tools such as Sisense, Power BI, or Tableau
- Provide ad-hoc reports where self-service isn't available or possible
- Develop and enhance ETL/ELT processes using tools such as Fivetran and dbt
- Write database queries, stored procedures, functions, and views in PostgreSQL and BigQuery
- Continuously improve BI systems and data structures for performance, accuracy, integrity, and security
- Spot data trends and fix data quality issues quickly, completely, and permanently
- Support analytics platforms in production: troubleshooting and testing across PostgreSQL, BigQuery, and BI tools
- Follow the software development life cycle across all development work
- Work with IT peers and business partners to balance production support, service requests, and roadmap initiatives
- Maintain BI documentation and source system data mapping
- Share domain and technical expertise through mentoring and cross-training
What You'll Need (Must Have):
- 5-7 years in business intelligence, data warehousing, or data engineering
- Advanced SQL: queries, stored procedures, functions, and views
- ETL/ELT: hands-on development and enhancement of ETL packages and processes
- Databases & OLAP: hands-on experience with database management systems and online analytical processing
- BI Tools: you've built dashboards yourself in Sisense, Power BI, Tableau, or similar
- JSON and XML
- Strong analytical skills: able to translate business needs into technical specifications
- Proficiency in MS Office, especially Excel
- Bachelor's degree in Computer Science, Information Technology, or a related engineering field
Good to Have:
- Google BigQuery and PostgreSQL
- Fivetran and dbt
- Experience with Sales, Operations, and Finance data and platforms
- Business systems such as general ledger, HRIS, or CRM
- Industry certifications in data or cloud technologies
Skills
Sign in to read and join the discussion.