*about the job senior mysql developer*
we are looking for a *mysql developer* to be responsible for creating configurations in our client's proprietary statement processing tool, which utilizes multiple sequential queries for ingesting, validating, and processing sales and other data from their partners (music stores / streaming sites / etc.).
the primary focus for this role will be on the *creation and maintenance of configurations* for one of our client's business lines, requiring close collaboration with our client's team in *london*, as well as our client's internal teams based in *new york* and *los angeles*.
this person will be responsible for figuring out how to get the mix of data that the partners send in text / xlsx / pdf formats into a usable csv that can be imported into the statement db, creating the documentation for replicating those steps, then writing all of the queries needed to load, validate and maneuver the data into a clean, normalized table format.
from there, standardized code does the rest of the work of fx conversion, matching reported data to the (tracks / releases) or (sound recording / contributor / contribution) tables, and showing the processors any unmatched rejects.
*responsibilities*:
- create new configurations for partners that our client has deals with.
- write detailed documentation for all prep workflows for each new configuration, so that the statement processing team can easily replicate the steps required.
- maintain and make required updates to existing configurations when partners make changes to report formats, or as in-house fixes and improvements are requested.
- daily communication with teams in london and la to ensure configurations are programmed correctly, taking into account all of the specific rules governing the reporting and allocation of the revenue.
*experience and skills required*:
- creative thinking, logical problem-solving, organizational skills, and attention to detail are all essential.
- extensive experience writing complex mysql queries.
- experience with very large data sets.
- high proficiency with excel.
- good knowledge of basic accounting principles, including vat, wht, and foreign currency exchange rates.
- excellent communication skills across multiple teams in multiple time zones.
- etl proficiency (working with various file encodings / line endings, familiarity with various data extraction tools such as able2extract).
- music business knowledge (desirable), familiarity with data web apps like looker and snowflake, are big pluses.
training will likely be virtual.
est timezone is preferred due to the need to split time between the processing team in london and la.
tipo de puesto: tiempo completo
salario: $1.00 - $10.00 al mes
pregunta(s) de postulación:
- país de residencia
idioma:
- inglés (obligatorio)