BI Developer

As a SQL Server/T-SQL Developer, you will be responsible for creating and optimizing complex Stored Procedures, UDFs, CTEs, and Triggers. Your overall experience should be between 4 to 7 years. You should have experience working in a data warehouse environment and a strong understanding of dimensional data modeling concepts, SQL server, DW principles, and SSIS. Your key responsibilities will include: - Building data transformations with SSIS, including importing data from files and moving data from source to destination. - Creating new SSIS packages or modifying existing ones using SQL server. - Debugging and fine-tuning SSIS processes to ensure accurate and efficient movement of data. - Conducting ETL testing and data validation. - Working with Azure services like Azure Data Factory, Data flow, Azure blob Storage, etc. - Developing Azure Data Factory Objects such as ADF pipeline, configuration, parameters, variables, and Integration services runtime. - Collaborating in an agile development environment to build Business Intelligence solutions. - Utilizing Power BI or SSRS for reporting purposes. - Working on an Agile/Scrum team is preferred. - Demonstrating strong problem-solving skills, troubleshooting abilities, and root cause analysis. - Having excellent written and verbal communication skills. Please note that the company values collaboration and agility in its development processes. As a SQL Server/T-SQL Developer, you will be responsible for creating and optimizing complex Stored Procedures, UDFs, CTEs, and Triggers. Your overall experience should be between 4 to 7 years. You should have experience working in a data warehouse environment and a strong understanding of dimensional data modeling concepts, SQL server, DW principles, and SSIS. Your key responsibilities will include: - Building data transformations with SSIS, including importing data from files and moving data from source to destination. - Creating new SSIS packages or modifying existing ones using SQL server. - Debugging and fine-tuning SSIS processes to ensure accurate and efficient movement of data. - Conducting ETL testing and data validation. - Working with Azure services like Azure Data Factory, Data flow, Azure blob Storage, etc. - Developing Azure Data Factory Objects such as ADF pipeline, configuration, parameters, variables, and Integration services runtime. - Collaborating in an agile development environment to build Business Intelligence solutions. - Utilizing Power BI or SSRS for reporting purposes. - Working on an Agile/Scrum team is preferred. - Demonstrating strong problem-solving skills, troubleshooting abilities, and root cause analysis. - Having excellent written and verbal communication skills. Please note that the company values collaboration and agility in its development processes.