Data Analyst

adidas Portland, OR

About the Job

Purpose The Finance Data Analyst collects, analyzes, structures and stores various types of company data using a wide range of methods and develops solutions for storing it. Conducts quantitative analysis and takes responsibility for the integrity of data and data processes. Manages data and data flows along all aspects of adidas’ Business Intelligence technology stack, using software tools like SQL (MS SQL Server), Alteryx, MicroStrategy and Tableau. Key Accountabilities Data Analytics Responsible for extracting, curating, transforming, and storing Finance data and making it available to cross-functional teams Works with other departments like Marketing Finance, Finance Planning & Analysis and other Finance functions in mining and analyzing financial and transactional data Supports data automation of daily tasks to save end users’ (reporting analysts) time Monitors data processing jobs an ensure they meet SLAs Supports Senior Data Analyst on issue fixing and keep systems running Knowledge, Skills and Abilities Excellent analytical and numerical skills Experienced in dealing with databases (understanding tables and views and adjusting/writing SQL queries) Experience working with statistical software (e.g. R and Python), database languages/tools (e.g. SQL, SAP HANA, Exasol) and data visualization software (e.g. MicroStrategy, Tableau, Power BI) Experience with OLAP tools (e.g. TM1) Advanced MS Excel skills (macros and complex formulas) Ability to simplify and communicate complex data to different types of audience Experience in MicroStrategy, Tableau, or Power BI Process automation and Machine Learning exposure is a plus Minimum Qualifications BS degree in a quantitative discipline, or equivalent practical experience 2 years of relevant work experience in data analysis or related field Experience designing relational databases, including ETL design, schema design and dimensional data modeling Fluent in English