BI Engineer for Global MedTech Company (ETL, DWH, SQL, Azure)
-
Plat
2 000 - 4 000 € (brutto)
-
Miesto
Práca z domu, SLOVENSKO
-
Jazyky
Anglický B2
-
ID
875
-
Úväzok
Plný úväzok
Job description, responsibilities and duties
- Oversee and sustain the efficiency, availability, and security of Business Intelligence (BI) platforms and tools.
- Offer technical assistance and guidance to BI users, troubleshooting issues related to data integrity, system access, and report generation.
- Work closely with BI analysts and IT teams to enhance and implement new functionalities in BI systems.
- Create and update documentation for BI system configurations, workflows, and standard procedures.
- Perform routine system audits to detect and resolve potential problems proactively.
- Support the integration of BI tools with various enterprise systems and databases.
- Educate users on BI tool utilization and advocate best practices within the organization.
- Stay updated on emerging BI technologies to recommend system improvements.
Database & Data Warehousing Focus
- Expertise in OLTP/OLAP database systems, data warehousing (DWH), ETL/ELT processes, and Business Intelligence (BI) reporting.
- Develop complex T-SQL stored procedures and optimize SQL code using tools like SQL Sentry and Execution Plans.
- Design and manage database objects such as tables, views, and functions.
- Build and maintain ETL pipelines using SSIS and Azure Data Factory (ADF) for seamless data movement to the Data Warehouse.
- Utilize Azure DevOps Server (formerly TFS) for documentation updates and version control.
Reporting & Business Intelligence
- Develop and manage SSRS reports and Power BI dashboards.
- Administer Microsoft SQL Server databases, including performance optimization, indexing, storage management, replication, user permissions, and SQL Agent job scheduling.
- Work with Azure VM, Azure SQL Database, Azure Data Factory, and other cloud-based data services.
- Improve Operational Data Store (ODS) by implementing new features and optimizing data pipelines for structured and unstructured data.
- Diagnose, debug, and fix SSIS packages and SQL Server Agent jobs.
Development & Process Optimization
- Utilize Git and Bitbucket for version control and collaboration.
- Develop automation scripts using Python (Airflow) for workflow orchestration.
- Work within Agile SCRUM and KANBAN methodologies for efficient project execution.
- Design, develop, and optimize Power BI solutions, integrating them with SQL Server to fulfill business requirements.
Key Technologies & Tools
SQL Server, SSIS, T-SQL, JSON, SQL Server Agent, Git, Python (Airflow), Power BI, Azure (VM, SQL Database, Data Factory), ETL/ELT, DWH, BI Reporting.
Employee perks, benefits
A rich and sophisticated bonus system.
Company on whose behalf the position is being filled
Other manufacturing
Out client is global company within medical products and technologies.
Candidates with education suit the position
Secondary with school-leaving examination
Follow-up/Higher Professional Education
University education (Bachelor's degree)
University education (Master's degree)
Postgraduate (Doctorate)
Educational Specialization
Information Technology
Language skills
English - Upper intermediate (B2)
Personality requirements and skills
Key Requirements:
- Demonstrated experience as a BI Support Engineer or in a similar role, with expertise in BI tools and technologies such as Power BI, Tableau, or QlikView.
- Strong proficiency in SQL and experience working with database management systems like SQL Server or Oracle.
- Excellent problem-solving abilities, with a talent for quickly identifying and resolving technical issues.
- Strong communication and interpersonal skills, capable of explaining technical concepts to non-technical users.
- Knowledge of data warehouse design and ETL processes.
- Ability to work both independently and collaboratively in a dynamic, fast-paced environment.
- Education and Qualifications:A bachelor’s degree in Computer Science, Information Systems, or a related discipline.
- Strong SQL skills and a solid understanding of relational databases.
- Experience with business intelligence tools such as Tableau, Power BI, or QlikView.
- Understanding of ETL processes, data warehousing, and data modeling concepts.