Talent.com
عرض العمل هذا غير متوفر في بلدك.
SSIS (SQL Server Integration Services) Administration

SSIS (SQL Server Integration Services) Administration

Master-WorksRiyadh, Riyadh Region, Saudi Arabia
2 منذ أيام
الوصف الوظيفي

Responsibilities

  • Design, develop, and maintain ETL (Extract, Transform, Load) processes using SSIS.
  • Monitor and optimize SSIS package performance and troubleshoot failures.
  • Manage SSIS catalog, deployments, and scheduling of packages.
  • Ensure data integrity and accuracy by implementing data validation and error handling mechanisms.
  • Collaborate with database administrators and developers to integrate SSIS with other systems.

General Responsibilities

  • Monitor system health, performance, and availability of BI tools and services.
  • Perform regular backups, updates, and patches for BI tools and related systems.
  • Document processes, configurations, and best practices for BI administration.
  • Provide technical support and training to end-users and stakeholders.
  • Collaborate with cross-functional teams to ensure alignment between BI tools and business objectives.
  • Stay informed about industry trends and emerging technologies in BI and data analytics.
  • Building Analysis Services reporting models
  • Migrating Self-Service Reports From Oracle BI and Tableau To Power BI Self-service
  • Migrate Reports and Dashboards from oracle BI to Power BI.

    • Qualifications

    Education :

  • Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field.

    • Experience :

  • 5+ years of experience in administering and managing Power BI, SSIS, and SSAS.
  • Strong understanding of data warehousing, ETL processes, and BI concepts.
  • Experience with SQL Server, including T-SQL scripting and database administration.
  • Familiarity with data visualization best practices and tools.
  • Experience with cloud platforms (e.g., Azure, AWS) is a plus.

    • Technical Skills :

  • Proficiency in Power BI administration, including Power BI Service and Power BI Report Server.
  • Expertise in SSIS package development, deployment, and troubleshooting.
  • Strong knowledge of SSAS, including cube design, processing, and optimization.
  • Experience with data modeling, DAX, and MDX.
  • Knowledge of data gateways, dataflows, and Power Query.
  • Familiarity with PowerShell scripting for automation tasks.

    • Soft Skills :

  • Strong problem-solving and analytical skills.
  • Excellent communication and collaboration skills.
  • Ability to work independently and manage multiple priorities.
  • Attention to detail and a commitment to data accuracy and quality.

    • Preferred Certifications :

  • Microsoft Certified : Power BI Data Analyst Associate
  • Microsoft Certified : Azure Data Engineer Associate
  • Microsoft Certified : SQL Server Database Administration

    • #J-18808-Ljbffr

    إنشاء تنبيه وظيفي لهذا البحث

    Server • Riyadh, Riyadh Region, Saudi Arabia