Database Administrator & Data Analyst

We are seeking a detail-oriented and skilled Database Administrator & Data Analyst to join our team. The successful candidate will play a critical role in managing and analyzing data across multiple systems, ensuring accuracy, integrity, and usability. This position involves retrieving and reconciling data, preparing campaign datasets, generating insightful reports, and automating workflows to support business operations and decision-making.

Key Responsibilities:
- Write complex SQL queries to extract, validate, and reconcile customer, lead, sales, commission, and call-history data from various databases including Workforce, Atlas, and dialer systems.
- Prepare and optimize campaign upload files by applying eligibility criteria, exclusions, deduplication, phone-number normalization, and accurate field mapping to ensure campaign effectiveness.
- Evaluate datasets by reviewing historical usage and performance to recommend lead pools for campaigns, including refreshing, recycling, or holding data as appropriate.
- Maintain database integrity by investigating missing or conflicting records, optimizing queries, and collaborating with technical teams to manage database corrections, access controls, backups, and recovery processes.
- Analyze key metrics such as contact rates, conversion rates, lead utilization, and campaign or team performance to deliver actionable, data-driven insights and recommendations.
- Develop reusable Python scripts and automated workflows for routine data extraction, cleaning, reconciliation, and reporting tasks, ensuring all processes include documented validation checks for accuracy.

Required Qualifications:
- Strong proficiency in SQL and PostgreSQL, with additional experience in MySQL/MariaDB or Oracle considered an advantage.
- Skilled in Python programming, especially using pandas for data manipulation, reconciliation, and automation.
- Advanced knowledge of Excel and Power Query; experience with Power BI is preferred.
- Demonstrated ability to handle large datasets, manage inconsistent source files, resolve duplicate records, and perform cross-system data matching.
- Ideally, 1 to 2 years of relevant experience in data administration and analysis.
- Strong analytical and problem-solving skills, with the ability to work independently and maintain strict confidentiality of customer data.

Preferred Qualifications and Benefits:
- Experience working in environments such as call centers, BPOs, dialer systems, CRM platforms, or lead-management operations is highly desirable.
- Opportunity to contribute to process improvements and automation initiatives that enhance data quality and operational efficiency.

This role offers a chance to work in a dynamic setting where data accuracy and insightful analysis directly impact business success. Candidates who meet the qualifications are encouraged to apply through professional networking platforms.