SQL Data Engineer & Analytics for Capacity Reporting

Techiva Inc; Mount Laurel Township (NJ); On-site; USD 70,000 - 90,000; Full time

Job summary

Techiva Inc is seeking a candidate for a 6-month contract position focused on data management and reporting in Mount Laurel Township, New Jersey. Ideal candidates will have strong SQL expertise and experience with ETL processes, alongside scripting skills in Perl or Python.

The role involves creating utilization reports, managing an SQL database for Video capacity data, and ensuring best practices in data management.

Qualifications

• Strong SQL expertise for database management and reporting.
• Experience with ETL processes for data transformation and loading.
• Familiarity with various monitoring and reporting tools.
• Proficient in scripting languages, preferably Perl and Python.
• Excellent communication skills for cross-group collaboration.
• Experience in data mining and formatting.
• Any development background, particularly in DB development, is a plus.

Responsibilities

• Create Weekly/Monthly utilization reports for management.
• Warehouse and maintain Video capacity data in an SQL database.
• Support creation of ad hoc capacity reports for executives.
• Automate data collection using scripting languages.
• Manage and scale weekly and monthly SQL data.
• Ensure data management aligns with Capacity Planning best practices.

Skills

SQL expertise

ETL skills

Monitoring & Reporting tools

Scripting experience (Perl, Python)

Excellent Communication Skills

Data mining

Development background (DB development)

Job description

Techiva Inc is seeking a candidate for a 6-month contract position focused on data management and reporting in Mount Laurel Township, New Jersey. Ideal candidates will have strong SQL expertise and experience with ETL processes, alongside scripting skills in Perl or Python.

The role involves creating utilization reports, managing an SQL database for Video capacity data, and ensuring best practices in data management.