Data Engineer

Job Description - Data Engineer Required Skills:5-8 years of experience in an analytics role with strong focus on Data EngineeringPassionate about data, analytics and automation. Experience cleaning and modeling large quantities of raw, disorganized data (we use dbt)Experience with a variety of data sources (structured and unstructured, HL7 format is a plus)Demonstrate capacity to clearly and concisely communicate complex business logic, technical requirements, and design recommendations through iterative solutionsDeep understanding of SQL in analytical data warehouse (we use Snowflake SQL) and exposure to business intelligence tools would be a plus (we use Tableau)Hands on experience working with SQL, performing ETL/ELT operations and building data pipelines (Using Azure or Kestra)Familiarity with Git and the command line Deep understanding of relational and non-relational databases, SQL andquery optimization techniques, and demonstrated ability to both diagnose and prevent performance problems (MS SQL and Postgres)Effective communication and collaboration skills, including clear status updatesComfort working in a highly agile, iterative environment

Responsibilities

Collaborate with the business and other functions across the company by building custom analytical objects, reports and dashboards with useful analysis and data insightsExplain trends across data sources, potential opportunities for growth or improvement, and data caveats for descriptive, diagnostic data analysis.Develop deep understanding of how the data flows through different systems and transformed at various stagesUnderstand and document the full lifecycle of data and our common data framework so that all data can be integrated, modeled for easy analysis, and analyzed for data insightsDocument every action in either issue/MR templates, the handbook, or the DBT documentation so your learnings turn into repeatable actions and then into automationExpand our database with clean data (ready for analysis) by implementing data quality tests while continuously reviewing, optimizing, and refactoring existing data modelsCraft code that meets our internal standards for style, maintainability, and best practices for a high-scale database environment. Maintain and advocate for these standards through code reviewProvide data modeling expertise through code reviews, pairing, and training to help deliver optimal, DRY, and scalable database designs and queries in Snowflake and in DBTBecome code-owner of specific database and data model schemas Own the end-to-end process of building data models, data pipelines &analytical models (containing advanced transformations) as well as providing data support as and when needed by the Analytics/Engineering/Operations teamContribute to and implement data warehouse and data modeling best practices, keeping reliability, performance, scalability, security, automation, and version control in mindFollow and improve our processes and workflows for maintaining high quality data and reporting while ensuring the Data-led Operations philosophy in everything you do