Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing by QRM Builds data transformations with SSIS including importing data from files, moving data from one database platform to another Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data Design, implement and maintain database objects (tables, views, indexes, ) and database security Experience working with SSIS packages Proficient with ETL tools such as Microsoft SSIS Analyze and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations Test and prepare ETL processes for deployment to production and non-production environments Support system and acceptance testing including the development or refinement of test plans Designing and developing Power BI reports and dashboards to meet the business stakeholders needs Gathering and understanding business requirements for data visualization and analysis Collaborating with data engineers and analysts to acquire, clean, and transform data for reporting purposes Creating complex DAX calculations and measures to support data analysis Ensuring data security and compliance with best practices Troubleshooting and resolving issues in Power BI reports Familiarity with data warehouse concepts Excellent attention to detail and problem-solving skills Ability to work independently and as a part of a team