SAS, SAS Web and Snowflake Profile

About the Position

At Singular Beacon we are looking for a candidate with integrity, insight, and initiative to join our team as a Senior SAS & Snowflake Consultant in Madrid, Spain.

We are looking for people who are passionate about technology and data, with a drive for excellence, who stand out for their technical command of SAS/Snowflake environments, their ability to lead complex data migrations and their results orientation in large-scale projects, and who have proven professional experience in data consulting, analytics platform migrations and digital transformation in the Human Resources area to other environments within large organizations.

We would like to build a long-term relationship based on the trust, transparency, empathy and passion we all share for our profession.

Join a team where your dedication and autonomy will be key to achieving shared success. For our part, we will work to ensure these skills are rewarded with interesting professional experiences and generous compensation in line with the value you bring to the organization, reflecting the successes we will share.

Responsibilities

Analysis, mapping and documentation of the client's SAS ecosystem

• You will carry out the analysis, mapping and documentation of the client's SAS ecosystem (SAS Base, SAS Web, macros, existing ETL flows) in the HR context.
• Inventory and analysis of the existing SAS code in the HR domain: SAS Base programs and the macro library, identifying which process each one supports and which are still in use.
• Mapping of the existing ETL flows: data sources, intermediate transformations, outputs and dependencies between processes.
• Analysis of the SAS Web layer: what is exposed to HR users, who consumes it and what SAS logic lies behind each screen or report.
• Documentation of the resulting ecosystem, recording what exists, how its parts relate to one another and which HR process each serves, among other aspects.

Migration strategies

• Design and execution of the migration strategy to the target environments (Snowflake and/or complementary tools), ensuring data integrity and operational continuity.
• Design of the migration strategy: defining the order in which each process moves to the target environments and the criteria for handling each one.
• Execution of the migration to Snowflake and/or the complementary tools in the stack, moving processes across in phases as designed.
• Ensuring data integrity.
• Ensuring operational continuity: both environments running side by side during the transition, so that production processes keep delivering for as long as the migration lasts.

Pipeline development and optimization

• Development of the ETL/ELT pipelines in the target environment: building the extraction, transformation and loading processes that replace the existing flows.
• Writing the transformation logic in advanced SQL: complex queries, aggregations and business rules currently handled by the SAS code.
• Optimization of pipelines, both new and existing: reviewing and improving the performance of queries and processes.
• Building and orchestrating the flows with the tools already in place in the client's stack, without introducing new dependencies.

Technical liaison with the client

• Technical liaison with the client: acting as the point of contact for the project's technical matters, gathering the client's needs and validating the migration approach with its teams.
• Explaining technical decisions to stakeholders with different levels of knowledge, so that the implications of each option are understood before decisions are made.
• Regular progress reporting.
• Managing any incidents that arise within the project.

Collaboration with the client's teams

• Working with the client's HR teams to capture the business logic underpinning each process before migrating it.
• Validating with those teams that the data models in the target environment reflect that logic.
• Functional checking of the migrated processes: making sure the results are what the business expects, not merely those that reconcile technically.
• Verifying that the migrated processes meet the applicable regulatory requirements.

Requirements

Basic Requirements

• At least 5 years of experience with SAS in production environments (SAS Base + SAS Web essential).
• Demonstrable involvement in at least one migration from SAS to another environment in an organization with more than 1,000 employees.
• Advanced SQL: complex joins, window functions, query optimization, handling large datasets.
• Experience with ETL tools in data integration or transformation projects.
• Experience on projects within the HR functional domain (payroll, headcount, people reporting or similar).

Nice to Have

• Experience with Snowflake (certification or production projects valued).
• Knowledge of Azure Data Factory or IBM DataStage as ETL tools.
• Familiarity with IBM Strategy (HR planning / workforce planning).
• Previous experience on projects for retailers or consumer goods companies.
• Knowledge of the Spanish labor regulatory framework applicable to the processing of HR data (GDPR, LOPDGDD, TGSS).

We Offer

• Permanent full-time contract, with the option of a senior self-employed/freelance arrangement depending on the candidate's profile and preference.
• Pay in line with the candidate's experience and merit.
• Close-Knit Team: there are few of us and we look after each other.
• Training: training is one of our pillars, so you will design a training plan with your manager and the company will help you carry it out.
• Benefits in Kind: the option of receiving part of your pay in kind (meal vouchers, childcare, health insurance and/or training).
• Community: we try to organize all kinds of team building and networking activities.
• Complementary Projects: we collaborate on projects of various kinds, such as social platforms and/or the production of podcasts.

Salary

€35 - 40k/year + incentives for 40h/week or the equivalent for shorter working hours. Final salary to be agreed based on your résumé, previous experience and internal assessment.

About the Company

Singular Beacon is a company that values integrity, insight, and initiative. We are committed to delivering real value and fostering a culture based on excellence, efficiency, and operational simplicity. Our vision combines strategy, data, and purpose to help organizations grow in a smarter, more human way.

When and Where You Will Work

• The project is on-site in Madrid with the client. You need to be available to be at the client's premises on a regular basis.
• If you live outside Madrid but can relocate or travel frequently, tell us and we will consider it.
• The standard working day is 9:00 to 18:30 Monday to Thursday and 9:00 to 15:00 on Fridays. Everyone arranges their working day within the 8:00 to 20:00 window to complete their 40 weekly hours as they see fit, always trying to meet the needs of the project and the client.
• You will have 23 days of vacation per year by contract under the collective agreement, to which we add 2 extra days granted by the company if you meet your objectives.

Who You Will Work With

• Carlos Pascual, Director: An entrepreneur by vocation, a consultant by profession and the captain of this ship. A Data Analytics specialist with a solid track record in the Retail and Human Resources sectors.
• Jesús Bouza, Head of Technology: Software engineer specializing in digital consulting, custom solution development and artificial intelligence.