Overview
On Site
$60,000 - $80,000
Full Time
Skills
Power BI
ETL
SSIS/SSRS
Data Visualization & Analytics
DAX
SQL Server
T-SQL
SSAS
SDLC
Azure & AWS
Linux
Job Details
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.
- Designing, developing, and maintaining using SQL Server Integration Services (SSIS) to extract, transform, and load data from various sources into data warehouses.
- 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.
- Creating various report types, including standard, ad-hoc, parameterized, drill-down, and drill-through reports using .
- 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.
- Connecting to multiple data sources, transforming data using , and modeling data.
- 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.
- Strong proficiency in and , including writing complex queries, stored procedures, functions, and views.
- 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.
- Analytical and Problem-Solving Skills: Crucial for troubleshooting issues and finding efficient solutions.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.