Senior Business Intelligence Analyst

Culver City, CA
52 Limited is a digital staffing agency with an industry-leading focus on the creative + technology space. We exclusively place tech and creative talent in direct-hire, contract-to-hire, and contract roles with our clients in Portland, Seattle, and San Francisco.
Pay Rate: $55/HR
Duration: 12 months

RESPONSIBILITIES

* Collaborate with 7+ departments in Global Brand Imaging team to gather business requirements and build automated Tableau dashboards that fuel data-driven decision making
* Lead the extract, transform, and load (ETL) process in Redshift, Teradata, Box, and various excel sheets using SQL, Tableau Prep, and/or Alteryx.
* Maintain and enhance weekly, monthly, quarterly and yearly reports to key stakeholders
* Design Tableau dashboards that fit brand guidelines
* Manage Tableau Server and all working Tableau Server dashboards
* Optimize the speed and accuracy of data models and pipelines to ensure timely and correct information presented in real-time dashboards
* Address ad-hoc requests for reporting needs where appropriate
* Mentor and teach other users Tableau to streamline reporting and create real-time dashboards
* Design and manufacture Standard Operating Procedures (SOP) models in Lucid Chart to easily visualize how to do tasks or explain processes
* Utilize AirTable as a project management tool to seamlessly communicate my on-going projects and priorities to the Data Analytics manager and other stakeholders
* Develop effective forecast models based on inventory trends and demand patterns
* Propose and implement solutions to improve forecast accuracies
* Partner with key studio functional leads to provide strategic plans based on forecasts, and business nuances to provide improvement recommendations
* Assist in the development of a business plan to achieve operational goals
* Support business needs for performance statistics, capacity planning, and production data requirements
* Help build trust in the numbers by becoming an expert in data that supports value streams for Wholesale and Direct to Consumer
* Manage data from multiple data sources for planning tools, and reporting needs
* Develop strong working relationships with management and cross-functional teams
* Track and resolve reporting issues using a variety of tools
* Successfully manage multiple priorities against business goals
* Drive process improvement opportunities, develop metrics and best practices to measure success
* Create, upload and maintain Standard Operating Procedures (SOPs) on all relevant processes
* Other duties as assigned


REQUIRED QUALIFICATIONS

* 2+ years of experience as a business analyst and/or system analyst
* 2+ years SQL (Teradata, AWS - Redshift, Microsoft SQL Server) for complex querying, analysis, and performance optimization
* 2+ years in Data Visualization with Tableau Suite (Prep, Desktop, Server)
* 3+ years Microsoft Excel (VBA, pivot tables, sumifs, xlookups)
* Understand ERD diagrams
* Familiarity with data warehousing techniques and cloud services like Amazon Web Services and Microsoft Azure
* Familiarity with data science programming languages like R, SAS, and Python
* Proficient in Microsoft Word, PowerPoint, and Outlook
* Ability to translate complex data into digestible visualizations
* Big systems thinker that can take broad visions and concepts and develop structured plans, actions, and measurable metrics and then work with teams to help implement those plans.
* Ability to create reports and presentations for senior leadership
* Experience in Retail, Wholesale demand planning, and/or Supply Chain
* Exceptional analytical and problem-solving skills
* Self-motivated, results-oriented and well organized
* Demonstrated ability to complete quantitative and qualitative analysis and to run financial models
* Proven experience in effectively working with senior leadership
* Experience in taking a concept or idea working with cross-functional teams to bring it to life
* Strong cross-team collaboration
* Ability to pass a 7-year background check
* Ability to travel 15% of time
* Proficient in data acquisition and wrangling. Familiarity with ETL processes and relational databases.
* Able to successfully manage multiple priorities against business goals
* Ability to problem-solve in a fast-paced and dynamic environment
* Strong technical reporting and analytical skills with a demonstrated ability and willingness to learn new tools
* Undergraduate Degree required. Preferably in Business Administration, Information Systems, Marketing, Computer Science, Finance



or