Data Warehouse Architect

Rally Health San Francisco , CA 94102

Posted 3 months ago

Rally Health is all about putting health in the hands of the individual. Its our mission, and it drives everything we do, which is to empower people with easy-to-use online and mobile tools that help them take charge of their health and health care, from improving their diet and fitness to selecting health benefits, and choosing the right doctor at the right price for their needs.
Our culture is built on a deep and sincere commitment to helping people live healthier lives. To do this, we are committed to innovating at every level. As our president and COO David Ko says, We are a company that continuously innovates.
It cannot end. It has to be in everything we do, which means that some of the things were going to do are not going to work and thats okay. Were not trying to build something that is churn and burn.
Were building something that follows consumers over their lifetime.
About this position
We are looking for a Data Warehouse Architect who will lead the evolution of our next-gen Data Warehouse and will be responsible for enabling the massive amount of Data to be used for various production scenarios and insights. Responsibilities include but not limited to:
Architect and lead technology of large scale and high traffic data warehouse platform
Conceive, design, develop and deploy the data architecture and data models from scratch
Collaborate across business units (BI, Product, Reporting) to develop data warehouse platform vision, strategy, and roadmap
Train and mentor the team in data modeling and data quality related processes and standards
Bachelors degree in Computer Science or related fields
5+ years of prior experience in Data Warehousing
Strong conceptual, relational and dimensional data modeling skills
Data modeling expertise and a thorough understanding of logical modeling concepts
Strong SQL abilities and experience with massive relational database systems.
Experience building ETL and familiarity with design principles
Experience with distributed systems and application design in a SOA environment
Being analytical with strong problem solving skills and attention to detail
Being a self-starter and results-oriented with a strong sense of ownership
And for bonus points:
Knowledge of high-scale performance and optimization tools and techniques
Experience with AWS (configuring, deploying, managing, monitoring) services and distributed applications
About Rally Engineering
Rally is full of flexible minds as we believe in strong opinions, weakly held . We work in small teams which are mission driven and are independent to make their decisions.
We are obsessed with customer first mindset. We work hard and celebrate big. We are a proud set of engineers, really motivated to fix Healthcare.
Our tech stack is modern, in public cloud (AWS), microservices based large distributed system and is quality driven. We believe in continuously evaluating our tech stack, have an easy process of suggesting and adopting new technologies. Our engineers enjoy being empowered and accountable.
Set of technologies consist of:
Scala, Play, Akka,
MongoDB, PostgreSQL, ElasticSearch
AWS, Docker, Mesos, Marathon, Jenkins
Kafka, Spark, HDFS, Avro, Airflow and Redshift
Rally Health is committed to ensuring that its workforce reflects Americas diverse population. Rally Health knows that such diversity will enrich us with the talent, energy, perspective and inspiration it needs to achieve its mission.
Rally Health believes in a policy of equal employment and opportunity for all people based on merit and commitment to the principles of diversity. It is our policy to recruit, hire, train, and promote individuals in all job titles, and administer all programs, without regard to race, color, religion, national origin or ancestry, citizenship, sex, age, marital status, pregnancy, child birth or related medical conditions, personal appearance, sexual orientation, gender identity or expression, family responsibilities, genetic information, disability, matriculation, political affiliation, veteran status, union affiliation, or any other category protected by applicable federal, state or local laws.
Individuals with disabilities and veterans are encouraged to apply. Applicants who require an accommodation related to the application and/or review process should notify Talent Acquisition ().
Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Data Engineer Data Warehouse

Quantcast Corporation

Posted 7 days ago

VIEW JOBS 12/12/2018 12:00:00 AM 2019-03-12T00:00 Do you have a passion for cutting-edge technology? Do you thrive in fast-paced, dynamic environments? Do you love using your technical prowess to tackle industry-impacting challenges? Quantcast is hiring a Senior Data Engineer to work on our Data Warehouse team in our San Francisco headquarters. As the real-time pulse of the Internet, Quantcast runs the world's largest AI-driven insights and measurement platform directly quantifying over 100 million web destinations. Using machine learning to drive human learning, Quantcast provides brand marketers and publishers with meaningful audience insights, predictive targeting and measurement solutions across the customer journey. We are looking for a seasoned data engineer to build and grow large-scale analytical data platforms from the ground up. You will have opportunities to work end to end from collaborating with the business to designing and developing data pipelines to data modeling, all in the cloud. Responsibilities * Design, build, and maintain data pipelines (ETL/ELT) and database schemas/objects * Work with analysts to understand business needs and drive the project on its own and mentor the team * Collaborate on code reviews, internal processes, and software enhancements, and understanding of ETL/ELT/SQL/Python coding standards * Responsible for maintaining technical documentation to support new and existing solutions Requirements * 4+ years in the industry as a data engineer or backend engineer * You will understand data warehousing concepts (modeling, tuning, maintenance) * You are highly proficient with SQL, and have the desire to mentor and teach others SQL * You are proficient in Python or any other scripting languages and software development * You have a strong understating/experience in distributed data processing/Traditional RDBMS/MPP/NoSQL systems, and data modeling * You are driven by a curiosity and motivation to explore data * You have experience dealing with DevOps concerns for data pipelines * You have excellent listening and interpersonal skills Bonus Points * Experience with AWS Cloud ecosystem * Experience with Spark/Kafka/Kinesis * Experience with Pentaho, PostgreSQL, Salesforce, Redshift, Big Data systems * Reporting tool experience: Tableau and/or Looker or superset * Git, Docker, Jenkins, Jira experience * Knowledge of Adtech industry Quantcast owns and operates the world's largest audience insights and measurement platform on the open internet. Fueled by live data drawn from more than 100 million web and mobile destinations, Quantcast applies machine learning technology to help marketers, publishers, and agencies grow their brands by better understanding and predicting consumer interactions in real-time. Founded in 2006, Quantcast is headquartered in San Francisco and employs more than 700 employees in over 20 offices across 10 countries. We are committed to building an inclusive and diverse environment where everyone can be their authentic self. Quantcast Corporation San Francisco CA

Data Warehouse Architect

Rally Health