What are the responsibilities and job description for the Technical Product Manager (Data and ETL) position at System Soft Technologies?
Job Qualifications and Responsibilities for Technical Product Manager (Data and ETL):
- Demonstrate expert-level proficiency in SQL and advanced analytics platforms such as Tableau, and work effectively with large data reports to ensure accuracy in identifying cost savings opportunities, optimizing expenditures, and detecting carrier invoice overcharges.
- Establish and optimize the process for preparing and auditing invoices, wireless plans, and wireless equipment purchases from all carriers, as well as budget variance and expense reports for the department; analyze reports for data integrity.
- Establish and optimize the process for reviewing Cost Benefit Analyses (CBAs) and ROI.
- Establish and optimize the process for analyzing vendor expenses and comparing them to contract funding.
- Establish and optimize the preparation of reports and analyses in areas such as Machine-to-Machine (M2M) accounts, forecasts, expense reports, and business forecasts.
Database Administration & Maintenance
- Manage the existing database: backups, restores, indexing, and performance tuning.
- Monitor database health, storage, query performance, and job schedules.
- Create, manage, and optimize ETL/ELT pipelines.
- Load data from files, APIs, vendor portals, Excel, and external systems.
- Write complex SQL queries (joins, window functions, CTEs, aggregation).
- Debug and optimize slow-running queries.
- Safely add and modify tables, columns, constraints, and relationships.
- Document database structures, ETL pipelines, major queries, and workflows.
- Deploy and manage databases on cloud platforms (Azure SQL, AWS RDS, etc.).
- 10 years of experience in Telecom Services & Expense Management.
- Experience with project-based financial management, telecom expense management, budgeting/forecasting, and/or auditing is a plus.