SDE BI Developer

Any Level | Full Remote


SDE BI Developer
Any Level | Full Remote

SDE BI Developer will be responsible for understanding the domain, business cases, objectives, and KPIs that need to be reported and analyzed. Responsibilities include:

  • Data exploration to unravel data sources and identify the granularity, attributes and measures
  • Coordinating and collaborating with data engineering team and BI leads to ensure timely project delivery
  • Understanding of data warehouse concepts and modeling the DW objects in the BI tool for reporting
  • Identifying errors and opportunity areas and provide recommendations on top of existing solutions
  • Strong story-telling capability through visualizations and guided analytics-driven smart dashboards

Perch Insights

SDE – BI Developer
Company Overview:

Perch is an AI driven data analytics platform for customer experience (CX) organizations to drive excellence through better data-driven decision making. No other CX business intelligence platform structures data from multiple data sources such as CRMs and customer service platforms, contact center applications, chatbots, marketing platforms, and HR systems into a single source of truth and then provides actionable insights like Perch. Perch offers the best way for CX leaders and their colleagues across the enterprise to see the forest through the trees to increase market share, improve the customer journey and increase operational efficiency. We are achieving these goals by leveraging the latest technologies in AI, data and software engineering. Here are some of the core product modules that we are working on every day:

  1. AI Copilot provides a revolutionary new analytics experience where users ask business questions and the AI interprets and responds with relevant charts and insights to answer those questions. This is actively being built using the latest GPT/LLM technologies along with our own semantic layer and AI models to generate insights and answers.
  2. Guided Analytics provides dashboards for fast, actionable root cause analysis powered by AI-driven contribution-to-change (CTC) models that help identify which factors are driving KPIs higher or lower the most.
  3. Proactive Alerts monitor the data for real-time insights and push them to users for faster action and higher impact across multiple channels.
  4. CX Data Platform combines a standard data model based on our domain expertise with best-of-breed, scalable data pipelines and transformations leveraging DBT, Airflow, Airbyte and other modern data stack technologies.

The Perch Founding Team has a unique set of experiences/expertise across business operations, analytics and engineering in the CX and contact center industries. The Perch founders have built Full Potential Solutions (which is Perch’s parent company) into a large, rapidly growing business with thousands of employees in five years, and launched Perch to take advantage of the massive market opportunity in AI-driven data analytics specifically in the CX space. Perch has a unique culture that is focused on conscious leadership. We believe that increasing self-awareness leads to maximum growth for each individual and the team as a whole. And we believe that work should be an environment to practice how to grow and become a better person each day, and through that process we will also achieve greatness as a company. We strive to live each day by our core Perch Insights values of curiosity, candor, integrity, ambition, accountability, and mindfulness. So if this sounds exciting to you, then apply to join our team.


Technical Requirements

  1. Bachelor’s degree in a Technical/Quantitative subject such as Computer Science (B.E/B.Tech/MCA)
  2. 4+ years relevant experience in the field of BI Reporting, Data Analytics, Data Warehouse/BI solutions
  3. Proficient in SQL (advanced functions), query optimization, and ad-hoc data analysis using SQL/Python
  4. Ability to use live connection in the BI tool and construct advanced analytical SQL queries for reporting
  5. Import the data model from the data warehouse into the semantic layer/BI tool & define business KPIs
  6. Develop reports and dashboards with adept visualizations in BI tools presenting the business metrics
  7. Create Python based customized visualizations when BI tool is absent or doesn’t have native visualization
  8. Appropriate utilization of advanced visualizations like scatter plots, heat maps, area charts, histograms etc
  9. Knowledge of programming concepts around customization in BI tool using CSS/HTML/JavaScript/NodeJS
  10. Must have worked with RDS or data lakes (MySQL, PostgreSQL, Oracle, Redshift, Snowflake, etc.)
  11. Hands-on experience in using BI tools like Tableau, Power BI, Looker, Sisense Fusion, Oracle BI etc.
  12. Develop statistical analysis visualizations establishing linkages b/w leading & lagging business metrics

Skills that will give you an edge (Good to Have)

  1. Knowledgeable on statistical data analysis techniques (linear regression, A/B testing, correlation etc)
  2. Well-versed with the data warehouse modeling concepts (star/ snowflake/ denormalized structures)