We are seeking a detail-oriented and skilled Database Administrator & Data Analyst to join our team. The successful candidate will play a crucial role in managing and analyzing data across multiple systems to support business operations. Responsibilities include data retrieval, database management, campaign data preparation, reporting, and analytics, ensuring the accuracy, integrity, and usability of data. This role requires a strong technical background combined with analytical skills to provide actionable insights and improve data-driven decision-making.
Key Responsibilities:
- Write 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.
- Evaluate datasets by reviewing past usage and performance to recommend lead pools for campaigns, including refreshing, recycling, or holding data.
- Maintain data integrity by investigating missing or conflicting records, optimizing queries, and coordinating database corrections, access controls, backups, and recovery efforts with the technical team.
- Analyze contact rates, conversion rates, lead utilization, and campaign/team performance to deliver actionable, data-driven recommendations.
- Develop reusable Python scripts and automated workflows for recurring data extraction, cleaning, reconciliation, and reporting, ensuring all processes include documented validation checks.
Required Qualifications:
- Strong proficiency in SQL and PostgreSQL; experience with MySQL, MariaDB, or Oracle is advantageous.
- Skilled in Python, especially using pandas for data manipulation, reconciliation, and automation tasks.
- Advanced knowledge of Excel and Power Query; experience with Power BI is preferred.
- Experience working with large datasets, handling inconsistent source files, duplicate records, and cross-system data matching.
- Ideally, 1 to 2 years of relevant experience.
- Strong analytical and problem-solving abilities, with the capacity to work independently.
- Commitment to maintaining confidentiality of customer data.
Preferred Qualifications and Benefits:
- Experience in call center, BPO, dialer, CRM, or lead-management environments is highly preferred.
This role offers the opportunity to work in a dynamic environment where data accuracy and insightful analysis directly impact campaign success and operational efficiency. Candidates interested in contributing their expertise to a collaborative team are encouraged to apply through professional networking platforms.