Randstad USA

Compensation

Full Description

job summary: This senior level position is responsible to prepare business specific analysis by using mathematical concepts and data modeling to identify trends, and prepare recommendations for business solutions. Also responsible for quality and quantity of sound decisions around business processes. The Data Analyst III is able to independently work with more than one business group and the top stakeholders in the business units location: Telecommute job type: Contract salary: $35.33 - 45.33 per hour work hours: 8am to 5pm education: Bachelors 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. 50% Analyze Results • 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. 30% Analysis and Reporting Needs • 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. 15% Department Liaison/Project Work • 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. 5% Coaching • Mentors lower level staff work assignments and training needed. • Has project ownership and distributes project components to other staff members. qualifications: Top must-have skills - 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. Nice to haves: - 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. Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status. At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility). This posting is open for thirty (30) days. It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.