Senior Business Intelligence Consultant

Company : Delta technology and management Type : Type : Model : Stage : : IT Description :

Role Overview :

We are looking for a highly skilled Business Intelligence / ETL Engineer with at least 6+ years of enterprise experience in BI and ETL environments. The ideal candidate will possess strong analytical abilities, deep expertise in data warehousing and dimensional modeling, and hands-on experience with SSIS, SSRS, SSAS, and SQL.

This role requires a disciplined, detail-oriented professional who can design and implement robust BI / ETL solutions while contributing to both individual and team Responsibilities :

• Analyze source systems and perform detailed data analysis.
• Design and implement Source-Target Mapping definitions, transformations, jobs, and sequences.
• Develop BI and Data Warehouse solutions with strong dimensional modeling skills.
• Build and maintain SSIS, SSRS, and SSAS components.
• Develop SQL queries, stored procedures, and perform query performance tuning.
• Integrate data from SQL Server and Oracle databases.
• Extract and transform data using MDX queries.
• Develop custom C# .NET functions for ETL transformations.
• Document ETL processes and ensure proper unit testing and signoff.
• Work independently as well as mentor and guide other team members.
• Ensure project discipline by meeting deliverable dates and maintaining quality Skills :
• 6+ years of enterprise-level experience in BI / ETL environments.
• Strong analytical skills.
• Expertise in Data Warehousing and BI architecture.
• Strong dimensional modeling capabilities.
• Proficiency in SSIS, SSRS, SSAS.
• Strong SQL programming and stored procedure skills.
• Hands-on experience with source / data analysis.
• Proven knowledge of ETL performance tuning and optimization.
• Experience in C# .NET for custom transformations.
• Excellent verbal and written communication, including technical to Have :
• Knowledge of cloud-based ETL solutions (i.e., Azure Data Factory).
• Familiarity with additional BI tools and programming languages (i.e., Python).
• Knowledge of Power BI.
• Experience with ERP integrations such as JDE E1.

(ref : hirist.tech)