Wood Mackenzie Logo

Wood Mackenzie

Software Engineer – Data Engineering Platform (Python _ SQL _ PostGIS

Posted 2 Hours Ago
Be an Early Applicant
In-Office
Boston, MA, USA
Entry level
In-Office
Boston, MA, USA
Entry level
Develop and maintain Python ETL pipelines, PostgreSQL/PostGIS schemas, spatial data workflows, validation controls, and Linux-based automation for large geospatial and energy datasets. Diagnose pipeline and database issues, monitor data quality, and collaborate with product, GIS, and data science teams to deliver reliable data products.
The summary above was generated by AI

Wood Mackenzie is the global leader in analytics, insights and proprietary data across the entire energy and natural resources landscape.


For over 50 years our work has guided the decisions of the world’s most influential energy producers, utilities companies, financial institutions and governments.


Now, with the world’s energy system more complex and interconnected than ever before, sector-specific views are no longer enough. That’s why we’ve redefined what’s possible with Intelligence Connected.


By fusing our unparalleled proprietary data with the sharpest analytical minds, all supercharged by Synoptic AI, we deliver a clear, interconnected view of the entire value chain. Our trusted team of 2,700 experts across 30 countries breaks siloes and connects industries, markets and regions across the globe.


This empowers our customers to identify risk sooner, spot opportunities faster and recalibrate strategy with confidence – whether planning days, weeks, months or decades ahead.


Wood Mackenzie
Intelligence Connected


WoodMac.com


Wood Mackenzie Brand Video

Wood Mackenzie Values

  • Inclusive – we succeed together
  • Trusting – we choose to trust each other
  • Customer committed – we put customers at the heart of our decisions
  • Future Focused – we accelerate change
  • Curious – we turn knowledge into action

Company

Wood Mackenzie is a global research, analytics and consultancy business serving the natural resources industry.We provide data, analytics and insights that help customers make informed decisions across oil, gas and LNG, power and renewables, chemicals, metals and mining.Our sector teams are located around the world and support customers with intelligence on assets, companies and market indicators. Together, we help customers address complex challenges and support the transition to a more sustainable future.LandGate, a Wood Mackenzie business, is a fast-growing vertical intelligence platform specialising in energy, infrastructure, and data centre site selection.Through proprietary datasets and market intelligence, it helps customers identify, evaluate, and develop energy and infrastructure opportunities across the United States.

Role Purpose

The Software Engineer will join the team responsible for the core data platform supporting valuation and analytics products. The platform ingests, processes and maintains large-scale geospatial and energy datasets used across oil and gas, renewables, electrical infrastructure, carbon and land intelligence. This is a backend data engineering position focused on Python, PostgreSQL/PostGIS and Linux. The role will design, develop and maintain data pipelines, spatial data processes and data-quality controls that provide reliable information to downstream products and users. It is not primarily an application or front-end development role. Main Responsibilities·Design, develop, test and maintain Python-based ETL pipelines for large geospatial and energy datasets. ·Build and optimise PostgreSQL/PostGIS schemas, SQL queries and spatial data workflows. ·Develop automated processes for data ingestion, validation, transformation and promotion. ·Monitor data quality and investigate issues affecting the accuracy, completeness or reliability of data products. ·Maintain Linux-based data-processing environments, scheduled jobs and automation tooling. ·Support data engineering across energy infrastructure, land, oil and gas, renewables and carbon datasets. ·Collaborate with product, GIS and data science colleagues to understand requirements and deliver reliable data products. ·Diagnose pipeline, database and processing issues, implementing maintainable solutions. ·Contribute to documentation, engineering practices and the continuous improvement of data-platform processes. About YouEssential experience and capabilities·Practical software development experience using Python. ·Advanced working knowledge of PostgreSQL and SQL, including database design and query-performance optimisation. ·Experience using PostGIS or comparable geospatial database technologies. ·Experience building and maintaining ETL or data-engineering pipelines. ·Experience processing large or complex datasets. ·Experience implementing validation and data-quality controls. ·Working knowledge of Linux administration, scripting and automation. ·Effective analytical, diagnostic and problem-solving skills. ·Ability to communicate technical information clearly and work collaboratively across disciplines. Desirable experience·Elasticsearch. ·AWS services, particularly Amazon S3. ·TypeScript, Node.js or REST API development. ·GIS formats such as Shapefile and GeoJSON. ·Spatial indexing or geospatial analytics. ·Data modelling, machine learning or statistical analysis. ·Energy, land, mineral rights, oil and gas, renewables, electrical-grid or carbon/CCUS datasets. We recognise that experience can be gained in different ways. If you meet most of the essential requirements and are interested in the role, we encourage you to apply.

Working Arrangements

We are a hybrid working company and the successful applicant will normally be expected to be physically present in the office at least two days per week to foster and contribute to a collaborative environment. Remote working arrangements will also be considered for this role, subject to the applicable approval process.Due to the global nature of the team, a degree of flexible working will be required to accommodate different time zones. Any out-of-hours collaboration should be planned proportionately and shared fairly across the team.

Wood Mackenzie Values

  • Inclusive: we succeed together.
  • Trusting: we choose to trust each other.
  • Customer committed: we put customers at the heart of our decisions.
  • Future focused: we accelerate change.
  • Curious: we turn knowledge into action.

Equal Opportunities


We are an equal opportunities employer. This means we are committed to recruiting the best people regardless of their race, colour, religion, age, sex (including pregnancy, sexual orientation, and gender identity), national origin, disability or protected veteran status. You can find out more about your rights under the law at www.eeoc.gov 


Wood Mackenzie Boston, Massachusetts, USA Office

179 Lincoln Street, Boston, United States, 02111

Similar Jobs

A Minute Ago
Hybrid
Boston, MA, USA
143K-169K Annually
Mid level
143K-169K Annually
Mid level
Artificial Intelligence • Big Data • Cloud • Information Technology • Machine Learning • Software
Provide technical pre-sales support for Nexthink’s commercial and small enterprise sales teams. Responsibilities include discovery meetings, technical presentations, product demonstrations, value propositions, security questionnaires, RFPs, RFIs, proof-of-concept validations, and customer stakeholder engagement. The consultant translates business needs into technical solutions, partners with sales and other teams, supports revenue goals, and participates in webinars and marketing events. The role is hybrid in Boston with occasional domestic and international travel.
Top Skills: CloudDigital Experience MonitoringItilMicrosoft 365NexthinkSaaSWindows 10
5 Minutes Ago
Remote or Hybrid
7 Locations
Senior level
Senior level
Financial Services
Originate and close corporate travel management opportunities for middle-market and large corporate clients. Lead complex sales cycles, develop executive relationships, build pipeline, negotiate solutions, and coordinate implementation handoffs. Partner with banking, product, operations, and servicing teams to deliver integrated solutions and strong client outcomes. Manage forecasting, analyze market trends, represent the business at industry events, and identify growth opportunities.
Top Skills: AutomationCustomer Relationship Management PlatformsData AnalyticsMS OfficeOnline Booking Tools
5 Minutes Ago
Hybrid
Boston, MA, USA
Junior
Junior
Financial Services
Build, project, publish, and validate daily ETF baskets supporting creation and redemption activity. Project corporate actions, income accruals, and distributions; investigate processing issues and variances; execute controls; and coordinate with Fund Accounting, Trading, Corporate Actions, and Technology teams. Support ETF launches, testing, validation, and process automation while ensuring accurate, timely deliverables across multiple funds.
Top Skills: Corporate ActionsEtfFund Accounting

What you need to know about the Boston Tech Scene

Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.

Key Facts About Boston Tech

  • Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
  • Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
  • Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
  • Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account