Job Description :

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.
             

Similar Jobs you may be interested in ..