Job Description - Data Engineer
Job Description - Data Engineer Required Skills:
5-8 years of experience in an analytics role with strong focus on Data Engineering
Passionate 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 solutions
Deep 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 and
query optimization techniques and demonstrated ability to both diagnose and prevent performance problems (MS SQL and Postgres)
Effective communication and collaboration skills including clear status updates
Comfort 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 insights
Explain 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 stages
Understand 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 insights
Document every action in either issue/MR templates the handbook or the DBT documentation so your learnings turn into repeatable actions and then into automation
Expand our database with clean data (ready for analysis) by implementing data quality tests while continuously reviewing optimizing and refactoring existing data models
Craft 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 review
Provide data modeling expertise through code reviews pairing and training to help deliver optimal DRY and scalable database designs and queries in Snowflake and in DBT
Become 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 team
Contribute to and implement data warehouse and data modeling best practices keeping reliability performance scalability security automation and version control in mind
Follow and improve our processes and workflows for maintaining high quality data and reporting while ensuring the Data-led Operations philosophy in everything you do
Required Skills:
Cro Cto Command Line Azure Business Intelligence Data Analysis Fla Insight Data Modeling Scala Tableau Agile Workflow Database Design Documentation Version Control Sql Trends Postgres Cleaning