Business Intelligence (BI) Engineer Freelance

At Hays , we are collaborating with a leading global pharmaceutical company operating in more than 130 countries focused on improving the health and quality of life of both people and animals through innovation, research, and technology .

We are seeking a highly skilled and motivated Business Intelligence (BI) Engineer with experience in developing analytical tables in the Snowflake and developing/configure data visualizations on Tableau/Power BI . The ideal candidate will adapt at working across different environments (development, testing, and production) and be proficient in Jira, GitHub, Tableau, Power BI, and documentation . Experience with cloud solutions, specifically AWS, is also required. The BI Engineer will play a critical role in transforming data into actionable insights, ensuring data integrity, and supporting business decision-making processes.

Key Responsibilities

Data Warehouse Development

- Design, develop, test and maintain analytical tables in the Snowflake.
- Optimize data storage and retrieval processes to ensure efficient query performance.
- Implement data modeling techniques to support business requirements and reporting needs.

Environment Management:

- Manage and deploy data solutions across development, Quality Assurance, and production environments.
- Ensure smooth transitions between environments, minimizing disruptions to data access and reporting.
- Perform thorough testing and validation of data solutions in various environments to ensure accuracy and reliability.

Cloud Solutions

- Knowledge of AWS services for data storage, processing, and analytics.




- Implement and manage ETL processes in the cloud environment.
- Ensure data security and compliance within the AWS framework.

Collaboration and Project Management

- Collaborate with cross-functional teams, including data analysts, data scientists, and business stakeholders, to understand data needs and deliver solutions.
- Use Jira to track and manage project tasks, issues, and progress.
- Maintain version control and manage code repositories using GitHub.

Reporting and Visualization

- Develop, test, document and maintain interactive dashboards and reports using Tableau/ Power BI.
- Optimize data consumption and data transformations in FE to ensure efficient data visualization performance.
- Translate complex data sets into clear and actionable visual insights.
- Provide ad-hoc data analysis and reporting support to various business units.

Documentation and Data Governance

- Document data definitions, models, processes, and workflows for reference and training purposes.
- Implement and enforce data governance policies to ensure data accuracy, consistency, and security.
- Conduct regular data quality checks and troubleshoot any data-related issues.

Requirements

- Proven experience with Snowflake , including schema design, SQL development, and performance optimization.




- Proficiency in SQL and experience with ETL processes and tools.
- Strong understanding of data warehousing concepts and best practices.
- Experience with AWS cloud solutions, including S3, Redshift, Lambda, and other relevant services.
- Experience with DBT , elementary and the complete modern standard for data transformation.
- Experience with Jira for project management and issue tracking.
- Proficiency in using GitHub, Bitbucket for version control and collaboration.
- Advanced skills in Tableau for data visualization and reporting.
- Ability to analyze complex data sets and derive meaningful insights.
- Strong problem-solving skills and attention to detail.
- Ability to work independently and as part of a team in a fast-paced environment.
- Excellent verbal and written communication skills.
- Ability to explain technical concepts to non-technical stakeholders.
- Strong collaboration skills with the ability to work effectively across different teams and departments.
- Professional level of English.

Nice to Have

- Experience with other BI tools and platforms (e.g., Power BI, Looker).
- Knowledge of Python or other scripting languages for data manipulation and automation.
- Relevant certifications in Snowflake, AWS, Tableau, or other BI tools

What Do We Offer?

- Freelance contract through Hays with an initial duration of 6-12 months .
- 100% remote working model within Spain.
- Opportunity to participate in general data and analytics initiatives.
- International and multicultural environment.
- Long-term project potential and continuous learning opportunities.

📌 Business Intelligence (BI) Engineer Freelance - 100% Remote (Cequeliños)
🏢 Hays
📍 Cequeliños