Job description

Key Skill Areas for a Power BI, SSIS, SSRS Developer:Data Integration & ETL (SSIS):Designing, developing, and maintaining using SQL Server Integration Services (SSIS) to extract, transform, and load data from various sources into data warehouses. Experience with transformations, error handling, logging, and package configurations. Data migration techniques using tools like DTS Import and Export Data and BCP. Reporting (SSRS):Creating various report types, including standard, ad-hoc, parameterized, drill-down, and drill-through reports using . Experience with Matrix reports, charts, and graphs in SSRS. Managing and scheduling reports, including email subscriptions. Data Visualization & Analytics (Power BI):Connecting to multiple data sources, transforming data using , and modeling data. Creating compelling visualizations and dashboards in Power BI Desktop and publishing them to the Power BI service. Familiarity with DAX (Data Analysis eXpression) for advanced calculations within Power BI models. Understanding of data science, business intelligence, and data analytics principles. SQL Server & Database Skills:Strong proficiency in and , including writing complex queries, stored procedures, functions, and views. Knowledge of concepts, including , data modeling, and building cubes with (a plus). Experience with performance tuning and query optimization. Other Essential Skills:Analytical and Problem-Solving Skills: Crucial for troubleshooting issues and finding efficient solutions. Communication Skills: Effectively interacting with business analysts and stakeholders to gather and analyze requirements. Software Development Life Cycle (SDLC): Understanding of methodologies like Agile, Waterfall, and V-model. Cloud Technologies: Experience with cloud platforms like Azure or AWS is often beneficial as many companies utilize cloud services.

Requirements