PROJECT DESCRIPTION

We are dedicated to building a developer-centric Business Intelligence (BI) solution. Our goal is to track, visualize, and measure development and product-related metrics from multiple sources to gain valuable insights into various business segments.
We are developing a robust BI solution that spans four critical data segments:
Products - Insights on product usage related to software.
Planning/Financials - Retrospective planning and financials, focusing on capitalization, depreciation, spend, and assets.
Development Implementation - Insights on development performance (e.g., DORA), although this is not a current priority.
Our priority is to enhance visibility into our “NEEDS Process” and software capitalization & depreciation process. We have integrated data from Jira and an internal Resource Management Tool into a BigQuery and Looker-based solution, with plans to integrate Datadog.

SKILLS

Must have
Looker, LookerML: strong experience and knowledge of Looker and LookML
Advanced understanding of LookML for data visualization and direct data adaptation within Looker.
experience with BigQuery
Jira experience: familiarity with Jira, as it is a primary data source.
SQL proficiency: strong command of SQL for data manipulation and analysis.
Version control and task management: experience with git code repositories and version control.
Detail-oriented: meticulous attention to detail to ensure the reliability and accuracy of data presented in dashboards.
Nice to have
ETL Processes: Knowledge of ETL processes, even though they are not currently implemented.
Additional BI Tools: Exposure to other BI tools and platforms, enhancing flexibility and innovation in our BI solutions.

Integrate and adapt data from various sources directly within Looker, ensuring a seamless and efficient process.
Create and maintain insightful dashboards that provide reliable and actionable insights.
Conduct rigorous quality checks to ensure data integrity and accuracy.
Work closely with cross-functional teams to understand data requirements and deliver effective BI solutions.
Stay updated with the latest developments in BI technologies and methodologies to continuously enhance our BI capabilities.