Business Intelligence Engineer

About SpectoraSpectora is the leading SaaS home inspection platform, with a 7-year track record of helping home inspectors build successful businesses through our world-class inspection software. Our flagship product is an all-in-one business solution that helps inspectors conduct and share inspections, manage and automate their operations, and market their business.Were proud to say Spectora is the market leader in the home inspection space, an achievement possible because of our fanatical focus on our customers, product, and team. We go head-to-head with bigger competitors with deeper pockets every day and are winning.And we win because of our people.Our culture is driven by our scrappy, hilarious, and relationship-focused team, who bring IQ and EQ to the table. We push ourselves and each other to grow in our careers and as people and are focused on being the best versions of ourselves every day. Spectora is a genuinely exceptional place to work (if we do say so ourselves).Want to hear about our culture directly from the team? https://youtu.be/ticzqdTGAloAbout the PositionWe are seeking our first Business Intelligence Engineer to drive data-informed decision making across Spectora to fuel our growth in a focused way. As we further solidify our market-leading position in the home inspection industry, meaningful business insights will be crucial in making the right decisions. Our Business Intelligence Engineer will take on a new role within our Finance & Operations team as we unlock valuable insights about how our customers and business have operated. Youll report directly to the Head of Finance & Operations and have a unique opportunity to shape this role from the ground up, creating your own processes and methodologies. Youll often work directly with our CEO and other leaders to transform raw data into actionable insights that drive our product development, customer success, and growth strategies. As a BI Engineer, you will be responsible for designing, developing, and optimizing our data pipeline, enabling our teams to make informed, data-driven decisions. You will be an expert in creating scalable data solutions using Postgres, Snowflake, and Domo and/or Holistics. Your role will be critical in transforming raw data into business insights through ETL processes, data modeling, and creating robust reports and dashboards.Core ResponsibilitiesData Integration and Management:Quickly develop a deep understanding of our platform database and infrastructureDesign and implement ETL processes to integrate data from various sources into Snowflake.Develop and manage Snowflake data models, ensuring data accuracy, consistency, and efficiency.Familiar with backend technologies to integrate data solutions with our application and automate data-related workflows.Able to maintain and expand our data warehouse (Snowflake) to ensure it supports current and future analytics needs.Optimize data loading, transformation, and retrieval processes for performance.Reporting and Visualization:Create and maintain interactive and visually appealing dashboards and reports in visualization tools (ie: Holistics, Domo).Translate complex data sets into actionable insights through effective data visualization techniques.Customize and enhance visualization applications to meet specific business needs and objectives.Data Analysis:Collaborate with business stakeholders to understand their data needs and requirements.Perform ad-hoc data analysis and provide actionable recommendations based on findings.Develop and maintain key performance indicators (KPIs) and metrics to track business performance.Collaboration and Communication:Work closely with cross-functional teams to gather requirements and deliver BI solutions that support business goals.Communicate technical concepts and findings to non-technical stakeholders in a clear and understandable manner.Provide training and support to end-users on our BI tools, data analysis best practices and overall data literacyIdentify opportunities for data-driven improvements in our product, systems, processes and operations and take action on collaborating with other teams to implement themQuality Assurance:Ensure data integrity and accuracy by implementing robust data validation and testing procedures.Monitor and troubleshoot BI systems and applications to resolve issues promptly.Stay updated with industry trends and best practices to continually improve BI processes and tools.Who You AreYou have 5+ years in SaaS companies with large databases, preferably with newer Business Intelligence functions. Youll need to have enough experience to set up systems and processes from scratch and as a team of one.Youre a self-starter who thrives in ambiguity and gets excited by the prospect of building our business intelligence function from the ground up.Youre great at data analysis, advanced SQL querying, schema design and enabling teams to make data-driven decisionsYou have experience with BI tools Domo and/or HolisticsYou have experience building and integrating data solutions.You have a combination of technical expertise in data engineering and business acumenYou have a solutions-oriented mindset and dont require a perfect set of circumstances before taking action- Spectora is in the messy middleYoure gifted in understanding data requirements to turn complex data into actionable data insightsYoure a great communicator. Spectora has a strong culture built on connection, optimism, hard work, and loving what we do. To be effective in your role, youll need to value similar things and influence through excellent communicationYou have a strong sense of pride and ownership in your work. We do, and so do our inspectorsWe encourage you to apply even if you dont meet every bullet point. We are people, not checklists, and we hire as such!Pay & BenefitsJob Type: Full-TimeOTE: $110,000-$130,000 per year (US Only)Total Rewards:Insurance: Medical, dental, and vision, employer paid life insurance, employer paid short & long term disabilityPaid Time Off: Unlimited vacation and sick time, plus paid parental leaveRetirement: 401k and matchingRemote work: employees receive a home office reimbursement How to Apply:Want to go the extra mile or make your resume stand out? Email jobs@spectora.com with your CV and a personalized note or video on why you'd be a great fit. Show us who you really are. We want to get to know YOU!Spectora strives to create an inclusive environment where everyone is set up for success and looks forward to coming into work everyday. As an equal opportunity employer, we prohibit discrimination in our hiring process and strongly encourage women, people of color, LGBTQ+ individuals, people with disabilities, members of ethnic minorities, foreign-born residents, and veterans to apply.recblid i11nx7pnnfba1m2jaj8s79bielwyyb