Data Analyst - Senior
Spectraforce
US
Remote
a day ago
Job Description
Title: Data Analyst - Senior
Duration: 10 Months
Location: Remote
Data Quality Checking and Documentation:
• Must be very comfortable and proficient with Excel:
o Extensive experience working with extremely large Excel files:
o Expertise with Excel data lookups, tables, and complex, nested formulas.
• Quality assurance for data and format-intensive client reports and dashboards.
• Compare data, charts, and formatting of report pages and dashboards with source documents, ensure data matches and there are no errors. Source documents include business requirements documents, spreadsheets, prior year's reports, and mockups.
• Locate, document, and clearly report errors.
• Manage the QA process with the vendor. Experience with Jira a plus.
• Lead and document processes, collaborate with team members to identify and research issues, share updates, and gain a consensus on next steps.
• Review and update business requirements documents.
• Maintain logs of activities and completed work.
Help manage the benchmarking mailbox.
• Study internal documents to learn how best to respond to emails and leverage templated responses.
• Research questions from internal partners and clients, identify solutions, and respond within 1 or 2 days.
• Provide courteous, professional, clearly written emails and help resolve the question/issue quickly.
• Reach out to team members as needed for input on how to respond.
Support data validation.
• Help validate calculations executed by data analytics team are accurate.
• Identify processes to validate calculations and where more validation might be needed.
• Run Excel reports and data comparisons, for example comparing data in multiple files.
• Leverage Excel to manually calculate results as part of data validation.
• Validate results of daily participation report and post file internally for benchmarking partners.
• Maintain and update control files based on updated business requirements
Additional Requirements:
• Fast learner who can get up to speed quickly.
• Incredibly strong attention to detail and an eye for accuracy a must.
• Critical thinker who can prioritize tasks and identify when urgency is needed.
• Looking for a team player with strong written and spoken communication skills who thrives in a collaborative group.
• Must be comfortable in a fast-paced environment with hard deadlines.
• Able to take the initiative to resolve issues and find solutions.
• May also support the team in other ways to execute the RIA Benchmarking Study.
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $60.00/hr.
Duration: 10 Months
Location: Remote
Data Quality Checking and Documentation:
• Must be very comfortable and proficient with Excel:
o Extensive experience working with extremely large Excel files:
o Expertise with Excel data lookups, tables, and complex, nested formulas.
• Quality assurance for data and format-intensive client reports and dashboards.
• Compare data, charts, and formatting of report pages and dashboards with source documents, ensure data matches and there are no errors. Source documents include business requirements documents, spreadsheets, prior year's reports, and mockups.
• Locate, document, and clearly report errors.
• Manage the QA process with the vendor. Experience with Jira a plus.
• Lead and document processes, collaborate with team members to identify and research issues, share updates, and gain a consensus on next steps.
• Review and update business requirements documents.
• Maintain logs of activities and completed work.
Help manage the benchmarking mailbox.
• Study internal documents to learn how best to respond to emails and leverage templated responses.
• Research questions from internal partners and clients, identify solutions, and respond within 1 or 2 days.
• Provide courteous, professional, clearly written emails and help resolve the question/issue quickly.
• Reach out to team members as needed for input on how to respond.
Support data validation.
• Help validate calculations executed by data analytics team are accurate.
• Identify processes to validate calculations and where more validation might be needed.
• Run Excel reports and data comparisons, for example comparing data in multiple files.
• Leverage Excel to manually calculate results as part of data validation.
• Validate results of daily participation report and post file internally for benchmarking partners.
• Maintain and update control files based on updated business requirements
Additional Requirements:
• Fast learner who can get up to speed quickly.
• Incredibly strong attention to detail and an eye for accuracy a must.
• Critical thinker who can prioritize tasks and identify when urgency is needed.
• Looking for a team player with strong written and spoken communication skills who thrives in a collaborative group.
• Must be comfortable in a fast-paced environment with hard deadlines.
• Able to take the initiative to resolve issues and find solutions.
• May also support the team in other ways to execute the RIA Benchmarking Study.
Applicant Notices & Disclaimers
- For information on benefits, equal opportunity employment, and location-specific applicant notices, click here
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $60.00/hr.