Position Summary Data Analysts are responsible for importing, transforming, and validating (or querying) data with the purpose of understanding or drawing conclusions from the data to drive decision-making. They may use modeling techniques to form data in ways that can be analyzed and/or queried to identify data quality issues, anomalies, or deviations. They generate ad hoc reports and regular datasets or report information for end-users using system tools, database or data warehouse queries, and scripts. They also integrate data from multiple sources to produce requested or required data elements. They work closely with business groups, IT verticals, and governance teams to provide information to drive data quality and usage decisions.
In this position, the Data Analysts are responsible for querying data sources to import and transform private and/or sensitive data requested by the legal department both internal and external. This includes generating ad hoc reports. They work closely with Legal, Human Resources and Payroll departments as well as the IT Data and Analytics teams.
Job Duties/Essential Functions- Analyzes data for quality and completeness in accordance with established data governance policy and standards.
- Build and maintain automated workflows using tools like Alteryx to create recurring reports for various business areas such as Legal, HR, Payroll and Accounting
- Creates data quality control processes to audit extracted lists ensuring data governance is maintained on all processes.
- Performs data profiling and business analysis (logical modeling) to determine the most effective ways to measure and provide data.
- Provides insights as to the best means to analyze and combine multiple data sources to form accurate and meaningful datasets.
- Defines and ensures adherence to new process improvement opportunities.
- Performs testing and validation of data and data sources.
- Performs data mapping and tracing from system to system in order to solve a given business or system problem.
- Supports initiatives for data integrity and normalization.
- Prepares documentation of relationships, integration, and flow of data.
- Identifies and resolves problems often anticipating issues before they occur or before they grow; develops and evaluates options and implements solutions.
- Ability to manage multiple requests and effectively prioritize.
- Ability to complete urgent requests in a timely manner while also maintaining data integrity and accuracy.
- Regular and reliable workplace attendance at your assigned location.
Ability to operate vehicles, equipment or machinery.- Computer, phone, printer, copier, fax
Non-Essential Functions- Assists in other areas of the department as necessary.
- Assists in other areas of the company as necessary.
Ability to operate vehicles, equipment or machinery.- Same as essential functions.
Experience, Skills, Education & Licenses/CertificationsRequired:- Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
- 2-4 years writing SQLs queries and presenting findings.
- Experience in extracting data from multiple sources, merging datasets, validating accuracy and delivering final outputs for analysis and reporting.
- Detail oriented and possess strong problem-solving skills, with the ability to analyze a situation for potential future problems.
- Strong technical documentation and writing skills.
- Strong communication skills and able to work effectively with all levels of the business and IT.
- Responsible, conscientious, and possess a passion for excellence.
- Self-motivated and able to work independently, with little supervision.
- Demonstrates an ability to grow technical skills and learn new technologies.
- Able to support off-hours work as required, including weekends, holidays, and 24/7 on call responsibilities on a rotational basis.
- Strong verbal communication skills.
Recommended: - Familiarity with any of the following:
- Alteryx
- Google BigQuery
- CARTs+ (ServiceNow)
- iSeries/AS400/RPG
- Experience working with sales,HR and payroll datasets
- Costco's core business environment related to Merchandising, Warehouse Operations, and company philosophies.
- Successful internal candidates will have spent one year or more on their current team.
- Proficient in Google Workspace applications, including Sheets, Docs, Slides, and Gmail.
Other Conditions- Management will review the Job Analysis for this position prior to a job offer.
Required Documents Cover Letter
Resume
Last two performance reviews
Attendance records for current year (Do not include absences covered by paid sick/personal time,
FMLA or other protected absences.)
California applicants, please click here to review the Costco Applicant Privacy Notice.