Job details
Salary $100 - $120 an hour job type full-time
Full job description
Job type: freelance, contract position - no agencies (see notes below)
Location: remoteOpen to global, but would need significant pst coverage
Hourly range: our client is looking to pay $100 - $120 usd / hr
Estimated duration: 40hrs/week - long term, 6-month project
High-level qualifications:
About us:
Braintrust (usebraintrust.com) is a user-controlled talent network, where you keep 100% of what you earn and actually get to own the platformWe`ve been onboarding some big clients and specifically need a senior data architect for our client.
Our client is a fintech startup with some big ideas about how to change the marketing and sales of a $725 billion/ year industryWe believe that everyone deserves a financial safety net and are on a mission to help every person build one.
The project:
You will design an operational data store in google bigquery which will aggregate our current 165 tables across 31 databases using a fairly direct replication approach.
Develop etl pipelines using matillion or a similar tool to keep the reporting database current
Build a few views to support a bi tools such as looker
Port a dozen reports currently executed against production to the new system
Create four dashboards in looker or alternate bi tool ( analytical, strategic, operational and a tactical dashboard )
Document the entire system
Skills:
Sql expertise
Google bigquery experience
Experience with matillion or other etl tools
Experience configuring looker or other main bi tools
Data warehouse design experience highly desirable
Skills working with relational and dimensional data models
Strong verbal and written communication skills, including facilitation of meetings with customers and technical staff
Excellent organizational and time management skills.
Excellent analytical and problem-solving skills
About the hiring process:
Qualified candidates will be invited to do a screening interview with the braintrust staffWe will answer your questions about the project, and our platformIf we determine it is the right fit for both parties, we`ll invite you to join the platform and create a profile to apply directly for this project.
C2c candidates: this role is not available to c2c candidates working with an agencyIf you are a professional contractor who has created an llc/corp around their consulting practice, this is well aligned with braintrust and we’d welcome your application.
Braintrust values the multitude of talents and perspectives that a diverse workforce bringsAll qualified applicants will receive consideration for employment without regard to race, national origin, religion, age, color, sex, sexual orientation, gender identity, disability, or protected veteran status.
This is a remote position.
