Manager – Business Intelligence & Data Warehousing

• Design & Develop complex ETL projects in SSIS and implement Framework model.
• Monitor and fix errors, performance optimization and quality testing of SSIS packages.
• Migrate, re-design & Test ETL packages.
• Create data jobs workflow in orchestration tools like Control-M
• Deploy and Implement Projects in PROD
• Prepare Technical and Operational Document.
• Design & develop complex T-SQL/PL-SQL queries and stored procedures.
• Optimize SQL queries.
• Develop data models Star Schema, Snowflake Schema, implement databases, and analyze content and quality of packages
• Design, develop and maintain business intelligence solutions.
• Craft and execute queries upon request for data.
• Present information through reports and visualization
• Coordinate with various stakeholders across multiple functions to better understand their processes, data flows and priorities to manage projects related to data management and reporting
• Collaborate with various IT teams for infrastructure and service readiness and continuity
• Create advanced analysis tools to develop predictive models.
• Administer the advanced analytics applications and ensure smooth operations

• Data Integration tools
• ETL processes
• Data Modelling
• SQL Script development
• BI Reporting
• OLAP
• Cognos
• Tableau
• SAS Analytics

Bachelor’s Degree in Computer Science or MIS