Functional / Data Analyst

KEY DUTIES & RESPONSIBILITIES
Extract data from CSV files, Excel spreadsheets, SQL databases, and other data sources.
Load and transform data into a centralized SQL database for reporting and analysis purposes.
Work with stakeholders to perform regular data integrity checks to ensure accuracy and consistency of data across all systems.
Manual Data Manipulation & Reconciliation: Manually correlate settlement data provided for accurate case tracking. Confirm the integrity of data imported from data sources and address any discrepancies.
Data Validation & Accuracy: Perform data validation to ensure accuracy in all data points across various platforms. Reconcile differences in how data is calculated between marketing teams and internal reports. Identify and troubleshoot discrepancies in data calculation methodologies to ensure consistency.
Data Updates & Maintenance: Regularly update data sets where necessary to reflect changes in settlements, cases, and client records. Ensure that all data is maintained and updated in compliance with organizational data standards.
Data Analysis & Reporting: Provide insights on data inconsistencies Create reports and dashboards to present data insights to stakeholders in an easily understandable format.
Education / Qualifications Bachelor’s Degree (or equivalent experience) in a quantitative or business discipline
Working experience 5+ years IT experience 5+ years of data analysis experience in technology, applications, or operations 5+ years SQL experience 5+ years Excel experience Strong written and verbal communication (English) Strong interpersonal and networking skills Proficient with MS Office, including Outlook, Visio, PowerPoint, Word, and Excel
REQUIRED SKILLS
Proficiency in SQL and experience in working with relational databases. Advanced knowledge of Microsoft Excel, including formulas, pivot tables, and data cleaning techniques. Experience with ETL processes (Extract, Transform, Load) from Excel, CSV, and SQL databases. Strong analytical skills with an eye for data accuracy and consistency. Excellent problem-solving skills and the ability to identify and resolve data discrepancies. Strong communication skills to collaborate with stakeholders and ensure alignment in data calculations.
PREFERRED SKILLS
Experience working in legal or financial services, especially handling settlement data. Familiarity with marketing analytics and the ability to align marketing data with internal reports. Knowledge of data visualization tools like Power BI is a plus.
5+ years of data analysis experience in technology, applications, or operations

5+ years SQL experience

5+ years Excel experience including expertise in Pivot tables and other advanced features

3+ years' experience doing KPI and financial data analysis

Required Citizenship / Work Permit / Visa Status
US Citizen / Green Card
Job Types: Full-time, Contract
Pay: $124,560.00 - $166,080.00 per year
Benefits:

401(k)
401(k) matching
Dental insurance
Health insurance
Life insurance
Paid time off
Retirement plan
Tuition reimbursement
Vision insurance

Application Question(s):

Is the candidate a US Citizen or Green Card Holder ?
How many years of SQL Development experience does the candidate have ?
How many years of ETL Experience does the candidate have ?
Does the candidate have experience doing KPI and financial data analysis ?
How soon can the candidate join?
Are you ready to work on a contractual opportunity for 5months?

Work Location: Remote