Data Management & Engineering Intern (Technical)

Description

• Develop competency in data governance and management tools; and understanding of emerging trends and technologies which are critical in enhancing the effectiveness of data-driven planning and analytical insights in the Urban Planning & Design domain.
• Develop competency in managing/driving collaboration with cross-functional teams and in implementing data governance policies which are essential for developing and maintaining data products and solutions that meet business requirements and support planning studies and processes.
• Develop an understanding of the PSDH Data Lakehouse framework, including key components and design principles. Learn how to implement data governance policies to ensure data quality and compliance.
• Work with other agencies to align data attributes and schema based on planning use cases, understand the datasets fully, ensuring proper access and use of the datasets, and work with Data Engineers to collect and fuse data, maintain the datasets and storage, rectify any issues and errors faced with the datasets.
• Work on dashboard prototypes & geospatial analytics using sample data to represent how dataset can be used to tackle policy & urban planning issues.
• Assist in designing and building data pipelines to enable efficient data flow from the source system to the PSDH Data Lakehouse. Utilize SQL and Python for ETL processes, and leverage Azure cloud services such as Azure Data Factory for pipeline orchestration and Azure Databricks for data processing, ensuring efficiency, scalability, and data integrity throughout the process.
• Set up processes for future Data management.
• Manage the dataset lifecycle by documenting the entire data management policy and process from data pre-acquisition to data archival or destruction.
• Develop a good understanding of the lifecycle of dataset management, including acquisition, cleaning, transformation, storage, and archival/destruction (if applicable), which is crucial for ensuring the quality and security of data in urban planning.

Requirements

• Students working toward a Degree or other related qualification in Computer Science, Information Technology, or an urban planning and design related field (e.g. Architecture).
• Familiarity with SQL, Python, Git
• Resourceful in problem solving, with attention to detail.
• Knowledge in Azure Cloud (e.g. Azure Data Factory, Azure Databricks) and Jenkins will be an added advantage.
• Computer Science / IT; Business Analytics; Architecture; Smart Cities; Data Science, Engineering;
• Foundational knowledge in data governance and management, business analysis and data analytics
• Strong communication and collaboration skills
• Data Pipeline Engineering: Gain hands-on experience in designing, building, and managing data pipelines, utilizing SQL and Python for data transformation and transport, and leveraging cloud technologies like Azure Data Factory for orchestration and Azure Databricks for ETL processes.
• Relevant experience working with data managers or data engineers in data-related projects.
• Familiarity with handling data and running data analytics projects

Benefits

Training + Development

Interview process

Visa Sponsorship

Security clearance