SSIS (SQL Server Integration Services) Administration

Design, develop, and maintain ETL (Extract, Transform, Load) processes using SSISMonitor and optimize SSIS package performance and troubleshoot failuresManage SSIS catalog, deployments, and scheduling of packagesEnsure data integrity and accuracy by implementing data validation and error handling mechanismsCollaborate with database administrators and developers to integrate SSIS with other systemsGeneral ResponsibilitiesMonitor system health, performance, and availability of BI tools and servicesPerform regular backups, updates, and patches for BI tools and related systemsDocument processes, configurations, and best practices for BI administrationProvide technical support and training to end-users and stakeholdersCollaborate with cross-functional teams to ensure alignment between BI tools and business objectivesStay informed about industry trends and emerging technologies in BI and data analyticsBuilding Analysis Services reporting modelsMigrating Self-Service Reports From Oracle BI and Tableau To Power BI Self-serviceMigrate Reports and Dashboards from oracle BI to Power BIQualificationsEducationBachelor's degree in Computer Science, Information Technology, Data Science, or a related fieldExperience5+ years of experience in administering and managing Power BI, SSIS, and SSASStrong understanding of data warehousing, ETL processes, and BI conceptsExperience with SQL Server, including T‑SQL scripting and database administrationFamiliarity with data visualization best practices and toolsExperience with cloud platforms (e.g., Azure, AWS) is a plusTechnical SkillsProficiency in Power BI administration, including Power BI Service and Power BI Report ServerExpertise in SSIS package development, deployment, and troubleshootingStrong knowledge of SSAS, including cube design, processing, and optimizationExperience with data modeling, DAX, and MDXKnowledge of data gateways, dataflows, and Power QueryFamiliarity with PowerShell scripting for automation tasksSoft SkillsStrong problem‑solving and analytical skillsExcellent communication and collaboration skillsAbility to work independently and manage multiple prioritiesAttention to detail and a commitment to data accuracy and qualityPreferred CertificationsMicrosoft Certified: Power BI Data Analyst AssociateMicrosoft Certified: Azure Data Engineer AssociateMicrosoft Certified: SQL Server Database Administration#J-18808-Ljbffr