Randstad Digital Americas ยท 16 hours ago
Data Analyst III
Randstad Digital Americas is seeking a Data Analyst III responsible for preparing business-specific analysis using mathematical concepts and data modeling to identify trends and prepare recommendations for business solutions. The role involves collaborating with various business groups, conducting data analysis, and ensuring the quality and accuracy of reports.
Information Technology & Services
Responsibilities
Collaborate with Senior Analysts who will help organize and prioritize tasks
Participate in onboarding sessions to understand project scope and expectations
Receive training on data sources, including fundamentals and differences between old and new systems
Understand Progressive's data structure and reporting standards
Review existing reports from the legacy system
Interpret how each report is built (logic, calculations, data relationships)
Write code to recreate the same data in the new data source
Rebuild reports in Power BI based on provided specifications
Ensure reports meet Progressive's design and functionality standards
Perform QA checks and validations to confirm accuracy and completeness
Conduct multiple rounds of testing (including QQA) before finalizing
Complete one report at a time, then move to the next
Approximately 100 reports will need to be migrated
Start with slower pace during learning phase; timing expectations will adjust as proficiency increases
Some reports may take longer due to complexity; others may be completed quickly
Summarizes and presents analysis findings and discusses recommendations for next steps
Builds on present analysis to build future analysis
Explains analysis by discussing analysis approach and summary of findings
Gains commitment to action and ensures implementation of recommended actions
Uses judgment to recommend workable alternatives to stakeholders
Develops and modifies programs when more complex analysis in required
Works with business partners to analyze needs for information and converts them into action items, requests or projects
Gathers requirements and develops specifications for business analysis needs
Retrieves data from various sources and prepares data for analysis
Verifies accuracy of data pulled and revises methods of data retrieval
Develops complex queries against data sources
Develops spreadsheets and tools for management use
Compiles and prepares reports, graphs and charts of data developed
Prepares forecasts, identifies and analyzes trends
Recommends process improvements and/or goal changes
Serves as expert on multiple data sources
Participates in the formation of business plans and forecasts and provides answers to questions about business data to appropriate business units
Supports business area projects by applying general knowledge of the business area processes including best practices
Works on projects beyond the scope of their own business area
May provide data and respond to questions to external groups/agencies/vendors
Mentors lower level staff work assignments and training needed
Has project ownership and distributes project components to other staff members
Qualification
Required
SQL coding language
SAS coding language
Power BI (and DAX coding)
Intermediate computer skills including MS Office (Teams, Outlook and Excel skills with knowledge of spreadsheet functionality including v-look-up, pivot tables, charts, graphing and macros.)
Bachelors
Preferred
Experience using STAR schema databases
Snowflake coding and experience
Bachelor's degree with an emphasis in Finance, Mathematics, Accounting, Economics or Statistics
Five years business experience with two years prior analysis experience
Master's degree in lieu of experience
Benefits
Medical
Prescription
Dental
Vision
AD&D
Life insurance offerings
Short-term disability
401K plan
Company
Randstad Digital Americas
Randstad Digital is a trusted digital enablement partner that facilitates accelerated transformation for businesses by providing global talent, capacity, and solutions across specialized domains.