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.