Power BI & Data Engineer

Power BI & Data Engineer

Location: Raleigh, NC
Job Type: Contract
Work Arrangement: Remote/Hybrid — as applicable

Role Summary

We are looking Power BI & Data Engineer to design, develop, and optimize scalable data pipelines, cloud-based data solutions, and analytics dashboards. The role will leverage Azure Synapse Analytics, Azure Data Factory, Power BI, Azure Data Lake, and integrations with systems such as Salesforce and Curam/Oracle to support business and program needs.

Key Responsibilities

• Design, develop, and maintain scalable ETL/ELT data pipelines using Azure Synapse, Azure Data Factory, and related Azure services.
• Build data ingestion workflows from Salesforce, including API integrations, schema mapping, and performance tuning.
• Develop and maintain Power BI dashboards, reports, datasets, dataflows, semantic models, and data transformations.
• Support both DirectQuery and Import data models.
• Design and optimize data models and warehouse structures, including star and snowflake schemas.
• Optimize Synapse pipelines, SQL queries, and data storage for performance, reliability, and cost efficiency.
• Work with structured and semi-structured data including JSON, CSV, Parquet, and similar formats.
• Develop efficient PL/SQL, SQL, and T-SQL queries and procedures.
• Troubleshoot pipeline failures, Salesforce API issues, and Power BI dataset/dataflow refresh problems.
• Use Python or Scala for data processing and transformation.
• Monitor and support Azure data services and resolve production issues.

Required Skills & Experience

• 5+ years hands-on experience designing, developing, and testing Power BI dashboards.
• 5+ years supporting Power BI datasets, dataflows, and DirectQuery/Import models.
• 5+ years of advanced SQL, ETL/ELT, query writing, performance tuning, and optimization.
• 5+ years developing efficient PL/SQL procedures.
• 3+ years working with scalable data pipelines using Azure Synapse, Snowflake, Databricks, or similar modern data platforms.
• 3+ years working with structured and semi-structured data such as JSON, CSV, and Parquet.
• 3+ years of Python or Scala experience for data processing.
• 2+ years experience with Azure cloud services, including Synapse, Data Lake, Data Factory, Azure SQL, and monitoring tools.
• 2+ years experience with Azure Data Lake Storage (ADLS), Delta Lake, data modeling, and data warehousing.
• Experience with SQL, T-SQL, and data query optimization.
• Strong understanding of data engineering, analytics, data integration, and cloud-based platforms.
• Experience integrating data from Salesforce APIs is highly valuable.

Core Technologies

Power BI | Azure Synapse Analytics | Azure Data Factory | ADLS | Azure SQL | Delta Lake | Salesforce | SQL | T-SQL | PL/SQL | Python/Scala | ETL/ELT | DirectQuery | Dataflows | Data Modeling | Star/Snowflake Schema | JSON | CSV | Parquet