This site uses cookies. To find out more, see our Cookies Policy

Data Engineer, Power & Renewables in Independence, KS at Verisk Analytics

Date Posted: 6/19/2018

Job Snapshot

Job Description


Role: Data Engineer, Power & Renewables

Reports To: Data Services Manager

Location: Houston TX, San Francisco CA, Boston MA, or New York City NY USA


Power & Renewables as part of Wood Mackenzie & Verisk Analytics, provides integrated subscription, research and advisory services for the renewables enabling our clients make the best decisions within the transformation of the global electricity industry.

Our cutting-edge knowledge of solar and wind power supply chains, costs, and investment trends further strengthens Wood Mackenzie's offerings in the market during this rapidly changing time in the energy sector.

Team Profile

The Power & Renewables Data Team leads the ingestion, processing, curating and analysis of data that underpins our products and supports our extraordinary research. We are a global leader in commercial analysis within the energy sector, and the completeness, integrity and quality of our datasets are critical to maintain this position. This is an exciting opportunity to join a team working together to demonstrate greater value from our data.

Role Purpose

Wood Mackenzie seeks an experienced professional to play a key role in improving and growing our Power & Renewables (P&R) practice. Combining the recent acquisitions of Greentech Media (GTM) and MAKE with Wood Mackenzie’s power research provides a solid foundation to become the leading market analysis and advisory firm on the transformation of the global renewable power industry. You will be expected to contribute and make an impact from day one.

The Data Engineer will build and maintain databases and data ETL processes for a variety of renewables and utility energy topics, as well as create and maintain processes that support the fundamental analysis efforts for the team and clients.  

Main Responsibilities
  • Build new databases on renewables and emerging energy topics, establish and enhance the processes for data collection, normalization, cleansing, formatting, automation, and reporting.
  • Create and maintaining automated processes involving: databases, spreadsheets, web scraping, version control systems, web sites, data services etc.
  • Collect and compile industry data on a regular basis from multiple sources using automated tools and processes and establish best practices.
  • Guide analysts in proper data transformation for incorporation into new and existing databases, models and services.
  • Ensure integrity of our own sourced data.
  • Develop new processes to improve the transformation and curation of our data.
  • Produce reports and data extracts as required by the various research teams
  • Create and maintain the documentation of data processes, databases, data tools and models, according to policies, procedure and standard methodologies.
  • Work with other teams across all Wood Mackenzie's business to maintain consistency of data across teams to maintain global integrity and abide by Continuous Improvement guidelines.

Knowledge & Experience Required
  • Experience with RDBMSs, particularly Mysql, including database schema design, development and security.
  • Experience with AWS and related data management tools including Aurora, S3 and Lambda.
  • Understanding of how web scraping methods can be implemented.
  • Advanced MS Excel skills, including experience of Visual Basic for Applications (VBA) or Python/R with respect to MS Office integration.
  • Experience in automating processes using combined solutions including databases, spreadsheets, workflows, programming languages and version control systems (VCS).
  • Experience in ownership of a process, taking responsibility for a task or group of tasks and improvement on an ongoing basis.
  • Excellent problem solving, documentation, communication and organization skills, and attention to detail.
  • Interest in and basic knowledge and understanding of global energy markets, particularly renewables.
  • Degree in a relevant discipline (Engineering, Computer Science, Operations Research)
  • Preferred experience in the following: MS Access, VBA, Python, R, Spotfire, Tableau, Git, Kapow, Javascript

Core Competencies
  • Accuracy and attention to detail
  • Efficiency in pattern recognition and issue identification
  • Creativity in problem solving and analysis
  • Focused, process driven and results oriented
  • Strong communication skills
  • Strong time management and organizational skills
  • Assertive, determined and resilient
  • Collaborative, yet able to find solutions on one’s own

Wood Mackenzie Core Values

Wood Mackenzie is a place where we are committed to supporting our people to grow and thrive. We value different perspectives and aspire to create an inclusive environment which encourages diversity and fosters a sense of belonging.

Wood Mackenzie values each individual's contribution and helps them reach their full potential while sustaining an organizational culture of health and well-being.

Our core values are:
  • Respect for the Individual
  • Integrity
  • Passion
  • Persistence
  • Confidence with humility
  • Excellence
  • Teamwork

We understand the importance of achieving balance between work, family and other life commitments.  We are open to considering flexible working arrangements to enable the greatest spectrum of talent to contribute to Wood Mackenzie’s success.


Unsolicited resumes submitted to Wood Mackenzie by any external recruitment agency via Internet, e-mail, fax, or U.S. mail become the property of Wood Mackenzie and we are not responsible for any fees associated with those resumes.

In compliance with the Civil Rights Act of 1964 and 1991, the Age Discrimination in Employment Act of 1967, Section 504 of the Rehabilitation Act of 1973, the Americans with Disabilities act of 1990 and all other relevant federal and state laws, the policy of this company prohibits discrimination in employment because of race, color, religion, national origin, sex, gender identity and/or expression, age, veteran’s status, disability, genetic information or any other group protected by law. Applicants are considered for all positions without regard to race, color, religion, national origin, sex, gender identity and/or expression, age, veteran’s status, disability, genetic information or any other group protected by law.

If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to use or access on-line as a result of your disability. You can request reasonable accommodations sending an email to Greentech is an Equal Opportunity Employer M/F/V/D, and a member of E-Verify.



  1. Software Engineer Jobs
  2. Project Engineer Jobs