Direct Energy is one of North America's largest retail providers of electricity, natural gas, and home and business energy-related services with over four million customers. Direct Energy gives customers choice, simplicity, and innovation where energy, data, and technology meet. A subsidiary of Centrica plc (LSE: CNA), an international energy and services company, Direct Energy, its subsidiaries and/or affiliates, operate in 50 U.S. states plus the District of Columbia and eight provinces in Canada.
This position requires an experienced Python developer who will be responsible for the coding of several business-specific data marts and data warehouses in the cloud (AWS). The role requires strong analytical, development and architecture skills to design and develop new analytics in our data warehouse. The candidate will be responsible for any technological duties associated with cloud computing, including design, planning, management, maintenance and support for gathering business requirements, as well as developing enhancements to existing data structures and processes. He/she will be responsible for developing solutions which will improve the broader team's reporting and analytical capabilities.
Lead projects with technical expertise that includes solution designing, defining requirements, and process automation
Establish, maintain, use and continually expand/enhance knowledge of data warehouses/marts, BI and enterprise applications, data, queries/programming, and organizational structure
Identify potential logic and data gaps within our reporting systems
Refine and maintain clear and concise system processes for reporting on business performance to commercial and corporate leadership
Strong cross-functional collaboration skills, and ability to work with people at various levels from various parts of the organization
Proficiency in developing, deploying, and debugging cloud-based applications using AWS Advanced knowledge of data analysis, profiling, and conceptual modeling
Extensive experience in AWS services (EC2, S3, Athena, EMR, AWS Glue) and understanding of core AWS services, uses, and basic AWS architecture best practices (including security and scalability)
Demonstrated understanding of Apache projects such as Spark, Hadoop, Airflow
Advanced knowledge of SQL and scripting tools for automation such as R, Python, etc.
Familiar with Git, Jenkins, JIRA, or similar tools
Comfortable in Linux
Advanced knowledge technical and functional designs for databases, ETL, data warehousing, and reporting
Advanced knowledge with reporting/data visualization tools such as Tableau, SSRS, Microsoft Power BI, etc.
Demonstrated ability to test software and ensure that project solutions align to requirements
5+ years of experience with business intelligence, reporting, and data transformation
5+ years of advanced knowledge and professional quantitative experience
5+ years experience working on large scale systems and databases
Experience troubleshooting applications and system performance and complex, production software issues
Advanced SQL coding, tuning and query optimization
Understanding of overall system architecture, scalability, reliability, and performance in a database environment
Experience designing and leading database performance benchmarks
Experience with large-scale data analytics and data warehousing
Strong development background, strong coding skills
Be highly innovative, flexible and self-directed
Experience in communicating with users, other technical teams, and management to collect requirements, describe software product features, and technical designs
Experienced debugging, diagnosing, and troubleshooting complex, production software
Strong understanding of system performance and scaling
Direct Energy and its subsidiaries are an Equal Opportunity Employer EOE/AA/Veterans/Disabled.
Centrica is committed to working with and providing reasonable accommodation to individuals with physical and mental disabilities.
If you need special assistance or an accommodation while seeking employment, please email email@example.com. We will make a determination of your request for a reasonable accommodation on a case-by-case basis.
PLEASE APPLY ONLINE by hitting the 'Apply' button.
Applications will ONLY be accepted via the 'Apply' button.
This role is being handled by the Centrica recruitment team and NO agency contact is required.