SSIS/SQL Engineer

Description

· Design, develop, and maintain integration solutions to connect various data sources with BI platforms

· Implement Extract, Transform, Load (ETL) processes for efficient data flow

· In-depth knowledge and hands-on experience with SQL Server Integration Services (SSIS)

· Hands-on experience using Microsoft's BI and data stack, including Server Reporting Services (SSRS), Power BI, Data Factory, and other relevant tools

· Create and optimize data models to support BI reporting and analytics

· Integrate BI solutions with other applications and services through API integration

· Implement data governance practices to ensure the accuracy, consistency, and security of data within BI solutions

· Adhere to data policies and standards

· Collaborate with business analysts, BI developers, and other stakeholders to understand integration requirements and deliver solutions that align with business needs

· Provide support for integration-related issues, identifying and resolving problems, and ensuring the overall reliability of BI integration solutions

· Leverage Microsoft Azure cloud services for integration, storage, and deployment

· Create and maintain documentation for integration processes, custom development, and data models

· Ensure that documentation is comprehensive and accessible to team members

Responsibilities

• · In depth experience and understand of SSIS as a whole with advance SQL writing capabilities and understanding
• · SSIS Theorist Mindset
• · Hyper communication and inquisitive
• · Driver with high level of self-motivation
• · Extreme accountability and ownership
• · Extensive hands-on experience
• · Critical thinking and problem-solving skills
• · Required to have familiarity or experience with Validated Systems