Data Analyst
About Us:
Capsule is rebuilding the $425 billion pharmacy industry from the inside out with an emotionally resonant experience and technology that enables customized outcomes for patients, doctors, hospitals, insurers, and manufacturers. We are laser focused on creating the best healthcare experience for our customers and driving meaningful value and better outcomes for every participant in the healthcare system. Capsule has raised over $500MM from the best healthcare and technology investors in the world to pursue our mission of building a pharmacy that works for everyone.
Our values are: everybody needs some looking after sometimes and winning together. People succeed in our culture when they are intensely focused on our customers, are energized by accomplishing ambitious goals, and push themselves and their teammates to be better. We work hard to teach and share our successes to help one another be successful. We anticipate our teammates’ needs and communicate early and often, using the input of our peers to operate both fast and right. We have tremendous ambitions and a lot of fun pursuing them — if that excites you, we’d love to have you join us.
About the Role:
The Capsule data team is expanding. Our data engineering team is responsible for transforming data into insights and data products. As a Data Analyst you would be responsible for working cross functionally to help source data, certify and maintain providence and quality, and enable analytic use cases.
- Work with our Insights, product, and engineering teams to identify analytic use cases, mapping them to existing data warehouse capabilities or creating requirements for new features.
- Identify, source, and profile source data, develop data lineage and driving queries for new data warehouse domains, working closely with data architects and engineers.
- Develop and execute test plans to assure data quality.
- Automation of tests for the monitoring of ongoing data quality within a data observability framework.
About You:
- You take pride in enabling the best work of others on the team. You think ahead to anticipate the needs of your teammates and you give and get all the facts making it easy for others to make decisions.
- You drive results in a way that makes everyone better. You accomplish ambitious objectives while uplifting the team around you. You're a magnet for team members looking to get better and be successful.
- You work hard and want to have fun while you do so. You celebrate wins and remember to enjoy the journey as we build something iconic.
- You can work both fast and right and don't view them as trade-offs. You understand when things require precision and accuracy and where 80% gets you to the desired outcome.
- You thrive on being pushed and challenged. You communicate effectively both in written form and live / on your feet - you are not fazed by tough questions in the moment.
- You strike the right balance between putting enough work in to share something, but not going off into a corner for weeks at a time to polish something to perfection.
- You operate like an owner and expect others to as well. You take personal responsibility and value personal responsibility in others.
- You check your ego at the door. You are interested in finding the right answer vs. always having the right answer.
Requirements:
- You have experience in an analytical, database development, or engineering role
- You have expertise in SQL, with the ability to perform analysis and write complex transformations using the full breadth of the SQL language
- You are proficient in excel, and experienced with a business intelligence/data visualization tool (ie PowerBI, Tableau,..), Looker prefered.
- You have a basic working knowledge of a general purpose programming language (Python, Java, Scala, Go, Ruby, C++, etc…), Python preferred.
- You are comfortable dealing with complex data, both structured and semi-structured (json)
- You have experience validating quality on analytic platform, Great Expectations a plus
- You have a strong business reasoning and understand the necessary tradeoffs that go into analytic projects.
- You have experience communicating and translating business needs into analytic and engineering requirement
Capsule is committed to hiring the best team possible to build a pharmacy that works for everyone. We have a diverse set of problems to solve, and believe that we need a diverse set of perspectives to deliver the best possible solutions to those problems. We look for talent from a wide range of backgrounds - including but not limited to - race, age, sexual orientation, gender identity and expression, national origin, religion, disability, and veteran status.