MO 85-Power BI and Data Engineer

Focused HR Solutions; Cary (NC); Hybrid; USD 100,000 - 130,000; Full time

Job summary

Focused HR Solutions has a Raleigh-based opening for a Power BI and Data Engineer. The role focuses on designing and delivering robust BI solutions, building scalable data pipelines, and tuning SQL for performance.

The candidate will work hybrid in Raleigh, NC and collaborate with data teams to transform sources into reliable dashboards and analytical models. Required skills include Power BI, Azure Synapse, Databricks, and strong SQL (T-SQL/PL-SQL) expertise, plus Python or Scala for data

Qualifications

• 5+ years of experience building dashboards in Power BI.
• Experience supporting Power BI datasets, dataflows, and DirectQuery/Import models.
• Experience with JSON, CSV, Parquet and other structured/semi-structured formats.
• Designing and optimizing scalable data pipelines with Azure Synapse/Snowflake/Databricks.
• Advanced SQL skills including ETL/ELT, performance tuning.
• Proficiency in Python or Scala for data processing.
• Hands-on PL/SQL development experience.
• Experience with SQL scripting and data query optimization.
• Strong knowledge of Azure cloud services (Synapse, Data Lake, Data Factory, Azure SQL).
• Experience with ADLS, Delta Lake and data warehousing concepts.

Skills

Power BI dashboards

Azure Synapse

Databricks

Snowflake

SQL

Python/Scala

PL/SQL

T-SQL

Azure Data Lake Storage

Delta Lake

Data warehousing concepts

Tools

Power BI

Azure Synapse

Snowflake

Databricks

Delta Lake

Azure Data Lake Storage

PL/SQL

T-SQL

Python

Scala

Job description

This job is hybrid in Raleigh, NC

Our client has an opening for Power BI and Data engineer (806590).

This position is up to 12 months, with the option of an extension, and the client is in Raleigh, NC.

Requirements

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