HNHacker News
TopNewBestAskShowJobs

iblaine

716 karma · joined May 6, 2012

Data Engineer doing Data Engineer things www.iblaine.com
submissionscomments
iblaine··on Ask HN: Who is hiring? (July 2020)
One Medical | San Francisco, CA or Austin, TX | Full-time | https://www.onemedical.com/careers/

One Medical is the fastest-growing primary care system in the country with over ~100 locations in major cities nationwide such as Boston, Chicago, Los Angeles, New York, SF, DC, Atlanta, and most recently, Austin. Technology has been a key to our success and we believe in building as much of it in-house as possible. Depending on your department, these are some of the core technologies you can expect to interface with: Angular, Python, AWS, Spark, Ruby, MySQL, Android, GraphQL, Java, Cypress, Hadoop, PySpark, Tensorflow, AI/ML

- Senior Security Automation and Tooling Engineer - (SF or Austin) https://www.onemedical.com/careers/all-departments/2135833/

- Senior Incident Response Engineer - (SF) (posting soon) https://www.onemedical.com/careers/all-departments/?departme...

- Senior iOS Engineer - (SF) https://www.onemedical.com/careers/all-departments/2113005/?....

- Engineering jobs - https://www.onemedical.com/careers/engineering/

- Clinical/IT/Doctors/Legal/Marketing/Operations/Sales/etc - https://www.onemedical.com/careers/all-departments/

Our investment in technology and focus on preventative healthcare has allowed us to help address the current covid crisis. We've been doing telemedicine for years, setting up outdoor covid stations across the nation, and as of last month we now offer anti-body testing, outside of all of the other services we provide.

For a better understanding of One Medical, please check out our Instagram (https://www.instagram.com/onemedical), reach out to our Recruiting team (https://www.linkedin.com/in/sbunker) or me.

iblaine··on The largest unknown Bitcoin wallet moved nearly $1B for $0.48 in fees
Is it also true that he/she would have paid $480M to move $1B in BTC if it were moved $1 at a time?
iblaine··on Ask HN: Who is hiring? (June 2020)
One Medical | San Francisco, CA | Full-time | https://www.onemedical.com/careers/ One Medical is the fastest-growing primary care system in the country with over 80+ locations in major cities nationwide. You’ll find our clinics in Boston, Chicago, Los Angeles, New York, Phoenix, Seattle, the San Francisco Bay Area, Washington, DC, San Diego, Portland and most recently, Austin. Here are some of our core technologies, that largely depends on your department: Angular, Python, AWS, Spark, Ruby, MySQL, Android, GraphQL, REST, Java, Cypress, Hadoop, PySpark, Tensorflow, AI/ML

- Senior iOS Engineer - https://www.onemedical.com/careers/all-departments/2113005/?...

- Engineering jobs - https://www.onemedical.com/careers/engineering/

- Clinical/IT/Doctors/Legal/Marketing/Operations/Sales/etc - https://www.onemedical.com/careers/all-departments/

We are heavily involved in the effort to help people during this covid crisis. We've been doing telemedicine for years, covid testing for several months, and as of last month we now offer anti-body testing.

For a better understanding of One Medical, please check out our Instagram https://www.instagram.com/onemedical, reach out to our Recruiting team or me.

iblaine··on Diagram as Code
This is great. Code needs to replace more drag n drop tools, at the very least to give people options.
iblaine··on Ask HN: How do you manage self-study?
I keep a running categorized list in Apple Notes. Several times a week I will add new items to it. Typically they’re links to blogs or YouTube, categorized by tech, leadership, coding, productivity & misc. When I find quiet time, on vacation or during a slow weekend, I’ll chip away at the list. It grows faster than I can keep up with...probably not a good sign but beats no list at all.
iblaine··on Ask HN: Who is hiring? (May 2020)
One Medical | San Francisco, CA | Full-time | https://www.onemedical.com/careers/ One Medical is the fastest-growing primary care system in the country with over 80+ locations in major cities nationwide. You’ll find our clinics in Boston, Chicago, Los Angeles, New York, Phoenix, Seattle, the San Francisco Bay Area, Washington, DC, San Diego, Portland and most recently, Austin. Here are some of our core technologies, that largely depends on your department: Angular, Python, AWS, Spark, Ruby, MySQL, Android, GraphQL, REST, Java, Cypress, Hadoop, PySpark, Tensorflow, AI/ML

- Engineering jobs - https://www.onemedical.com/careers/engineering/

- Clinical/IT/Doctors/Legal/Marketing/Operations/Sales/etc - https://www.onemedical.com/careers/all-departments/

We are heavily involved in the effort to help people during this covid crisis. We've been doing telemedicine for years, covid testing for several months, and as of last week we now offer anti-body testing.

For a better understanding of One Medical, please check out our Instagram https://www.instagram.com/onemedical, reach out to our Recruiting team or me.

https://finance.yahoo.com/news/one-medical-offers-free-covid...

iblaine··on Medium-hard SQL interview questions
>After an interview in 2017 went poorly — mostly due to me floundering at the more difficult SQL questions they asked me

Could be you dodged a bullet. A company with advanced interview questions may have some ugly SQL code. For jobs that lean heavily on SQL, I expect candidates to know things like windowing & dynamic variables, in SQL & an ORM library. For SWE's, I feel basic SQL is fine.

iblaine··on “Sequel” to the million dollar homepage using WebGL
The original million dollar home page was motivated by advertisers wanting SEO benefits. It was picked up by major media, so those pixels had value in addition to the SEO benefits. This WebGL version doesn't have that value. I think it's a scam but people can make their own opinions.
iblaine··on Ask HN: Who is hiring? (April 2020)
One Medical | San Francisco, CA | Full-time | https://www.onemedical.com/careers/ One Medical is the fastest-growing primary care system in the country with over 80 locations in major cities nationwide. You’ll find our clinics in Boston, Chicago, Los Angeles, New York, Phoenix, Seattle, the San Francisco Bay Area, Washington, DC, San Diego, Portland and most recently, Austin. Here are some of our core technologies, that largely depends on your department: Angular, Python, AWS, Spark, Ruby, MySQL, Android, GraphQL, REST, Java, Cypress, Hadoop, PySpark, Tensorflow, AI/ML

- Engineering jobs - https://www.onemedical.com/careers/engineering/

- Clinical/IT/Doctors/Legal/Marketing/Operations/Sales/etc - https://www.onemedical.com/careers/all-departments/

In my own words, One Medical is a technology company that exists within the health care industry. We are actively trying to improve health care outcomes, including tacking the covid19 epidemic. One Medical is an inclusive company, you work on problems that provide measurable benefits to people's lives, and we are growing quickly.

For a better understanding of One Medical, please check out our Instagram https://www.instagram.com/onemedical, reach out to our Recruiting team or me.

iblaine··on Ask HN: Who is hiring right now?
One Medical | San Francisco, CA | Full-time | https://www.onemedical.com/careers/ One Medical is the fastest-growing primary care system in the country with over 80 locations in major cities nationwide. You’ll find our clinics in Boston, Chicago, Los Angeles, New York, Phoenix, Seattle, the San Francisco Bay Area, Washington, DC, San Diego, Portland and most recently, Austin. Here are some of our core technologies, that largely depends on your department: Angular, Python, AWS, Spark, Ruby, MySQL, Android, GraphQL, REST, Java, Cypress, Hadoop, PySpark, Tensorflow, AI/ML

- Engineering jobs - https://www.onemedical.com/careers/engineering/

- Clinical/IT/Doctors/Legal/Marketing/Operations/Sales/etc - https://www.onemedical.com/careers/all-departments/

In my own words, One Medical is a technology company that exists within the health care industry. We are actively trying to improve health care outcomes, including tacking the covid19 epidemic. One Medical is an inclusive company, you work on problems that provide measurable benefits to people's lives, and we are growing quickly.

For a better understanding of One Medical, please check out our Instagram https://www.instagram.com/onemedical, reach out to our Recruiting team or me.

iblaine··on Microservices – Combinatorial Explosion of Versions
This is an interesting void for micro services that’s not yet being met.
iblaine··on Ask HN: Who is hiring? (March 2020)
One Medical | San Francisco, CA | Full-time | https://www.onemedical.com/careers/ One Medical is the fastest-growing primary care system in the country with over 80 locations in major cities nationwide. You’ll find our clinics in Boston, Chicago, Los Angeles, New York, Phoenix, Seattle, the San Francisco Bay Area, Washington, DC, San Diego and most recently, Portland.

Here are some of our core technologies, that largely depends on your department: Angular, Python, AWS, Spark, Ruby, MySQL, Android, GraphQL, REST, Java, Cypress, Hadoop, PySpark, Tensorflow, AI/ML

- Engineering jobs - https://www.onemedical.com/careers/engineering/

- Principal Software Engineer (Fullstack) - https://www.onemedical.com/careers/all-departments/1152584/

- Clinical/IT/Doctors/Legal/Marketing/Operations/Sales/etc - https://www.onemedical.com/careers/all-departments/

In my own words, One Medical is a technology company that exists within the health care industry. It's inclusive, you work on problems that provide measurable benefits to people's lives, and we are growing quickly. As of this quarter, we are a public company. If you're in San Francisco or willing to relocate, I'd encourage you to check it out.

iblaine··on No ‘carmageddon’ on auto-free Market Street: study shows bikes and buses benefit
There is an impact for some retail businesses. I tried shopping near market street for items that require a car to transport. I gave up trying to get through traffic, and instead did my shopping online. This is an acceptable trade off for me, and demonstrates how some retail businesses may need to adjust.
iblaine··on M3DB, a distributed timeseries database
Open sourcing projects is the new merit badge for engineers. But at least there’s more good than bad from it. Hudi is at least one Uber project I can point to off the top of my head that is a great idea.
iblaine··on Ask HN: What are some examples of good database schema designs?
s/1NF/3NF/g ...point here is that data good design comes from objects in 3NF...1NF is a good start, 3NF would be better...
iblaine··on A group of ex-NSA and Amazon engineers are building a ‘GitHub for data’
I see 'Github for data' but I'm reading services to hide PII. I think a distinction needs to be made here. Is the primary goal to enable Change Cata Capture on data(Github does CDC on code) or is the primary goal to manage PII?
iblaine··on Ask HN: How do I learn JavaScript?
https://frontendmasters.com/

I’ve found the courses on this site to be great. Easy to follow, diverse, and useful for non-front end engineers like myself.

iblaine··on Ask HN: What are some examples of good database schema designs?
> What are good schema examples?

Anything that doesn't break the first normal form("1NF")[1].

> And what are some poor examples?

Anything that breaks 1NF.

You break 1NF when...

* a column cannot be described by the key, ex. user.id describes user.name but not user.items_purchased.

* values in a column are repeated, ex. a user table that stores multiple addresses for the same user should be split into an addresses table.

Treat tables as classes and you'll be fine. Just like a method may not belong in a class, a column may not belong in a table.

[1](https://en.wikipedia.org/wiki/First_normal_form)

iblaine··on The Rise of SQL-Based Data Modeling
Using Inmon or Kimball's approach to modeling data structures is clean. The thing with modeling data is there's no one right way but there are many wrong ways.
iblaine··on The Rise and Fall of the OLAP Cube
You are correct, and eventually consistent is a hand-wavy description of Redshift. While Redshift is ACID compliant, it squarely belongs in the category of OLAP db's and not OLTP db.s
iblaine··on The Rise and Fall of the OLAP Cube
That’s a valid point. Thanks.
iblaine··on The Rise and Fall of the OLAP Cube
For anyone wondering, OLAP != OLAP Cubes

OLAP = A category of databases meant for analyzing data. These are eventually consistent db's, and not OLTP db's. OLAP db's include Redshift, Teradata, Snowflake, BigQuery, and others. Generally what makes a database an MPP database is partitioning compute and storage. Generally what differentiates one MPP db from another is whether or not data and compute are colocated.

OLAP Cubes = A feature built into SQL Server, that includes has its own dialect of SQL called MDX. OLAP Cubes are decreasing in popularity because you can achieve the same results through other means and less effort.

iblaine··on The Rise of SQL-Based Data Modeling
The problem with modeling data isn't the lack of tools or the need to approach this problem differently. Plenty of solutions exist. People just don't care, and this is ok.

It used to be that you needed tools like Informatica and Kimball inspired datamarts, but databases are now bigger and faster. Whatever data modeling problems you may have, you can easily clean up in an ETL or a BI layer, with relatively little effort. This makes tools like Looker, dbt, and Holistics a luxury and not something you need to have. I wish the industry would put more effort into defining clean data models, but I think that ship has sailed. The prevailing trend seems to be to create Data Lakes, add a BI layer, then call it a day.

[edit] Also...some database points. The industry never shifted to using NoSQL to replace RDBMS systems. But event processing matured, NoSQL db's are ideal for storing unstructured data, so you see them in data engineering stacks. Greenplum is a free MPP database that has been around for nearly a decade. The point about Spanner SQL is interesting for the fact that Spanner evolved from NoSQL like methods to a SQL like dialect, but Spanner is a unique flower in the industry, due to being an HTAP db.

iblaine··on A Graph of Related Subreddits
If I pick a relatively obscure subreddit like dataengineering, then the results are noisy. May increase the distance/decrease the charge between nodes as the number of children increases on a node?
iblaine··on Ask HN: What tools do you use for data munging and merging?
Technical and free: Airflow

Technical and has a fee: dbt, prefect (while prefect is free, prefect cloud is not)

Non-technical and has a fee: datacoral.ai, ascend.io

You can solve your problem with any of these solutions, and many others not mentioned here.

iblaine··on Google Brass Set 2023 as Deadline to Beat Amazon, Microsoft in Cloud
GCP generates $8B annually. It's a bit dramatic to think Google will give up on GCP. AWS has a loyal customer base, which is well deserved, but Google does have some unique products (like Spanner) that AWS may never have. Point being there will always be a place in the market for GCP.
iblaine··on Ask HN: Who is hiring? (December 2019)
One Medical | San Francisco, CA | Full-time | https://www.onemedical.com/careers/ One Medical is the fastest-growing primary care system in the country with over 70 locations in major cities nationwide. You’ll find us in Boston, Chicago, Los Angeles, New York, Phoenix, Seattle, the San Francisco Bay Area, Washington, DC and most recently, San Diego.

Core technologies, that largely depend on your department: Angular 7, Python, AWS, Spark, Ruby, MySQL, Android, GraphQL, REST, Java, Cypress, Hadoop, PySpark

- Engineering jobs - https://www.onemedical.com/careers/all-departments/1152569/

- Principal Software Engineer (Fullstack) - https://www.onemedical.com/careers/all-departments/1152584/

- Senior QA Engineering Manager - https://www.onemedical.com/careers/all-departments/1636119/

- Clinical/IT/Doctors/Legal/Marketing/Operations/Sales/etc - https://www.onemedical.com/careers/all-departments/

In my own words, One Medical is a technology company that exists within the health care industry. It's inclusive, you work on problems that provide measurable benefits to peoples lives, we had a big group going to Grace Hopper, and it's in a hyper-growth phase. If you're in San Francisco or willing to relocate, I'd encourage you to check it out.

iblaine··on Ask HN: What does your BI stack look like?
It's interesting seeing the various stacks being used...Here at One Medical:

[ onemedical.com, mixpanel, Google Sheets, Salesforce, etc ] -> S3 (Amazon EMR) -> [ Tableau, Aurora MySQL ]

It's a nice & clean stack for data engineering.

Airflow is used for orchestration and is heavily customized with plugins. Zeppelin notebooks are used by most analysts.

We'll probably be replacing Aurora MySQL w/an MPP database like Snowflake or Redshift. MySQL is a crutch, but easy to deploy and manage to a point.

Several python frameworks also do various ETL & data science functions, but everything generally revolves around S3 & Airflow.

Amazon EMR is a great swiss army knife for ETL. Moving between Pig, Spark & Hive is trivial. Tableau is a bit of a challenge. Tableau seems to give users too much rope to hang themselves with.

Also, we're hiring: https://www.onemedical.com/careers/

iblaine··on Ask HN: What does your BI stack look like?
The gitlab wiki has some amazing content on it. Thanks for making it public.
iblaine··on Our Company Retreat for the End of 2019
To each their own, but company retreats are a gift that employees give to their employer, in the form of time. Keeping it light and encouraging team building makes sense. Hackathons seem aggressive, IMHO.

> Want to be part of our Insent family?

Also -> https://webcache.googleusercontent.com/search?q=cache:Y6Au8W...

← PreviousPage 4 of 14Next →