Premiumcoding
SSIS/Power BI Developer :: Pittsburgh, PA-Fully Onsite
Premiumcoding, Augusta, Maine, us, 04338
Overview
Position: SSIS/Power BI Developer Location: Pittsburgh, PA - Onsite Contract: 6+ Months Job Description
We are seeking a highly skilled
SSIS/Power BI Developer
to design, develop, and maintain robust data integration and visualization solutions. You will play a key role in transforming raw data into actionable insights through ETL pipelines, optimized data models, and interactive dashboards. This role requires both strong technical expertise and a keen eye for business intelligence. Key Responsibilities
ETL Development:
Design, build, and maintain SSIS packages to extract, transform, and load (ETL) data from multiple sources into data warehouses or data marts. Optimize ETL processes for performance, reliability, and scalability.
Data Modeling & Integration:
Develop and maintain SQL Server databases, schemas, stored procedures, and views to support reporting requirements. Ensure data quality, integrity, and consistency across systems.
Power BI Development:
Create and deploy highly interactive Power BI dashboards, reports, and visualizations tailored to business needs. Implement row-level security, DAX measures, and optimized data models for efficient reporting.
Collaboration:
Work closely with business analysts, data engineers, and stakeholders to translate requirements into technical solutions. Provide training or documentation to end users on Power BI reports and self-service BI capabilities.
Maintenance & Support:
Monitor ETL workflows, resolve production issues, and perform root cause analysis. Ensure compliance with security, data governance, and performance best practices.
Required Qualifications
Technical Skills:
Strong expertise in
SQL Server Integration Services (SSIS)
ETL design, debugging, deployment. Proficiency in
Power BI
report building, DAX formulas, data modeling. Advanced SQL skills for writing complex queries and optimizing performance. Familiarity with data warehousing concepts, star/snowflake schemas, and OLAP/Tabular models.
Experience:
8 years of experience in data integration, BI development, or related roles. Proven track record of delivering end-to-end BI solutions in production environments.
Other Skills:
Strong analytical thinking, problem-solving ability, and attention to detail. Excellent communication skills for interacting with both technical and non-technical teams.
Preferred Qualifications
Experience with
Azure Data Factory ,
Synapse , or other cloud-based ETL/BI tools. Knowledge of
Python
or
R
for advanced analytics. Exposure to Agile/Scrum development methodologies.
#J-18808-Ljbffr
Position: SSIS/Power BI Developer Location: Pittsburgh, PA - Onsite Contract: 6+ Months Job Description
We are seeking a highly skilled
SSIS/Power BI Developer
to design, develop, and maintain robust data integration and visualization solutions. You will play a key role in transforming raw data into actionable insights through ETL pipelines, optimized data models, and interactive dashboards. This role requires both strong technical expertise and a keen eye for business intelligence. Key Responsibilities
ETL Development:
Design, build, and maintain SSIS packages to extract, transform, and load (ETL) data from multiple sources into data warehouses or data marts. Optimize ETL processes for performance, reliability, and scalability.
Data Modeling & Integration:
Develop and maintain SQL Server databases, schemas, stored procedures, and views to support reporting requirements. Ensure data quality, integrity, and consistency across systems.
Power BI Development:
Create and deploy highly interactive Power BI dashboards, reports, and visualizations tailored to business needs. Implement row-level security, DAX measures, and optimized data models for efficient reporting.
Collaboration:
Work closely with business analysts, data engineers, and stakeholders to translate requirements into technical solutions. Provide training or documentation to end users on Power BI reports and self-service BI capabilities.
Maintenance & Support:
Monitor ETL workflows, resolve production issues, and perform root cause analysis. Ensure compliance with security, data governance, and performance best practices.
Required Qualifications
Technical Skills:
Strong expertise in
SQL Server Integration Services (SSIS)
ETL design, debugging, deployment. Proficiency in
Power BI
report building, DAX formulas, data modeling. Advanced SQL skills for writing complex queries and optimizing performance. Familiarity with data warehousing concepts, star/snowflake schemas, and OLAP/Tabular models.
Experience:
8 years of experience in data integration, BI development, or related roles. Proven track record of delivering end-to-end BI solutions in production environments.
Other Skills:
Strong analytical thinking, problem-solving ability, and attention to detail. Excellent communication skills for interacting with both technical and non-technical teams.
Preferred Qualifications
Experience with
Azure Data Factory ,
Synapse , or other cloud-based ETL/BI tools. Knowledge of
Python
or
R
for advanced analytics. Exposure to Agile/Scrum development methodologies.
#J-18808-Ljbffr