Azure Data Engineer (Senior Business Intelligence Developer)
Madrid, Spain
PSI CRO
PSI is a leading full-service global Contract Research Organization. Predictable patient enrollment across multiple therapeutic areas.Company Description
We’re over 2,700 strong across the globe. We’re scientists, strategists, creatives, and innovators. We value individual brilliance and build a strong foundation for Teamwork across all our business. We love the challenge of our industry. We’re changing lives and redefining success every step of the way.
Job Description
PSI CRO are looking for a hands-on, experienced Azure Data Engineer who is a visionary, self-directed and comfortable supporting the various data & analytics needs of multiple teams, systems, and products. In this role, you will be responsible for defining high volume data processing pipelines and dataflows in a multi-tenant environment. You will also be verifying data integrity and curating data for consumption by data warehouse, data analytics tools and machine learning models.
Requirements:
- Participate in architecture design and implementation of high-performance, scalable, and optimized data solutions.
- Data Modelling and pipeline development to load models from multiple data sources.
- Design, build and automate the deployment of data pipelines and applications to support data scientists and researchers with their reporting and data requirements
- Provide input on Azure technologies and industry best practices in the field of data warehouse architecture and modelling.
- Collaborate with internal business units and data science teams on business requirements, data access, processing/transformation and reporting needs and leverage existing and new tools to provide solutions
- Maintain, monitor, upgrade and secure the SQL Server/Azure platform in partnership with established vendor.
- Develop ETL (extract, transform and load) processes to populate Data Marts and Warehouses
- Develop systems integrations across between traditional databases and modern Cloud APIs.
- Design, model and develop across both Relational Databases and Data Warehouse and Synapse
- Troubleshoot data integrations/data feeds between systems.
Qualifications
- Advanced SQL development experience
- Must have experience with at least one end to end implementation of Azure cloud data warehouse
- Experience with Lakehouse architecture and design for multi-tenant, OLTO data modeling, dimensional data modeling, composite modeling, data transformation analytical data structures for analytics and statistical model processing.
- Experience with Azure SQL Server technologies including Synapse SQL Dedicated and On-Demand pools.
- Experience with Azure products and services including Azure Data Lake Gen2, Azure Pipelines, Azure Databricks, Databricks API, Databricks error loggins, Azure SQL Serve and Azure Analysis Services.
- Experience with data integration through API's, Web Services, SOAP and/or REST Services.
- Experience in Power BI, Power BI Services, Power BI Gateway and Power BI Dataflow
- Additional programming experience is a plus (Python, Scala, R).
- Full working proficiency in English
Additional Information
If you feel it is time to make your skills and knowledge visible within a growing company with true focus on its people, then PSI is the right choice for you.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: APIs Architecture Azure Business Intelligence Data Analytics Databricks Dataflow Data pipelines Data warehouse ETL Machine Learning ML models Pipelines Power BI Python R RDBMS Scala SQL Statistics
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Manager jobs
- Open Lead Data Analyst jobs
- Open MLOps Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Science Manager jobs
- Open Principal Data Engineer jobs
- Open Data Engineer II jobs
- Open Sr Data Engineer jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Product Data Analyst jobs
- Open Business Intelligence Developer jobs
- Open Data Analytics Engineer jobs
- Open Junior Data Scientist jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Business Data Analyst jobs
- Open Data Analyst Intern jobs
- Open Big Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Manager, Data Engineering jobs
- Open Junior Data Engineer jobs
- Open Data Product Manager jobs
- Open Data Quality Analyst jobs
- Open Research Scientist jobs
- Open GCP-related jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Data visualization-related jobs
- Open Finance-related jobs
- Open Deep Learning-related jobs
- Open PhD-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open PyTorch-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open CI/CD-related jobs
- Open LLMs-related jobs
- Open Kubernetes-related jobs
- Open Generative AI-related jobs
- Open Data governance-related jobs
- Open Hadoop-related jobs
- Open Airflow-related jobs
- Open Docker-related jobs