BI Reporting and Analytics Lead

Company: AutoGrid Systems
Location: Redwood City
Posted on: January 16, 2023

Job Description:

AutoGrid Company OverviewThe world's leading energy companies turn to AutoGrid to integrate all distributed energy resources, turn on new revenue streams and drive deeper engagement with their customers. Our suite of Energy Internet applications allows utilities, electricity retailers, renewable energy project developers and energy service providers to deliver clean, affordable and reliable energy in a distributed energy world.How do we do this? By pioneering the science of flexibility management. This innovative approach enables energy providers to mine the Energy Internet's rich data lode to extract flexible capacity from distributed energy resources. In turn, flexible capacity can be used to balance energy supply and demand in real time, increase the productivity and value of energy assets, and deliver new energy services to customers.Established at Stanford University in 2011, we have assembled a team of world-class software architects, electrical and computer engineers, data scientists and energy experts who apply cutting-edge analytics and in-depth energy data science to solve the world's most critical energy problems.Business Intelligence at AutoGridAutoGrid's Business Intelligence (BI) Data Engineering team is looking for an experienced Data Engineering and Reporting leader who can take charge of our existing Data Warehouse and BI Reporting Platform, and lead its next generation of development and scale. This role will work closely with engineers based in India, and help them drive both the feature roadmap forward, as well as review, investigate, scope and deliver the next generation of platform and usability improvements. These improvements can range from inclusion of new technology stacks, to significant overhauls of the user experience. This role will own this area of the AutoGrid platform, and will be in charge of evolving and scaling it going forwards!Job Responsibilities

• Own our business intelligence reporting and data pipelining capabilities end-to-end by working closely with product managers and other stakeholders to lead the design and development of product and business intelligence data pipelines and reports. Lead and mentor the team of remote engineers, and help manage the scrum and roadmapping process.
• Develop and maintain scalable data pipelines and build out new integrations and processes required for optimal extraction, transformation, and loading of data from a variety of data sources using HiveQL and other open source big data technologies.
• Design our data warehouse and data models for optimal storage and retrieval, in order to meet critical product and business requirements.
• Performs root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Assemble large, complex data sets that meet functional / non-functional business requirements and foster data-driven decision making across the organization.
• Implements processes and systems to validate data, monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it.
• Guide the team to develop and maintain end-to-end Data Warehouse AutomationTechnical Requirements

• 4+ years experience in writing, testing and maintaining data pipelines and reporting applications in Big Data environments, developed in tools such as Python, Bash, SQL, Scala, Hive
• 3+ years experience designing and developing data visualization frontends using tools like Tableau
• 2+ years experience mentoring and leading software engineering or analytics teams
• Knowledge of software design patterns is a must.
• Exposure to data warehousing, data pipeline development and analytics using open source Big Data Stacks like Hadoop (Hive, HBase, Oozie, Sqoop, HDFS, S3)
• Significant experience in SQL, preferably HQL (Hive Query Language)
• Exposure to customer-facing requirements gathering and feedback sessions and processes
• Experience with different database technologies
• Exposure to scrum and agile development methodologiesBenefits and Perks
  • Working with a smart, collaborative, and fun group of people solving big important problems
  • An exciting atmosphere, operating at the leading edge of clean energy software
  • Beautiful, spacious, modern office in Redwood Shores
  • Flexible hours and remote-friendly
  • Competitive salary and equity
  • Competitive health care, dental, and vision coverage
  • Excellent 401(k) and flexible spending plans
  • Three weeks of paid time off annually, in addition to 10 paid public holidays
  • Life, short term and long-term disability, supplemental, and AD&D insurance
  • Commuter transit, parking, biking, vanpool and park & ride benefitsAutoGrid is an equal opportunity employer. We do not make hiring, employment or promotion decisions based on race, religion, color, sex, age, national origin, ancestry, sexual orientation, gender or identity or expression, pregnancy or pregnancy-related condition, marital status, height and/or weight.

Keywords: AutoGrid Systems, Redwood City , BI Reporting and Analytics Lead, Advertising , Redwood City, California