We are looking to welcome a junior data engineer to participate in some awesome projects within our digital ventures team. Responsibilities include:

• Build data pipelines: Managed data pipelines consist of a series of stages through which data flows (for example, from data sources or endpoints of acquisition to integration to consumption for specific use cases).
• Drive Automation through effective metadata management: Assist with renovating the data management infrastructure to drive automation in data integration and management.
• Learning and using modern data preparation, integration and AI-enabled metadata management tools and techniques.
• Tracking data consumption patterns.
• Collaborate across departments.
• Participate in ensuring compliance and governance during data use.

We invite applications from candidates with the following experience:

• 2 to 4 years experience plus appropriate degree; Received a bachelor’s in the fields of Science or Mathematics or related degree
• Proficient in working with SQL and creating stored procedures and other integration techniques within the database preferably in SQL Server
• Experience in creating Power Automate flow to automate data flows
• Experience with the following tools: Microsoft SharePoint, Excel, Power BI, PowerPoint, Word.
• Experience working to understand the reporting requirements and build out data models for reporting in Power BI is required
• Demonstrated expertise and hands-on experience in building scalable and optimized data pipelines along with optimizing performance of database queries is preferred
• Demonstrated expertise and hands-on experience working with complex and large data sets in a multi-sector environment is preferred

Here at Mott MacDonald, we are experts in engineering, management, and development services supporting multisector project work in over 150 countries. One of the largest employee-owned companies in the world, we pride ourselves in our ability to deliver exceptional outcomes through the connected thinking of our 16,000+ talented consultants. Sustainability and innovation are at the heart of all of our sectors which, in North America include Advisory, Built Environment, Energy, Transportation, and Water.

Equality, diversity and inclusion
We put equality, diversity and inclusion at the heart of our business, seeking to promote fair employment procedures and practices to ensure equal opportunities for all. We encourage individual expression in our workplace and are committed to creating an inclusive environment where everyone feels they have the opportunity to contribute.

Equal employment opportunity is the law. English version, Spanish version, Chinese version.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, protected veteran status, creed, marital status, sexual orientation, gender identity, citizenship status or disability status.

Hybrid working policy
At Mott MacDonald, we believe it makes business sense for you and your manager to choose how you can work most effectively to meet your client, team, and personal commitments. We offer a hybrid working policy that embraces your well-being, flexibility, and trust.

More about Mott MacDonald
We’re a global engineering, management and development consultancy.
Our purpose is to improve society by considering social outcomes in everything we do, relentlessly focusing on excellence and digital innovation, transforming our clients’ businesses, our communities and employee opportunities.
A fundamental part of this is respecting each person’s differences and striving to meet their needs.
Our values: progress, respect, integrity, drive, excellence

58562BR

Carlos Macon

United States

Massachusetts

Digital design

Digital Ventures

North America

Digital