Job Description
Our client operates at the crossroads of energy and home services, fueled by the vision of a smarter, cleaner future. Committed to developing groundbreaking solutions, they aim to streamline their customers’ lives by providing energy, protection, and smart services for their homes and businesses.Our client is seeking a Data Engineer, Business Intelligence to join its Retail Business Intelligence team to strengthen their BI capabilities. The position requires 4+ years of data management, modelling, and BI experience. The successful candidate will possess a strong data modeling, data visualization background and will provide expertise and best data engineering practices. The candidate should have a demonstrable record of being able to interact effectively with business stakeholders in all functional areas to gather and understand business requirements and reporting needs. Ability to learn new technologies, welcome challenges, accept new responsibilities, work well as individual and as a team and adapt quickly is essential.
Essential Duties/Responsibilities:
- Gather large and complex data sets to meet business requirements.
- Re-designing data marts for scalability and optimization.
- Ensure data architecture supports existing and future requirements of evolving business model
- Identify, design, and implement process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
- Create and maintain documentation for each step in the data lifecycle
- Develop and maintain operational dashboard and executive-level reporting using tools like Tableau, or Power BI
- Interact with functional business units to analyze, gather, and prioritize business and reporting requirements
- Partner with the Enterprise Data and Analytics leaders and teams to manage the key data processes, tools, and architectures needed to deliver confidence in regular reports.
- Collaborate with Enterprise Data and Analytics team to implement data management, data quality best practices and standards
- Partner with business leaders to develop, monitor, and report on marketing tests for new or enhanced products and campaigns
- Provide ad hoc report for Retail organization for experiments in market.
- Hands on development of data models in Oracle, AWS and data visualizations.
- Formulate and provide status updates on project plans and schedules to meet goals/objectives
- Working Conditions:
- Hybrid work: Working 3-4 days a week in the office.
- Some overtime may be required as special projects arise or daily operations dictate
Minimum Requirements:
- Bachelor’s degree in computer science, Computer Engineering, Information Systems, or related discipline/experience with 4+ years of experience or master’s degree in computer science, Computer Engineering, Information Systems, or related discipline/experience with 3+ years
- Hands on experience in one of programming languages like SAS/R/Python is a must.
- 4+ years of professional experience in business intelligence and data analysis
- 3+ years of SQL experience.
- 3+ years of programming experience.
- Experience with dimensional modeling and improving data reliability and data quality.
- Good understanding of cloud technologies with 1+ years hands on experience in AWS and big data distributed ecosystems.
- 2+ year’s hands on experience in databricks and GCP
- 2+ year’s experience with any one of visualization tools like Tableau/Power BI.
- Good understanding of relational and non-relational databases
- Experience working with large datasets.
Preferred Qualifications:
- Gas or power industry experience with knowledge of the retail electricity market.
- Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
- A successful history of manipulating, processing, and extracting value from large, disconnected datasets.
- Strong organizational skills and comfort interacting with different lines of business, IT, and senior management
- Comfortable with ambiguity; ability to work with incomplete data or open-ended questions, and translate into actionable items
Additional Knowledge, Skills, and Abilities:
- Ability to manage multiple priorities while committed to deadlines and work overtime when required
- Proficient in effectively communicating to a wide range of audiences, both written and oral
- Self-starter with strong work ethic
- Ability to evaluate and learn modern technologies quickly
- Strong data due diligence skills ensuring data accuracy and reliability