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
Didn't find what you're looking for? Search again!
Loading more jobs...