SQL-gis Data Intern - Madrid, España - Urban Science Applications, Inc.

Urban Science Applications, Inc.

Empresa verificada

Madrid, España

hace 6 días

Publicado por:

Isabel García

beBee Recruiter

Descripción

Overview and Summary:

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.

Essential Duties and Responsibilities:
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 decisionmaking 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 Modelin

g:
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 adhoc geomarketing 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.

Qualifications - Education and Experience:
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.
Geomarketing / 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 problemsolving.
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 wellstructured speech.
Maturity and ability to manage emotions and frustration
Selflearning capacities
Ability to prioritize tasks following team's guidelines and meet deadlines in a dynamic and fastpaced environment.
Detailoriented for quality control

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

Financial aspects

Free legal services and consultations at reduced prices
Flexible remuneration: transport and meal card
Discounts on IT equipment for nonworkrelated 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 businessrelated 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