SQL Database Analyst (Report Writer)

NeoHire South - Santa Monica, CA

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.

Responsibilities:

? 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

 

Qualifications:

? 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

 

Bonus:

? 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.

 

Location: 

This job is located in Santa Monica, CA. Local candidates preferred.



Posted On: Wednesday, April 19, 2017



Apply to this job
or