For the given job description <<At Lyft, our mission is to improve peoples lives with the worlds best transportation. To do this, we start with our own community by creating an open, inclusive, and diverse organization.
The Real Time Supply Management team at Lyft is responsible for managing our suite of real time driver earnings products, driving top business goals around financial metrics and marketplace performance. The team develops and improves algorithms to automate the management of our real time earnings products, develops new earnings products, and manages financial performance of these products to manage the growth of the business.
We are looking for an analyst to join the team that is responsible for working with cross-functional stakeholders to analyze and improve existing earnings products, financial levers leveraged in marketplace strategy. You will influence existing and future strategy with your data analysis, insights, and visualization to deliver strategic recommendations on experimentation and product improvements. Were looking for a data & process-driven individual who has extraordinary attention to detail and a track record of analytical problem-solving.
Responsibilities:
Support marketplace operations to provide world-class analysis, forecasting and reporting to stakeholders.Become an expert in marketplace trends and support weekly reporting structures for the Rideshare organization.Develop domain-specific subject matter expertise in our lever portfolio and support cross-functional initiatives to improve existing products and develop new ones.Analyze marketplace product & financial levers and provide cross-functional teams with actionable insights on improvements and problem areas.Operate within Rideshare decision-making frameworks with a critical lens, evaluating areas of improvement and business growth opportunities.Prepare regular business reviews for leadership, highlighting key areas of focus.Work with stakeholders and other teams to track, report, and reconcile budget allocation across marketplace programs.Analyze data, conduct research and synthesize feedback into plans, processes and playbooks.
Experience:
2-5 years of experience in a high growth environment in data andor financial analytics.Very strong attention to detail, experience developing processes to remove human error.Proficient in SQL and quantitative analysis, you can deep dive into large amounts of data, draw meaningful insights, dissect business issues and draw actionable conclusions.Outcome-driven approach to developing recommendations and demonstrated ability to develop a story and execution plan to support our goals and objectives.Exceptional communication (listening, written, and oral) skills with the ability to present findings and recommendations targeted to the audience in question.A drive to understand the core issues along with the determination to uncover the solution.Excels at dealing with ambiguity and change management.
Benefits:
Great medical, dental, and vision insurance optionsMental health benefitsFamily building benefitsIn addition to 12 observed holidays, salaried team members have unlimited paid time off, hourly team members have 15 days paid time off401(k) plan to help save for your future18 weeks of paid parental leave. Biological, adoptive, and foster parents are all eligiblePre-tax commuter benefitsLyft Pink - Lyft team members get an exclusive opportunity to test new benefits of our Ridership Program
Lyft is an equal opportunityaffirmative action employer committed to an inclusive and diverse workplace. All qualified applicants will receive consideration for employment without regards to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status or any other basis prohibited by law. We also consider qualified applicants with criminal histories consistent with applicable federal, state and local law. 
Starting in September 2023, this role will be in-office on a hybrid schedule  Team Members will be expected to work in the office 3 days per week on Mondays, Thursdays and a team-specific third day. Additionally, hybrid roles have the flexibility to work from anywhere for up to 4 weeks per year.
The expected range of pay for this position in the San Francisco area is $128,000 - $142,000. Salary ranges are dependent on a variety of factors, including qualifications, experience and geographic location. Range is not inclusive of potential equity offering, bonus or benefits. Your recruiter can share more information about the salary range specific to your working location and other factors during the hiring process.>> the resume: <<SummaryExperienced Tableau Engineer with critical analytical& statistical knowledge in developing Tableau Dash Boards, Performance Tune and prepare insightful Tableau reports. Built and published customized interactive reports, dashboards, and report scheduling. In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server. Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage. Performed data audits, data profiling activities, providing strategic data to BI teams. Familiar with Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment. Working knowledge in Windows Servers, API, Network technologies with Active Directory, SAML for authentication. Strong knowledge in SQL, PL/SQL, XML, Python programming and understanding of Data modeling (Dimensional & Relational) concepts Experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint. Involved in Trouble Shooting, Performance tuning of reports, tuning long running SQL and PL/SQL queries for better performance and resolving issues. Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports. Involved in upgrading Tableau platforms in clustered environment and performing content upgrades. Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions. Expertise with data architecture, data interoperability and data analytics using Tableau and SQLs Experience in different project methodologies - Waterfall, and Agile/SCRUM Self-starter with ability to motivate teamwork and lead competently in diverse groups. Decision making ability to make sound Engineering, Management judgment. Innate problem solver, able to intellectually articulate business problems, identify critical problems, and achieve targeted results Worked closely with ETL developers and stakeholders to assist them with their agile development life cycle. Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling. Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch. Very proficient in working with large Databases in DB2, Oracle, Teradata and SQL Server. Experience in data modeling with high proficiency in using Erwin for Dimensional Modeling (Star and Snowflake schemas). Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using. Experience in data modeling with high proficiency in using Erwin for Dimensional Modeling (Star and Snowflake schemas). Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT and dimensions tables, physical and logical data modeling.
HighlightsBI Tools				: TableauETL Tools          : Informatica, Data Stage, Microsoft SQL Server Integrated ServicesRequirements Management      	: Requisite Pro, Microsoft Office (Word, PowerPoint   Excel)Change Management          : HP Open View, CA Service Manager, Lotus Notesamp; Service ManagementFront End Tools          : Microsoft Project, Microsoft Office, Visible AnalystDatabases          : Oracle 9i, SQL Server, DB2, Sybase, Teradata, MS AccessetcDocument management          : Visual Source Safe 6.0, Share point, Ultra Edit, DocumentumDefect management tool          : HP Quality center 10.0Programming Languages          : C, C++, HTML, SQL, PL/SQL, XML, Python, C#Data modeling          : ERwin, ER Studio, MS Visio Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.Prepared several analytical reports comprised of different data modeling techniques such as time series analysis, financial modeling, and trend mapping and supported in MATLAB programmingCollecting data, text standardization and performing text mining using different python libraries to create clusters and classify to compare the results and improve search of the platformEnvironments: SQL/PL-SQL, ETL, Oracle, Windows Server, VMware, Active Directory, Virtualization, Linux, Systems Engineering, Servers, Cisco Systems Products, Microsoft Exchange, MS Office Suite, MS Visio, HTML, MS Access, MS SQL, JavaScript, HTML/HTML5, CSS3, DOM, XHTML, AJAX and jQuery, Bootstrap, AngularJS, SQL Server, SSIS 2008, SSRS 2008, DB2, T-SQL, Oracle and SSMS, Asp.Net, C#, J-Query, MATLAB, Cognos 8.4,10.1 connection MS Office Suite, MS Visio, HTML, UML, C++, Java, MS Visual Basic, VB Script, Test Director, Client Server, Windows XP, MS Access, MS SQL, .NET, Agile, SOA
Experience01/1toPresentTableau Developer /Data AnalystAlteryx Inc.|,OR,Develop various Tableau dashboards and analytical reports and solutions for marketing efforts on medical products and business groups, using Calculations, Filters, Parameters and complex statistical analytics features of Tableau.Work on technical strategy, provided hardware and software configuration, understood client-wide BI implementation project, design and develop visualizations as per requested by CEO and CFO Adjust views/dashboards after initial POC presentation to CEO and CFO.Create views and dashboards on end client's sales data.Produce powerful dashboards using pie, bar, geo, and line charts that are viewed daily by CEO and CFO.Developed and modified database procedures, functions, packages to enhance and improve functionality using PL/SQL.Design and development of Tableau software applications to support reporting and Business Intelligence initiatives, using data analytics, visualization, reporting using OLAP (Online Analytical Processing), data mining, SQL, UNIX, Linux, and Java portal technologies; Perform Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump.Design and develop workbooks, global filter page, and complex parameters based calculations.Create action filters, parameters and calculate sets for preparing dashboards and worksheets in Tableau Access and transform massive campaign datasets through filtering, grouping, aggregation, and statistical calculation.Develop Tableau workbooks from multiple data sources using Data Blending.Work with team of developers to design and develop BI solutions on various marketing and campaign KPIs.Responsible for the design and development of data warehouse, analytics and visualization to meet the big data needs of various products and businesses.Design and deploy rich Graphic visualizations with drill down, and drop down and parameters from ERP databases and complex Dashboard and Storyboard Attributes, Hierarchies, Transformations, Filters, Prompts, Calculated fields, Sets, Groups.Created, organized and formatted reports, folders and other contents on Cognos Connection portal.Involved in migration of Cognos adhoc reports to Tableau workbooks.Converted business requirements into technical specification and design for Reporting Database/data mart, and Adhoc/standard reporting using Cognos 8BI.Perform query search via SQL knowledge and understanding of Data modeling (Dimensional & Relational) concepts Design different front-end forms & dynamic pages using CSS, HTML & given functionality with JavaScript, HTML5, CSS, JavaScript, JQuery, Angular.js Environments: Tableau Server, Tableau Desktop, Agile/Linux, HTML5, CSS, JavaScript, JQuery, Angular.js, Java Portal, PL/SQL, Windows Server, Oracle 10g/9i, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA SCRIPT, J2EE,PL/SQL, Tomcat, MS Visio, MS SQL, Teradata, IBM Cognos 8.4,10.1 connection.01/1to01/1Sr. BI Consultant/ Tableau DeveloperGalaxy Solutions|,CT,Created and assisted users in Tableau dashboard development.Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters, Trend Lines, Statistics, and Log Axes.Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.Developed and designed User Interface using JavaScript, HTML/HTML5, CSS3, HTML5, jQuery, SASS, and AngularJS Performed relational database design and normalization, client-server development, OLAP analysis using pivot charts Migrated Cognos dashboards to Tableau showing Year over Year comparison of different key metrics, Premiums Vs Losses, IBNR etc.Developed Cognos Reports in compliance with user reporting standards Created Tableau extract files for improving the performance.Implemented various Validation Controls for form validation and implemented custom validation controls with JavaScript validation controls.Wrote DDL or DML SQL commands, visualizations in Tableau, to improve data quality, analyzed complex data systems and document data elements, data flow, relationships and dependencies describing what/how/where/why data is stored and how to access the data.Created SSIS packages using C# scripting, script components and script tasks for various Control Flow Tasks and Data flow.Worked with DBAs in order to schedule SSIS packages as jobs either daily, weekly, monthly.Wrote complex PL/SQL queries and designed SSIS packages to load the data into warehouse.Use various SSIS transformations such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.Created the test environment for Staging area, loading the Staging area with data from multiple sources.01/1to01/1Business Intelligence Analyst|City,STATE,Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.Prepared Tableau dashboards using advanced features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.Created detailed technical design documents.Created Data Model for interface.Performed Logical and Physical data modeling within Tableau Server Experienced in Tableau Server Infrastructure: Installation & configuration of Tableau Server in clustered environment and REST API implementation.Involved in the production support and enhancement of the Sharepoint databases.Redesigned standards and procedures and bills of material tables.Created data maps using Informatica Power Exchange 5.1.2.Extensively used lookup, Expression, Aggregator, Normalizer transformation Performed Informatica code reviews.Created ETL design for real time data processing.Designed and implemented Informatica maps, workflows, schedules and scripts.Implemented mapping level data auditing and error handling, source to target mapping.Performed performance tuning of Informatica mappings and databases Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.Wrote stored procedures/Triggers/Views in SQL server and Oracle Developed implementation plans for the SAP modules PP and PP-PI.Implemented Material Variant, Object dependencies, Variant Table, Functions, Variant Pricing, Order BOM and also managed implementation of PP and PP-PI design on SAP 4.7C release Experience in designing Business View Manager, Business Objects universes, complex Crystal and BO reports both Full and Thin Client Reports.Developed reports using Business Objects Web Intelligence to cater Ad-hoc reporting needs.Created reports using Business Objects functionalities like Queries, Drill Down, Cross Tab, Master Detail and Formulae's.Used SQL Server Integrations Services (SSIS) to extract data (ETL), and quickly load data into SQL Server table, and handle data quality issues.Used SQL Server Reporting Services (SSRS) - Reporting Services Components and Business Intelligence Development Studio (BIDS) in order to design and develop reports.Worked in Windows Servers, API, Network technologies with Active Directory, SAML for authentication Environments: SAP BW/BO, SAP Business Objects XI R2 SP2,XIR 3.1 SP3, Designer, Infoview, Web Intelligence, Data Stage 8.1,Sql, PL/SQL, SQL server 2008, Xcelsius 2008,Live Office, Oracle 10g, Windows Server 2003,Clear Case,Clear Quest.MS Excel, MS SQL Server 2008/12 R2, Win Server 2008 R2, Active Directory, Oracle, Windows Server, VMware, Virtualization, Linux, Systems Engineering, Servers, Cisco Systems Products, VMware ESX, Microsoft Exchange, MS Office Suite, MS Visio, HTML, MS Access, JavaScript, HTML/HTML5, CSS3, DOM, XHTML, AJAX and jQuery, Bootstrap, SASS, AngularJS.08/2016to11/2016Business AnalystNA|City,STATE,Worked as a Data Analyst/ Business System Analyst and assisted the project manager in defining the Scope, Best Practices, Schedule, Business Change Management, and Develop Feasibility Study Report for Preliminary Study of the Project and Budget of the Project.Assisted the team members with documentations like Business Requirement Document and Use Case Specification Document by using DOORs, and Best Practice initiatives.Assisted in Data Analysis by Data Mapping then worked with the design team in the designing of the Databases with extensive use of ERDs for Data Validation, Data Modeling, Data Migration, Reference Data Analysis, and Data Conversion.Designed and developed Use Case Diagrams, Activity Diagrams and Sequence Diagrams by using MS Visio.Created a Decision Support System via Dimensional Modeling by ensuring appropriate FACTS tables, DIMENSIONS tables, attributes, and entities in order to generate MEASURES as required in Data Warehousing (EDW) and Data Migration by business users.Resource monitoring and repository Audit reporting.Worked on Backup and restoration.
EducationExpected intotoBachelor of Science|Chemical EngineeringOklahoma State University,Stillwater,OklahomaGPA:Chemical Engineering
Skills.NET, Asp.Net, Active Directory, Ad, Agile, AJAX, Analyst, API, Audit reporting, auditing, Backup, basic, big data, Budget, BI, Business Intelligence, Business Objects, C, C++, Change Management, charts, Cisco, Client Server, client-server, CMS, Cognos 8.4, Cognos, CA, hardware, content, Crystal, CSS, CSS3, Client, Data Analyst, Data Analysis, Data Conversion, data processing, Data Migration, data mining, Data Modeling, Data Validation, data warehouse, Databases, Database, Data Stage 8.1, Data Warehousing, Decision Support, designing, DIMENSIONS, DML, Document management, Documentum, DOM, DOORs, Edit, ERP, ERwin, ETL, XML, Feasibility Study, features, financial modeling, forms, Graphic, HP, Open View, HTML, HTML5, IBM, DB2, Informatica, J2EE, Java, JavaScript, JAVA SCRIPT, JQuery, J-Query, Linux, Lotus Notes, marketing, MATLAB, Access, MS Access, C#, MS Excel, Excel, Exchange 5.1.2, Microsoft Exchange, Microsoft Office, MS Office Suite, Office, PowerPoint, PP, Microsoft Project, Sharepoint, Share point, Win, Windows, 3.1, Windows XP, Word, migration, Modeling, Network, OLAP, Oracle 9, Oracle, PL-SQL, PL/SQL, page, Pricing, Programming, Python, Quality, Quest, real time, relational database design, reporting, Requirement, sales, SAP BW, SAP, SAP 4.7, Servers, scripting, scripts, script, Visual Source Safe 6.0, Specification, Sql, MS SQL Server, MS SQL, Microsoft SQL Server, SQL Server, Statistics, strategy, Sybase, System Analyst, Systems Engineering, Tableau, tables, Teradata, Test Director, Tomcat, T-SQL, Trend, UML, UNIX, upgrades, upgrading, User Interface, Validation, VB Script, View, Visio, MS Visual Basic, Web Intelligence, Windows Server, XHTML>>. The result is, No Fit

Fit assessment: No Fit