DMS Vision, Inc.
Position: SSIS/Power BI Developer
Location: Pittsburgh, PA-Fully Onsite
Contract: 6+Months Contract
Job Description:
About the Role
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.
Location: Pittsburgh, PA-Fully Onsite
Contract: 6+Months Contract
Job Description:
About the Role
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.