Senior ETL and Reports Developer Job at Expert Technology Services, Raleigh, NC

  • Expert Technology Services
  • Raleigh, NC

Job Description

Job Summary (List Format):




- Serve as a senior ETL and reports developer for the NC FAST program, focusing on FNS/SNAP reports using Oracle and PL/SQL technologies.
- Analyze and document business and systems requirements for reports and data extracts related to NC FAST Case Management System.
- Design, develop, maintain, and enhance ETL batch jobs, complex queries, reports, and dashboards.
- Interpret business requirements to create and modify data interfaces and reporting solutions of mid to high complexity.
- Ensure data quality and integrity through validation, auditing, and performance metrics analysis.
- Troubleshoot and resolve issues with existing reports, queries, and data extracts.
- Work with large data sets, including tables containing CLOBS/XML data.
- Develop and optimize effective SQL queries for large-scale data reporting.
- Collaborate with business users and stakeholders to gather requirements and deliver solutions.
- Utilize Oracle, Oracle Utilities, PL/SQL, and Business Intelligence tools (e.g., Business Objects, BIRT).
- Apply structured system development methodologies and Agile practices (Scrum, Kanban, SAFe).
- Lead, mentor, and provide guidance to team members as needed.
- Provide 24x7 on-call support/rotation for reporting and data extract operations.
- Leverage experience with Data Warehousing, Power BI, Azure Synapse, Amazon Redshift, Tableau, and/or Dell Boomi as needed.

Job Tags

Similar Jobs

StomCrafts

Independent Courier Driver - Flexible Routes & Weekly Pay Job at StomCrafts

Ameriship Parcel Delivery is hiring delivery drivers in Wheeling, IL, and surrounding areas. This independent contractor role requires you to use your own vehicle...  ...routes typically ending by early evening.Prior courier experience is preferred, but not required. Compensation... 

State of Texas, USA

Hearings Officer (Multiple Locations) Job at State of Texas, USA

DescriptionThe Texas Workforce Commission is looking for attorneys or law school graduates, to serve as Hearing Officers for unemployment hearings. While our Appeals Department is located in Austin, Texas, work can be performed from any city in Texas. Qualifying candidates... 

Vanguard

Compliance Specialist AML/CFT Program Oversight Job at Vanguard

 ...industry experience in Anti Money Laundering, Know Your Client, and Compliance Operations. In this crucial role, you'll be at the forefront of...  ...will play a critical role in Vanguards Anti-Money Laundering (AML) and Know Your Customer (KYC) programs. Youll be responsible... 

WaferWire Cloud Technologies

Lead Engineer, Software Systems Engineering Job at WaferWire Cloud Technologies

 ...Job Description Job Title: Lead Engineer, Software Systems Engineering \n Location: W Los Angeles, CA/ Tampa, FL \n Worksite: Onsite \n \n About WCT \n WCT is a global talent solutions partner committed to delivering high-impact technology and engineering... 

UFC Gym

UFC GYM Studio Fitness Mat Pilates Instructor Job at UFC Gym

 ...sound and lighting systems.Secure substitutes when necessary.Communicate member feedback or concerns to the Program Manager.Promote gym programs, services, and special events.Maintain a professional appearance and demeanor at all times.QualificationsStrong knowledge of...