BI Analyst

Job Description

osition Overview: As a Business Intelligence Analyst with a specialized focus on SSIS, you will play a crucial role in designing and implementing robust ETL processes to streamline data integration and support our advanced analytics initiatives. You will collaborate closely with cross-functional teams to gather business requirements, develop scalable data solutions, and deliver actionable insights that drive business growth and innovation.

Key Responsibilities:

• Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS) to extract, transform, and load data from various sources into our data warehouse.
• Collaborate with business stakeholders to understand data requirements and translate them into technical specifications for ETL development.
• Optimize SQL queries, stored procedures, and views to support data integration and reporting needs.
• Monitor and troubleshoot ETL jobs to ensure the reliability and performance of data pipelines.
• Conduct data validation and reconciliation to ensure the accuracy and consistency of data across different systems.
• Document ETL processes, data mappings, and data lineage to ensure compliance and facilitate knowledge transfer.
• Stay updated on industry trends, best practices, and emerging technologies in business intelligence and data integration.

Qualifications:

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• Proven experience in developing ETL processes using SQL Server Integration Services (SSIS) in a business intelligence or data warehousing environment.
• Strong proficiency in SQL programming and database management with a solid understanding of relational database concepts.
• Familiarity with data modeling principles and dimensional modeling techniques.
• Excellent analytical and problem-solving skills with the ability to interpret complex data sets and extract actionable insights.
• Effective communication and collaboration skills with the ability to work across functional teams.
• Self-motivated and detail-oriented with a passion for continuous learning and professional development.
• Experience with other business intelligence tools such as Power BI, Tableau, or QlikView is a plus.
• Relevant certifications in SQL Server or business intelligence technologies are desirable