Senior Business Intelligence Engineer Job Description

Senior Business Intelligence Engineer Job Description Template

Our company is looking for a Senior Business Intelligence Engineer to join our team.

Responsibilities:

  • Evaluate and make recommendations on new technologies, tools and guide the team on up-to-date technologies, standards, and practices;
  • Peer-review code developed by team members;
  • Participate in developing projects plan, timelines and providing estimates;
  • Convey key stakeholder insights through data storytelling;
  • Perform problem analysis, resolution, and root-cause documentation;
  • Lead and guide the evolution of various data management functions (Data Catalog, Data Prep, Data Lineage & Metadata Management functions);
  • Troubleshoot reported defects to determine the root cause;
  • Add new data sources to our cloud-based enterprise data warehouse using industry-standard extract, transform, load (ETL) tools;
  • Participate in daily scrum calls and provide clear visibility to work products;
  • Assist in our recruiting and interviewing process;
  • Work with business partners and data science teams to understand business context and Insights being pursued;
  • Perform robust unit test for applications developed and validate expected results;
  • Work collaboratively with other engineers to hydrate the enterprise data lake;
  • Design and develop SQL-based database views in our enterprise stack to enable multi-sourced data analysis;
  • Contribute to the internal knowledge base to build expertise and awareness within the organization.

Requirements:

  • Good knowledge of data warehousing tools, patterns, and processes;
  • Record of building innovative solutions;
  • Passionate about data and contributing to the growth of a data driven organization;
  • Knowledgeable with ETL processes;
  • Strong SQL skills and experience in SQL Server;
  • Should be an excellent communicator, and should possess excellent debugging skills and problem-solving skills;
  • Experience with BI tools (preferably Looker), building dashboards, and reporting;
  • Ability to interpret written requirements and technical specification documents;
  • Excellent SQL and PL/SQL coding skills;
  • Good coding skills according to published standards and design guidelines;
  • Understanding of the processes of data quality, data cleansing, and data transformation;
  • Practical experience with Python scripting;
  • Direct experience with ETL tools such as Informatica Cloud (preferred), Pentaho Data Integration (PDI), or other ETL tool(s);
  • At least 2 years of experience in BI development;
  • Knowledge of columnar databases like Amazon Redshift.