Job Description
DHHS-ITD is seeking a 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.
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.
Numbers & Facts
| Location | Raleigh, NC |
| Industry | Staffing/Employment Agencies |
| Company Size | 100 to 499 employees |
| Year Founded | 1990 |
| Website | http://www.sunrisesys.com/ |
About Company
Sunrise Systems was founded in 1990 with a clear vision to deliver world-class staffing service solutions in all labor categories, including IT consulting and solutions; all with the commitment to provide service that exceeds expectations and become the most trusted name in the industry. More than two and a half decades later, we pride ourselves on being at the forefront of the staffing industry. Combining our deep industry expertise, insights, and global resources, we have partnered with our clients to connect them with top professionals across several different industries.
We provide cost-effective Managed Staffing Solutions, Information Technology and Information Technology Consulting Services to several Fortune 500 companies and U.S. Government agencies. We provide our clients with flexible engagement models and customized products that are budget and time specific. Understanding the challenges that every business faces, we offer our services either on-site at the clients' site or from one of our globally distributed technology centers. Our onshore and offshore development capabilities ensure that we excel at meeting customer requirements every single time.
Our collective business experience spans over two and a half decades and ranges from:
- Business, management, and technical fields
- Information technology consulting and software solutions.
- Providing strategic support for the development and long-term growth of new business ventures across several industries including but not limited to; accounting, banking, finance, and recruitment.
- Motivating technology staff and establishing partnerships with Fortune 500 companies
Sunrise Systems has a vast range of competence in:
- Design, development, and support of cloud-based solutions from simple to highly complexed
- Database administration of multi-platform applications, complex databases, and web-based environments that include all aspects of installation, planning, maintenance, and monitoring.
- Data processing and data migration
- Application re-engineering and platform migration
- Working with the Information Systems and end-user communities at all levels to resolve issues and establish consensus.
Skills
- Application Programming Interface (API)unmatched
- Child Protection/Welfareunmatched
- Cloud Computingunmatched
- Data Analysisunmatched
- Data Managementunmatched
- Data Modelingunmatched
- Data Setsunmatched
- Data Storageunmatched
- Database Extract Transform and Load (ETL)unmatched
- Department of Health and Human Servicesunmatched
- Identify Issuesunmatched
- Medicaidunmatched
- Microsoft Product Familyunmatched
- Microsoft Windows Azureunmatched
- Oracleunmatched
- Performance Tuning/Optimizationunmatched
- Power BIunmatched
- Reporting Dashboardsunmatched
- SQL (Structured Query Language)unmatched
- Salesforce.comunmatched
- Scalable System Developmentunmatched
- Systems Analysisunmatched
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