Excelraise, LLC is a leading provider of full-service IT solutions and a talent management company headquartered in Denver, CO. At Excelraise, we specialize in IT staffing solutions tailored for government and federal clients across the USA.

Excelraise, LLC values your referrals! Refer qualified candidates for our open Job Postings and earn a generous REFERRAL BONUS for successful placements. Submit referrals here: Excelraise Referral Program.

Excelraise, LLC is seeking a Power BI and Data engineer for our client in 1915 Health Services Way, Raleigh, NC.

Skills

• Strong Hands-on experience configuring, designing, developing and testing dashboards using Power BI
• Experience supporting Power BI datasets, dataflows, and DirectQuery/Import models.
• Experience working with structured and semi-structured data formats (JSON, CSV, Parquet, etc.).
• Strong experience in designing and optimizing scalable data pipelines using modern platforms like Azure Synapse, Snowflake or Databricks workflows
• SQL Mastery: Advanced query writing, ETL/ELT, performance tuning, and optimization.
• Programming Languages: Strong proficiency in Python or Scala for data processing.
• Hands-on experience in developing efficient PL/SQL procedures
• Experience with Programming and Scripting (SQL, T-SQL, and data query optimization)
• Solid understanding of Azure cloud services (Synapse, Data Lake, Data Factory, Azure SQL, monitoring tools).
• Experience in Azure Data Lake Storage (ADLS), Delta Lake, and data modeling concepts and Warehousing (star schema, snowflake schema)
• Please provide a brief description of recent hands-on development work in building data pipeline using Azure Synapse Analytics.
• Please provide a brief description of recent hands-on development work in building and managing Power BI dashboards.

Key Responsibilities:

• Analyze source systems and design, develop, and maintain scalable ETL/ELT pipelines using Azure Synapse, Azure Data Factory, and related Azure services.
• Build and manage data ingestion workflows from Salesforce, including API integrations, schema alignment, and performance tuning.
• Develop and maintain data models, data transformations,and semantic layers to support Power BI reporting and analytics.
• Optimize Synapse pipelines, SQL queries, and data storage for performance, reliability, and cost efficiency.
• Troubleshoot pipeline failures, Salesforce API issues,and Power BI dataset/dataflow refresh problems.