5+ years of commercial experience with hand-on Data Architecting, Modeling and Data Warehousing stack including AWS Redshift and other equivalent modern technologies
Experience with AWS solutions
Experienced with Python programming language
Familiarity with GIT and release engineering strategies
Deep experience with SQL design and architecture best-practices (i.e. third normal form, index management, constraints, and foreign key relationships, etc.).
Expertise in query tuning and performance optimization.
Experienced in creating ERD diagrams
Strong SQL abilities and experience with massive relational database systems.
Strong knowledge of all traditional Data Warehouse-related components (Sourcing, ETL, Data Modeling, Infrastructure, BI, Reporting) and the modern tools to support those components
Ability to clearly explain and justify ideas when faced with competing alternatives
Track record of working in Scrum / Agile software teams
Proficient in spoken and written English
Experienced in the healthcare domain (FHIR/HL7) is preferred
Bachelor’s degree or higher in a technical field of study
Experience with Postgres, Aurora (MySQL), DynamoDB
Familiarity with the MPP Databases, Hadoop ecosystem
Familiarity with continuous delivery and DevOps, understanding of common database administration tasks and concepts such as backup & restore, recovery models, integrity checks, and replication methods.
Flexibility and creativity in solution design — including leveraging emerging technologies
The clear growth path for every role and regular performance reviews
Meaningful projects with an impact on real-world problems
Lots of senior developers and mentors
High-trust environment: no time-trackers and flexible schedules
Very little bureaucracy
Personal development compensation: from English classes to Udemy courses
15 PTO days (20 PTO days after a year in our team) + 8 paid sick days
Relocation support for Lviv & Ivano-Frankivsk offices
Quarantine-friendly cozy offices
Snack-stocked kitchen and $50 monthly lunch compensation
Parties, team buildings, and weekly pizza/sushi days
Work as part of multifunctional teams to own the design and architecture of the logical entity model of the client’s suite of products
Convert logical models into physical data models employing sound database normalization techniques
Create physical database objects like tables and views with appropriate data types, foreign keys, constraints, and upfront design and maintenance of proper indexes
Create and maintain easy to follow technical documentation of data models
Serve as a go-to resource for questions related to existing and proposed logical and physical data models
Perform SQL code reviews and ensure that new database code meets company standards for readability, reliability, and performance
Assist with resolving the performance of poorly executing stored procedures and queries
Support team initiatives by developing tools and identifying opportunities for process automation; assist in evaluation and selection of standard tools for the department
Support building and deploying the infrastructure for ingesting high-volume data from various sources
Support developing and maintaining the data-related scripting for build/test/deployment automation
Research individually and in collaboration with other teams on how to solve problems
Partner with team and research, design, test, and evaluate new technologies and services as it applies to data warehousing and architecting
Partner with the team to maintain an organization-wide view of current and future strategy and approach as it applies to data warehousing and architecting
Identify and resolve bottlenecks and bugs
Our client is a healthcare company focused on healthcare data. They are a well-funded organization that has reputable clients and respected investors.
They are a US-based company headquartered in Boston, MA. This client brings information together so that consumers can make better health choices and physicians can make more informed treatment decisions through AI-powered insights.