Data Programmer (Python, PostgreSQL, ETL and Power BI)

• Professional experience in programming and development of data solutions.
• Good practical mastery of SQL, including complex queries, JOIN, subqueries, aggregations, relationships between tables, and query optimization.
• Experience working with PostgreSQL.
• Knowledge and experience in indices, performance, and optimization of queries and data structures.
• Experience in the development of stored procedures, functions, and triggers.
• Experience in Python for data processing and analysis, especially with pandas.
• Experience in the design, development, and maintenance of ETL/ELT processes.
• Knowledge and experience with Power BI.
• Experience in data analytics using SQL, Python, and visualization tools.
• Experience in the development and management of solutions oriented toward data processing, integration, and exploitation.
• Ability to analyze and resolve technical problems related to data, performance, and integration.
• Analytical skills, results-oriented mindset, and teamwork abilities.

Previous experience in Data Warehousing and in data analytics projects will be especially valued.

• Experience in Data Warehousing.
• Knowledge of data modeling.
• Experience in projects involving the integration and exploitation of large volumes of information.
• Experience in public administration environments.

• Joining a stable project within the Public Administration.
• 100% teleworking modality from any autonomous community in Spain.
• Full-time.
• Technological environment oriented toward data processing and exploitation.
• Participation in projects with data analysis, integration, and exploitation technologies.
• Professional development within a specialized team.
• Immediate start.

• Reside in Spain.
• Valid work permit.
• DNI or NIE.
• Social Security number.
• Student visas are not accepted.

At BEIGAR, we are looking to hire a Data Programmer to participate in a stable project within the Public Administration, collaborating on the development, integration, processing, and exploitation of data-oriented solutions.

We are looking for a profile with practical and demonstrable experience in SQL, Python (especially pandas), ETL processes, and Power BI, capable of developing and optimizing data solutions and analyzing information to respond to technical and functional needs.

The selected person will work in a technological environment oriented toward data quality, integration, and exploitation, participating in the development of ETL/ELT processes, optimization of queries and data structures, information processing using Python, and the generation of reports and dashboards.

It is important to have a real and practical mastery of the indicated technologies, especially in SQL, Python, and ETL processes, as well as the ability to analyze performance problems and propose solutions autonomously.

• Development and maintenance of solutions oriented toward data processing, integration, and exploitation.
• Design, development, and optimization of complex SQL queries on PostgreSQL.
• Work with relationships between tables, indices, data structures, and query optimization.
• Development of stored procedures, functions, and triggers.
• Programming and automation of processes using Python, especially using libraries oriented toward data processing and analysis such as pandas.
• Development and maintenance of ETL/ELT processes for data extraction, transformation, integration, and loading.
• Analysis and processing of information to obtain indicators and generate information for decision-making.
• Development and maintenance of dashboards and reports in Power BI.
• Participation in data analytics tasks using SQL, Python, and visualization tools.
• Identification and resolution of problems related to data performance, quality, and integration.
• Collaboration with technical and functional teams in the continuous improvement of data solutions.
• Technical documentation of the developments carried out.

• 100% remote from any autonomous community in Spain.
• Full-time position, 40 hours per week.
• Standard office hours.
• Start date as soon as possible.