MO 85-Power BI and Data Engineer

Focused HR Solutions; Raleigh (NC); Hybrid; USD 90,000 - 120,000; Full time

Job summary

Focused HR Solutions seeks a Power BI & Data Engineer in Raleigh, NC for a hybrid, contract role. The candidate will design, build and optimize Power BI dashboards and data pipelines, leveraging Azure Synapse, Databricks or Snowflake, and SQL-based ETL/ELT processes. Strong experience with ADLS/Delta Lake and data modeling is required.

The project runs up to 12 months with possible extension. Hybrid work arrangement in Raleigh, NC, with emphasis on data integration, performance tuning and cloud

Qualifications

• Strong hands-on experience configuring, designing, developing and testing dashboards using Power BI.
• Experience supporting Power BI datasets, dataflows, and DirectQuery/Import models.
• Experience with JSON, CSV, Parquet data formats.
• Experience designing scalable data pipelines on Azure Synapse, Snowflake or Databricks workflows.
• Advanced SQL for ETL/ELT, performance tuning and optimization.
• Proficiency in Python or Scala for data processing.
• PL/SQL development experience.
• SQL, T-SQL, and data query optimization.
• Solid understanding of Azure cloud services (Synapse, Data Lake, Data Factory, Azure SQL, monitoring tools).
• Experience with ADLS, Delta Lake, and data modeling concepts including star/snowflake schemas.

Skills

Power BI dashboards

Power BI datasets

JSON/CSV/Parquet

Azure Synapse

Snowflake/Databricks

SQL proficiency

Python/Scala

PL/SQL

T-SQL

Azure data services

ADLS/Delta Lake

Data warehousing concepts

Data modeling

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.
• The State of NC has the right to negotiate the rate. Please confirm you accept.
• 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.