Data analyst internship

You will help shape solutions according to client needs and manage their successful delivery. You will not be working alone but supported by the wider business for access to our deep domain knowledge and diverse digital capability. 

The day-to-day activities in the role will range from gathering data through ETL processes to building BI reports using Microsoft applications.  We are looking for candidates who are keen to share their experience to date in the application of data analytics, modelling and business intelligence related data design. 

You will be embedded within interdisciplinary teams on infrastructure and built environment projects, working with consultants, engineers, planners and project managers.  You will be an advocate for data science and data analytics on your projects, identifying opportunities for data-driven approaches to improve project delivery and outcomes. 

You will be conceptualizing from a high-level business need and then executing a data strategy to fulfil that need. You will be responsible for collecting requirements from relevant stakeholders and building a project plan around the deliverables.  

Specific responsibilities include: 

• Identify opportunities for data analysis and data visualization
• Interact with stakeholders and develop requirements
• Apply tools and techniques for data analysis and data visualization
• Identify, collect and migrate data to and from a range of systems
• Manage, clean, abstract and aggregate data alongside a range of analytical studies on that data
• Manipulate and link different data sets
• Summarize and present data and conclusions in the most appropriate format for users

Candidate Specification :

We are seeking a dynamic and talented person with 1-2 years’ experience and a bachelor’s in the fields of Engineering, Science, Mathematics or related degree. Our preferred candidate will have working commercial knowledge in data projects using Microsoft’s Power Platform. To be successful, you should be able to show experience in data querying using SQL on different platforms, such as using SQL within Power BI, in SSIS or SSMS. 

You must be a good communicator with customer engagement experience and must be confident in your skills. You must also think creatively and should always be seeking new and more efficient ways to improve systems. You must be able to manage your own time, set your own targets and can communicate that to the team. 

Skills and qualities: 

• Analytical and problem-solving skills: You can apply analytical techniques to present a solution.
• Communication skills: You have strong verbal and written communication skills and understand how to share insights with stakeholders.
• Data management: You understand data sources, data organization and storage.
• Data modelling, data cleansing, and data enrichment skills: You understand conceptual, logical and physical data modelling and can develop knowledge of data cleansing and standardization.
• Data visualization: You can interpret requirements and present data in a clear and compelling way, using graphical representations and data visualizations.
• Logical and creative thinking skills: You can approach a problem, applying logic and creativity.
• Project management skills: You know how to work with stakeholders to gather requirements and deliver findings.
• Proven IT and mathematical skills: You have proven IT and mathematical skills, demonstrated through relevant qualifications or work experience.
• Quality assurance, validation and data linkage abilities: You know how to conduct data quality assurance, validation and linkage.
• Statistical methods and data analysis skills: You know about statistical methodologies and data analysis techniques.