Job Description
Job Title: Power BI & Data Engineer
The Client is seeking a Power BI & Data Engineer for design, development, and optimization of a cloud-based analytics environment built on Microsoft Azure and Power BI for the Child Welfare and Medicaid Program(s). The Department of health and human services requires the assistance of a contract resource to serve as a Data Engineer 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. 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.
Required Skills :
Location: Raleigh, NC (Hybrid)
Duration: 12+ Months
Type: Contract
Job Description :The Client is seeking a Power BI & Data Engineer for design, development, and optimization of a cloud-based analytics environment built on Microsoft Azure and Power BI for the Child Welfare and Medicaid Program(s). The Department of health and human services requires the assistance of a contract resource to serve as a Data Engineer 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. 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.
Required 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 .
Numbers & Facts
| Location | Raleigh, NC |
| Industry | Computer/IT Services |
| Company Size | 20 to 49 employees |
| Year Founded | 2002 |
| Website | http://crescensinc.com/ |
About Company
Crescens Inc. is an industry leader in providing IT staffing services and tailored workforce solutions to meet the demanding expectations and distinctive needs of clients across the United States and Canada. We have grown tremendously in the past years and have been applauded by our clients for the quality of workforce and the quick turnaround time. We have evolved from good service to great service and all management plans are geared towards quality.
Our vision is to be the best in Talent Acquisition and strive for excellence consistently by focusing on four performance dimensions; Quality, Efficiency, Cost and Risk. A satisfied client and candidate are the backbone to our continued success. Headquartered in New Jersey, we are a team with unique expertise to deliver exceptional results to our clients by setting benchmarks and establishing best practices.
Skills
- Application Programming Interface (API)unmatched
- Child Protection/Welfareunmatched
- Cloud Computingunmatched
- Data Analysisunmatched
- Data Formatsunmatched
- Data Lakeunmatched
- Data Managementunmatched
- Data Modelingunmatched
- Data Processingunmatched
- Data Setsunmatched
- Data Storageunmatched
- Database Extract Transform and Load (ETL)unmatched
- Department of Health and Human Servicesunmatched
- Identify Issuesunmatched
- JSONunmatched
- Medicaidunmatched
- Microsoft Transact-SQL (T-SQL)unmatched
- Microsoft Windows Azureunmatched
- Oracleunmatched
- Oracle PL-SQLunmatched
- Performance Tuning/Optimizationunmatched
- Power BIunmatched
- Power Managementunmatched
- Programming Languagesunmatched
- Python Programming/Scripting Languageunmatched
- Query Optimizationunmatched
- Reporting Dashboardsunmatched
- SQL (Structured Query Language)unmatched
- Sales Pipelineunmatched
- Salesforce.comunmatched
- Scala Programming Languageunmatched
- Scalable System Developmentunmatched
- Scripting (Scripting Languages)unmatched
- Snowflake Schemaunmatched
- Star Schemaunmatched
- Structured Dataunmatched
- Systems Analysisunmatched
- Test Plan/Scheduleunmatched
- Training Data Setsunmatched
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesFree resume builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder