Software Engineer I - Data Engineer (BI)

The Position

We are seeking a seasoned engineer with a passion for changing the way millions of people save energy. You’ll work within the Engineering team to build and improve our platforms to deliver flexible and creative solutions to our utility partners and end users and help us achieve our ambitious goals for our business and the planet. 

We are seeking a skilled and passionate Data Engineer - Business Intelligence with expertise in Data Engineering and BI Reporting to join our development team. As a Data Engineer, you will play a crucial role developing different components, harnessing the power of data to unveil captivating stories and intricate patterns. You'll contribute to data gathering, storage, data processing and identifying the crucial data required for insightful analysis. As a Data Engineer, you'll tackle obstacles related to database integration and untangle complex, unstructured data sets. You will also work on creating BI reports as well as development of a Business Intelligence platform that will enable users to create reports and dashboards based on their requirements. You will coordinate with the rest of the team working on different layers of the infrastructure. Therefore, a commitment to collaborative problem solving, sophisticated design, and quality product is important.

You will own the development and its quality independently and be responsible for high quality deliverables. And you will work with a great team with excellent benefits.

Responsibilities & Skills

You should: 

• Be excited to work with talented, committed people in a fast-paced environment. 

• Have a proven experience as a Data Engineer with a focus on BI reporting..

• Be designing, building, and maintaining high performance solutions with reusable, and reliable code.

• Use a rigorous approach for product improvement and customer satisfaction.

• Love developing great software as a seasoned product engineer.

• Be ready, able, and willing to jump onto a call with stakeholders to help solve problems. 

• Be able to deliver against several initiatives simultaneously.

• Have a strong eye for detail and quality of code.

• Have an agile mindset.

• Have strong problem-solving skills and attention to detail.

Required Skills (Data Engineer): 

• You ideally have more than 6 months of professional experience. 

• Design, build, and maintain scalable data pipelines and ETL processes to support business analytics and reporting needs.

• Strong Experience with SQL for querying and transforming large datasets, and optimizing query performance in relational databases.

• Proficiency in Python for building and automating data pipelines, ETL processes, and data integration workflows.

• Familiarity with big data frameworks such as Apache Spark or PySpark for distributed data processing.

• Strong Understanding of data modeling principles for building scalable and efficient data architectures (e.g., star schema, snowflake schema).

• Good to have experience with Databricks for managing and processing large datasets, implementing Delta Lake, and leveraging its collaborative environment.

• Knowledge of Google Cloud Platform (GCP) services like BigQuery, Dataflow, Pub/Sub, and Cloud Storage for end-to-end data engineering solutions.

• Familiarity with version control systems such as Git and CI/CD pipelines for managing code and deploying workflows.

• Awareness of data governance and security best practices, including access control, data masking, and compliance with industry standards.

• Exposure to monitoring and logging tools like Datadog, Cloud Logging, or ELK stack for maintaining pipeline reliability.

• Ability to understand business requirements and translate them into technical requirements.

• Inclination to design solutions for complex data problems.

• Ability to deliver against several initiatives simultaneously as a multiplier. 

• Demonstrable experience with writing unit and functional tests.

Required Skills (BI Reporting): 

• Strong experience in developing Business Intelligence reports and dashboards via tools such as Tableau, PowerBI, Sigma etc.

• Ability to analyse and deeply understand the data, relate it to the business application and derive meaningful insights from the data.

The following experiences are not required, but you'll stand out from other applicants if you have any of the following, in our order of importance: 

• You are an experienced developer - a minimum of 2+ years of professional experience. 

• Work experience & strong proficiency in Python, SQL and BI Reporting and its associated frameworks (like Flask, FastAPI etc.).

• Experience with cloud infrastructure like AWS/GCP or other cloud service provider experience 

• CI/CD experience 

• You are a Git guru and revel in collaborative workflows 

• You work on the command line confidently and are familiar with all the goodies that the linux toolkit can provide 

• Familiarity with Apache Spark and PySpark.

Qualifications

• Bachelor's or Master's degree in Computer Science, Engineering, or a related field.

Uplight provides equal employment opportunities to all employees and applicants and prohibits discrimination and harassment of any type without regard to race (including hair texture and hairstyles), color, religion (including head coverings), age, sex, national origin, caste, disability status, genetics, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.