SQL DATABASE ANALYST / REPORT WRITER
We are looking for an experienced SQL Database Analyst / Report Writer to lead up data mining, analysis, and visualization efforts for the company. To be successful in this role a candidate needs to have exceptional skills in SQL query development & optimization (using MySQL and PostgreSQL/Redshift), a strong understanding of data analysis (particularly as it applies to financial data), knowledge of data import/integration/export methods, and expertise in data visualization tools like Periscope. The candidate would also be expected to operate as a subject matter expert in MySQL and work in collaboration with other members of the engineering team to support development, debugging, and optimization of database queries for our core services.
? Take ownership for creating, updating, and maintaining existing reports and dashboards for the company.
? Extract, analyze, and deliver ad hoc reports and other information as needed to support decision-makers.
? Conduct audits of database consistent with established database management principles, and make recommendations regarding data collection, warehousing, management, and retrieval procedures.
? Optimize and/or debug SQL queries as needed to maximize performance, scaling capability, and accuracy
? Assimilate new technologies and solve complex problems, formulating and evaluating technical alternatives based on experience and data-driven decision making skills
? Generate and update documentation and provide support for training others in use of reporting systems
? Provide query writing support and troubleshooting assistance within engineering organization
? Participate in SQL code reviews with other engineers as needed
? Participate in Agile planning, scope estimation, and updates for team projects
? Engineering talent proven by great work experience, hobby projects, open source contributions, and/or superior academic results
? 8+ years of professional experience in software development with a strong command of computer science fundamentals
? 5+ years of experience in SQL (MySQL) programming, query optimization, views, stored procedures, ETL’s, etc.
? 3+ years of experience in data extraction, analysis, and report development. Experience creating dashboards and reports using standard visualization tools. Experience working with Periscope and Redshift a plus.
? Significant experience with complex data structures, diverse schemas, and tables with multiple foreign keys
? Experience contributing as a member of an Agile software development team
? Strong English-language communication (verbal and written) and documentation skills
? Ability to work in a collaborative, technically challenging environment with rapidly changing requirements
? A scrappy, entrepreneurial attitude that gets high-quality projects done quickly
? You have a degree in computer science, software engineering, database management, or similar. MBA a plus.
? You have significant experience in software architecture and large-scale web services design
? You have DBA experience, particularly with performance tuning and scaling of database services (sharding, etc.)
? You have experience with NoSQL & MapReduce (MongoDB, CouchDB, Hadoop, etc.) and know where to use them in place of standard SQL database technologies.
? You are a passionate PC gamer. CS:GO experience and a familiarity with skins trading is a plus.
This job is located in Santa Monica, CA. Local candidates preferred.