Senior Data Solutions Engineer — ETL & BI

WorkScoop; Many (LA); On-site; USD 85,000 - 110,000; Full time

Benefits offered by this job

Health benefits package

Retirement benefits

Paid leave programs

Job summary

WorkScoop is seeking an IT Specialist (APPSW) Data Solutions Developer to lead MI/BI data environments and develop ETL pipelines. The role covers building scalable data architectures, scripting across SQL ecosystems, and delivering WebFOCUS reporting solutions.

The candidate will communicate BI concepts to diverse audiences and mentor team members, ensuring robust MI/BI solutions and data governance across platforms.

Qualifications

• Specialized experience at the GS‑12 level (or equivalent) in or related to the position.
• Proficiency in SQL-based technologies (SQL, PL/pgSQL, PostgreSQL, SQL Server, DB2, Oracle).
• Experience with Ab Initio, Linux shell scripting, Crontab, and mainframe JCL.
• Knowledge of ETL processes and data modeling.

Responsibilities

• Design, develop, test, and support MI and BI applications and data environments.
• Build and maintain complex ETL pipelines and database architectures.
• Develop and manage scripts using SQL, PL/pgSQL, PostgreSQL, SQL Server, DB2, Oracle, Ab Initio, Linux shell scripting, Crontab, and mainframe JCL.
• Implement and maintain WebFOCUS reporting solutions.
• Communicate BI concepts to technical and non‑technical audiences.
• Provide technical guidance and mentorship to other team members.

Skills

MI/BI development

SQL-based technologies

ETL knowledge

Data modeling

Tools

Ab Initio

Linux shell scripting

Crontab

Mainframe JCL

Job description

WorkScoop is seeking an IT Specialist (APPSW) Data Solutions Developer to lead MI/BI data environments and develop ETL pipelines. The role covers building scalable data architectures, scripting across SQL ecosystems, and delivering WebFOCUS reporting solutions.

The candidate will communicate BI concepts to diverse audiences and mentor team members, ensuring robust MI/BI solutions and data governance across platforms.