SQL-GIS Data Intern

Are you a recently graduated skilled Data Analyst with intermediate/high English skills and a background in Geographic Information Systems (GIS) looking for a six-month internship opportunity to give your best joining an international company within a high talented team?.

Check this out as this might be your chance!

Mission of this role is for you to liaise at a national and international level to maintain and enhance our ETL (Extract,Transform & Load) processes that integrate diverse data feeds (with geographical component) into our data team’s warehouse, department data-lake and subsequently internal Business Intelligence solutions.

By joining us, you will have the opportunity to take on the following responsibilities and face the following challenges:

• Manipulate and integrate alphanumerical datasets and geographical data in various formats and from various sources

• ETL Data pipelines: Participate in the design, implementation, quality assurance, execution and maintenance of ETLs data pipelines aimed to ingest data into our internal data warehouse, ensuring reliable data availability on a timely manner, and alignment with changing data processing business rules and client requirements

• Spatial Analysis: Utilizing GIS tools, conduct advanced spatial data processing and analysis, to derive indicators used in decision-making and innovative solutions tailored to client specific needs

• Optimize Data Workflows: identify key sequential processes to streamline and optimize data workflows to improve the efficiency and effectiveness of the services provided by the team to our internal clients

• Requirements Gathering and Research : Collaborate with stakeholders to identify and understand data needs, requirements, and research new potential data sources or providers

• Relational Data Modeling: understand and support the development and maintenance of relational data models aligned with department standards and requirements

• Quality Assurance: Establish and execute quality assurance processes to ensure data accuracy and consistency

• Documentation : Maintain structured and comprehensive documentation of processes, data models; follow best practices and guidelines established within the team

• Support regular production operations, as well as engage in ad-hoc geo-marketing projects

• Python Scripting Upgrade: Update and modify existing Arcpy mapping scripts to make them compliance with ArcGIS Pro technology

• Model Builder migration into ArcGIS Pro Scripting.

What if it were you?

Tech Skills:

• Competent in both English (minimum B2) and Spanish.
• SQL (e.g: SQL Server, MYSql, PostgreSQL or similar), RDBMS and ETLs of any kind.
• GIS software from ESRI (ArcMap, ArcGIS Pro) and other platforms such as QGIS.
• Familiarity with Road Network and attributes related to navigable road data. Ideally experience in ArcGIS Network Analyst module.
• Geo-marketing / Location Intelligence background knowledge, familiarity with its concepts and terminology (e.g: areas of responsibility, drive-time analysis, isochrones, origin-destination matrix, location-allocation models, etc.)
• Relational data models background: clear understanding of entities and relationships.
• Programming skills in Python, .Net, C#, or similar.
• Microsoft Office skills
• Basic statistical methods and techniques.

Power Skills

• Initiative: Requires the drive to go above and beyond to improve or enhance job results
• Analytical and abstract thinking aimed to problem-solving.
• Excellent collaboration skills, within a multicultural and inclusive environment, working remotely with colleagues located in other countries.
• Good listening and communication skills, capacity to build a clear, concise, coherent, and well-structured speech.
• Maturity and ability to manage emotions and frustration
• Self-learning capacities
• Ability to prioritize tasks - following team’s guidelines - and meet deadlines in a dynamic and fast-paced environment.
• Detail-oriented for quality control

By joining Urban Science, you will BENEFIT from the following advantages:

Financial aspects

• Six-month internship contract with the possibility of extension for a further 6 months if meeting performance expectations. Qualification provided by the candidate must have been obtained in less than 3 years ago and be related to the tasks of the position offered and have not previously been employed under this type of contract.
• Free legal services and consultations at reduced prices
• Flexible remuneration: transport and meal card
• Discounts on IT equipment for non-work-related use
• Monthly remote compensation
• Free and discounted legal services

Work environment / Flexibility

• Modern and privileged business office location in Paseo de la Castellana
• Flexible work schedule and hybrid work: when there is no business-related reason that requires office attendance, our employees can choose to work from home or the office, according to their preference.
• Collaborative work environment and multicultural team
• 12 hours of paid volunteering per year

Personal development

• Onboarding program
• Training on the job and internal online platform free access

Healthcare

• 23 holidays a year
• Company paid health and dental insurance plus annual Health checks
• Company paid life insurance
• Joining our company also means saying yes to a company committed to well-being, supporting and offering initiatives related to the mental and physical health of our employees, as well as diversity, equity, inclusion, and belonging.
• 24/7 employee assistance hotline

Do you see yourself in this description? Don't hesitate, apply, and let's meet!