Integration Endpoint Developer -Columbia

Job Description

Job Ttitle: Integration Endpoint Developer -Columbia

Company: State of South Carolina


Description: About UsBusiness is booming in South Carolina! Are you ready to be a part of developing and connecting the next generation of workers in this state? Year after year, experts pick our state as one the best in the country for doing business. Just last year, South Carolina announced more than 14,000 new jobs and $10 billion in capital investment. Entrepreneurs are flocking to cities like Greenville, Charleston, Columbia, and Rock Hill to start and grow their businesses. And our hospitality industry is primed to take off as travelers from around the world continue to discover the beauty and accessibility of South Carolina’s mountains and coast.Here at the South Carolina Department of Employment and Workforce (DEW), we are laser-focused on connecting every jobseeker who comes through our doors with their next great career opportunity! Are you looking for a meaningful position at an agency brimming with optimism and camaraderie that also offers job security, affordable health insurance, great retirement benefits, and work-life balance? If so, continue reading to discover your chance to make a difference at DEW! Job DescriptionAre you an IT systems developer with experience in data integrations? Would you like to make a statewide impact?The Integration Endpoint Developer acts as the central developer for efforts to integrate various data points into the Azure Data Warehouse. This position is in the Information Technology Department in Columbia. The purpose of this position is creating data driven solutions that incorporate data loading efforts within Azure Synapse, creating data structures that are both serverless and traditional Azure SQL. The Integration Endpoint Developer will oversee the continued development of the Systems Integration API, ensuring the SI software development life cycle is followed. The selected individual will work on reporting and data visualization efforts for the agency. All work will be done ensuring that data integrity and security is implemented. Key ResponsibilitiesThe Integration Endpoint Developer will:

• Establish and maintain data driven pipelines for data hydration of SC DEW Azure Data Lakes.
• Utilize external and internal data sources for additional endpoint ingestion.
• Use IRS Pub 1075 and abide by state/agency requirements to ensure data is secured.
• Create a standards-based data repository for data ingestion.
• Update and ensure accuracy of DEW Worksheets.
• Oversee the development and maintenance of the Systems Integration API endpoints via C# code.
• Generate reports via SSRS and Power BI (both Pro and Desktop), ensure access policies are adhered.
• Follow the Systems Intelligence Development Life Cycle. Use Terraforming for Azure objects when available.
• Ensure data privacy and system security compliance for all operations are integrated into the IT department’s system integration.

If you’re ready to take on this challenge and help support South Carolina’s workforce system, please apply. We look forward to hearing from you! Education and Experience
A high school diploma and experience in computer system development and modification. A bachelor’s degree in a related area may substitute for the required work experience. Experience in SQL and Azure Synapse is required.
Additional RequirementsPosition requires overnight travel and may require employee to work evenings and weekends. Requires on-call shifts and call back. Other duties as required. Experience with Microsoft Power BI.
Supplemental questions are considered part of your official application. Please complete the State application to include all current and previous work history and education. A resume will not be accepted nor reviewed to determine if an applicant has met the qualifications for the position.

Salary:

Location: Richland County, SC

Date: Fri, 13 Jun 2025 07:58:54 GMT


Read More…