About the job
Job Title: Data Specialist / Executive Assistant (SQL Specialist)
Location: Remote
Employment Type: Full-time
Working Hours: Monday – Friday, 10:30 AM – 6:30 PM EST
Job Overview:
Join our dynamic team as a Data Specialist / Executive Assistant with a strong command of SQL and other database tools. We are looking for an enthusiastic and meticulous individual who thrives on problem-solving and operates independently. In this role, you will analyze complex datasets, optimize workflows, and enhance our existing systems. Responsibilities include managing and transitioning intricate Excel datasets into SQL or other database platforms, alongside providing essential administrative support to the executive team. While extensive experience in every area is not mandatory, a solid technical foundation and a quick learning ability are essential.
Key Responsibilities:
- Design, manage, and enhance complex Excel datasets, facilitating potential migration to SQL or other database systems.
- Perform data analysis to uncover trends, inconsistencies, and opportunities for operational enhancement.
- Craft SQL queries for data extraction, manipulation, and organization for reporting and strategic decision-making.
- Ensure database integrity by maintaining accuracy, security, and efficiency.
- Support executives with administrative tasks, including schedule management, document organization, and communication facilitation.
- Assist in workflow automation to improve business processes through database-driven solutions.
- Collaborate with cross-functional teams to bolster data-driven initiatives.
- Employ project management tools like Asana for task coordination and progress tracking.
Qualifications & Skills:
Required:
- Strong proficiency in SQL (or similar database tools) for effective data management and analysis.
- Advanced Microsoft Excel skills, including formulas, pivot tables, and automation features.
- Exceptional analytical skills with the ability to interpret complex datasets efficiently.
- Independent worker with proficient problem-solving abilities.
- Excellent organizational and time management skills.
- Strong written and verbal communication skills.
Preferred / Beneficial:
- Experience with QuickBooks for financial data management.
- Familiarity with Power BI for data visualization and reporting.
