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.