We are seeking an experienced ETL Developer with over 5 years of expertise in data transformation, integration, and visualization. The ideal candidate will have extensive experience in developing and maintaining ETL processes, data cleansing, data analysis, and implementing end-to-end BI solutions using the MSBI stack. Proficiency in SQL Server, T-SQL, and Azure cloud services is essential for this role.
Key Responsibilities:
ETL Development: Design, implement, and maintain ETL processes using SQL Server Integration Services (SSIS) for efficient data extraction, transformation, and loading.
Data Transformation Integration: Develop data transformation and integration solutions, ensuring data consistency and accuracy across systems.
Data Cleansing Validation: Perform data cleansing, validation, and enrichment to ensure high-quality data for reporting and analysis.
Data Analysis Mining: Analyze large datasets to uncover trends, patterns, and insights; perform data mining to support decision-making processes.
Data Visualization: Create and maintain visualizations to present data insights effectively to stakeholders.
Database Development: Develop and maintain database objects including tables, stored procedures, triggers, and user functions within a SQL Server environment.
BI Solutions: Implement end-to-end BI solutions using the MSBI stack, including SSRS (SQL Server Reporting Services) and SSAS (SQL Server Analysis Services).
Data Warehousing: Design and manage data warehouse solutions, including star schemas, snowflakes, and dimensional modeling.
Performance Optimization: Optimize T-SQL query performance, including query tuning, removing unnecessary columns, and establishing efficient joins.
Reusable Components: Create and manage reusable SSIS components for streamlined ETL processes.
Database Design: Contribute to physical and logical database design, data mapping, and table normalization.
Data Migration: Identify dimensions, facts, measures, and hierarchies for data migration to SQL Server databases.
Performance Tuning: Utilize DMV s, SQL Profiler, and Extended Events for database performance optimization, debugging, and tuning.
Cloud Services: Work with Microsoft Azure cloud services including Azure Blob Storage, Azure SQL Server, and Azure Data Factory.
Version Control: Use GIT (Azure DevOps) for version control and collaboration.
Agile/SCRUM: Participate in Agile/SCRUM methodologies for project management and development.
Required Qualifications:
Experience: Minimum of 5 years of experience in ETL development and data warehousing.
Technical Skills: Advanced proficiency in T-SQL, SSIS, and SQL Server database management.
BI Tools: Experienced with MSBI stack including SSRS and SSAS.
Data Warehousing: Strong knowledge of data warehousing methodologies and concepts such as star schemas, snowflakes, and dimensional modeling.
Performance Optimization: Skilled in optimizing T-SQL queries and database performance.
Azure Services: Experience with Microsoft Azure cloud services.
Agile/SCRUM: Familiarity with Agile/SCRUM project management methodologies.
Version Control: Proficient in GIT version control and Azure DevOps.
Preferred Qualifications:
Bachelor s degree in Computer Science, Information Systems, or a related field.
Certifications in Microsoft SQL Server or Azure Data Technologies.
Experience with additional BI tools and data visualization platforms.
Job Classification
Industry: Software ProductFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Data warehouse DeveloperEmployement Type: Full time