Power BI and Data Engineer
datastaffRaleigh (NC)
About the role
DataStaff, Inc. is in need of a Power BI and Data Engineer for a long-term contract opportunity with one of our direct clients located in Raleigh, NC*This position is hybrid.
Job Description:
The Data Engineer is responsible for the design, development, and optimization of data pipelines and analytics solutions/dashboards on cloud-based data platforms. This work will leverage Azure Synapse Analytics, Power BI, and integrations with Salesforce or Curam/Oracle to support program needs.
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.
Required Skills:
5 Years - Strong Hands-on experience configuring, designing, developing and testing dashboards using Power BI5 Years - Experience supporting Power BI datasets, dataflows, and DirectQuery/Import models.3 Years - Experience working with structured and semi-structured data formats (JSON, CSV, Parquet, etc.).3 Years - Strong experience in designing and optimizing scalable data pipelines using modern platforms like Azure Synapse, Snowflake or Databricks workflows 5 Years - SQL Mastery: Advanced query writing, ETL/ELT, performance tuning, and optimization.3 Years - Programming Languages: Strong proficiency in Python or Scala for data processing.5 Years - Hands-on experience in developing efficient PL/SQL procedures 2 Years - Experience with Programming and Scripting (SQL, T-SQL, and data query optimization)2 Years - Solid understanding of Azure cloud services (Synapse, Data Lake, Data Factory, Azure SQL, monitoring tools).2 Years - Experience in Azure Data Lake Storage (ADLS), Delta Lake, and data modeling concepts and Warehousing (star schema, snowflake schema) This position is available as a corp-to-corp or W2 position with a competitive benefits package. DataStaff offers medical, dental, and vision coverage options as well as paid vacation, sick, and holiday leave. As many of our opportunities are long-term, we also have a 401k program available for employees after 6 months.
Before you apply
Applying takes about a minute. These four things decide how fast it moves after that.
Your profile is current
It's what we read first. Occupations, seniority and locations matter more than a long history.
Two examples you can talk through
Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.
A number in mind
What you're on now and what would make you move. We negotiate better when we know both.
Your notice period
Employers plan around it, and it's the question that stalls offers most often.
Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.
More like this