Senior ETL and Reports Developer

Expert Technology Services
Raleigh, NC, United States
21 days ago
Apply on www.careerjet.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
10 years minimum
Working hours
Regular working hours

Tech stack

Agile Methodology Amazon Web Services Big Data Extract Transform Load (ETL) Data Mining Data Warehousing Oracle (Applications) Scrum Methodology Power BI Salesforce.Com Software Engineering PL-SQL
+7 more
SQL Databases Tableau (Software) Extensible Markup Language (XML) Sap Business Objects Azure Synapse Analytics BIRT Reporting Amazon Redshift

Job description

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 Summary NCDHHS Senior Salesforce Developer - Lead the design, architecture, and implementation of secure, scalable, and user-centric Salesforce solutions for the NC DHHS Earl…
  • 16 hours ago
  • Apply easily

Requirements

DHHS-ITD is looking to hire a senior AWS developer with 10-15 years of software development experience. This role involves close collaboration with the data modernization teams at …

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerjet.com
Prepare application

Good distractions

Loading talks and stories from around this role…