SQL-gis Data Intern

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 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.

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.
- 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**
- 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**
-