Data Engineer - Kolkata

Energy Aspects is currently offering an exciting opportunity for a Data Engineer to join our Data Engineering team at our Kolkata office. This is a fantastic opportunity for an experienced data engineer to support our , data pipelines, core databases and strategic projects that form the basis for our highly respected global oil, natural gas, and energy teams by enhancing our data content and capabilities.

The selected candidate will be tasked with the creation of entirely new data products, along with maintaining and iterating on our existing datasets, data pipelines, and tools that are used daily at Energy Aspects by the Data and Research teams. You will be accountable for systems within a cloud-first data stack and also expected to promptly contribute to production-level Python codebases. In this role, you'll be supporting Data Analysts and other technical analysts, while assisting in defining and paving the way for the future of data engineering at Energy Aspects.

Duties

• Construct and maintain data pipelines using Python
• Develop, expand, and transform core datasets within a SQL data warehouse
• Design and integrate new data solutions for use by internal teams and external clients
• Sustain a variety of strategic, company-level data initiatives

Requirements

• At least 2 years of experience as a Data Engineer
• Our technology stack primarily includes:
• Python: Anaconda, pandas, SQLAlchemy, web scraping libraries
• SQL: PostgreSQL
• Cloud: GCP, AWS
• DevOps: Docker, Doppler
• Orchestration: Airflow
• Data visualization + apps: Plotly, dash, Flask, Retool
• Experience in building reliable, maintainable data pipelines
• Experience with web scraping
• Experience with scheduling/orchestration tools
• Strong understanding of how to create, extend, query SQL databases – both natively and via Python
• Comprehension of the best methods to organize and model data for storage, retrieval, and analysis
• Best practices in data development: documentation, version control, testing, and automation
• Understanding of the significance of data governance and metadata
• An orderly, analytical, and organized approach to handling large-scale projects and data sets
• Effective communication skills, and comfort in presenting to both technical and non-technical audiences

Desirable skills

• Experience with cloud infrastructure, and familiarity with Infrastructure as Code
• Experience with Docker/containers
• Experience working with high-frequency timeseries data and/or streaming data
• Experience in building and managing other database/datastore technologies (NoSQL variants, file stores, etc.)
• Experience working with Python web frameworks, Jinja templating, and/or JavaScript
• Prior experience or training in forecasting or modeling
• An interest in commodities, energy, or financial markets would be advantageous

About us

Established in 2012, we are an independent research consultancy that has seen phenomenal growth since our inception. We have ambitious plans to continue our upward trajectory. We are devoted to providing vital and leading short, medium, and long-term analyses and forecasts of the energy markets, aiding our clients in trading, investing, financing, and planning.

With the acquisition of macro research firm Medley Global Advisors, the fusion of our market-leading global macro policy analysis and profound energy markets expertise has fortified our services to the global financial markets and boosted our ability to accommodate our growing client base, especially as the energy transition accelerates and markets navigate an uncertain future.

Our range of subscription services can be customized to our clients’ specific needs, blending a data-rich approach and an extensive network of contacts with insights on geopolitics and energy policy to deliver premier assessment, analysis, and forecasts of major trends, topics, and regions. We also provide prompt analysis of breaking news events and proprietary data services that cover fundamental trade and supply/demand data across a wide variety of products and markets.

Culture & benefits

As the proud recipient of the Best Companies accreditation, we understand the significance of workplace engagement and truly value our employees. We offer a fast-paced, driven, collaborative, and dynamic work culture where you are recognized and compensated for contributing to our impressive growth story.

Energy Aspects is proud to be an equal-opportunity employer and encourages diversity within its workforce. As an international business, we are committed to ensuring that suitably qualified individuals will never receive less favorable treatment due to gender, age, disability, religion, belief, sexual orientation, marital status, race, veteran status, or any other basis covered by appropriate law.

We have built our organization with the community in mind. All our offices are located in landmark buildings with easy access to shopping, restaurants, and public transportation. As part of our Kolkata team, you will have the opportunity to participate in the social activities of this rapidly growing team.

Our compensation packages include generous commission structures, a company share options scheme, private health insurance, life assurance, income protection, pension contributions, and ample holiday time.