\nInterwell Healthโs Senior Data Engineer role is responsible for corporate claims data acquisition, file loading and structure development. The ideal candidate will have a strong background in data engineering. \n\nThis position requires using current Data warehouse technologies, design, test, plan, implement, maintain EDW databases. \n\nThe work you will do: \n\n\n* Designs and develops database systems, processes, and documentation, based on the requirements of the company. This includes collecting data, analyzing data, designing algorithms, drawing flowcharts, and implementing code.\n\n* Collaborates effectively with the development groups to deliver projects to the satisfaction of the client in a timely fashion.\n\n* Maintains current knowledge of the latest and newest technologies in the areas of specific relevancy to the Data Architecture group for utilization as appropriate within the department. Identifies and researches enhancement options and process improvements, making suggestions to senior managers as needed and drive continued improvement and innovation.\n\n* Assist with schema design, code review, SQL query tuning.\n\n* Write and deploy SQL code.\n\n* Guide and mentor junior teammates acting as a resource with respect to the definition of development processes, methodologies and frameworks and other technical aspects of the projects and provides direction and assistance regarding working with users and the process and issues encountered with user interaction.\n\n* Become skilled with the architecture and technology supporting the Datawarehouse, to design and develop accordingly.\n\n* Ensure the distribution of knowledge for processes being designed and built within the team to ensure assigned jobs are completed accurately and according to schedule and that all deadlines are met.\n\n* Ensure the design of sufficient documentation for easy and smooth hand-over of projects.\n\n* Participate in the formulation and design of methodologies.\n\n* Trains in developing tools that are available with the Datawarehouse and Lakehouse infrastructure and help with development, where appropriate.\n\n* Monitor and troubleshoot data pipelines to identify and resolve performance issues, bottlenecks, and data anomalies.\n\n\n\n\nThe skills and qualifications you need:\n\n\n* 5-8 years related experience in data engineering with bachelorโs degree; or a masterโs degree with 3 yearsโ experience.\n\n* Ability to architect simple and complex solutions related to integration with other applications and design.\n\n* Excellent communication skills, both verbal and written.\n\n* Strong presentation skills. Ability to present formally to users and customers during gathering requirements, workshops, and feedback sessions. \n\n* Experience working under tight deadlines while maintaining high product relevance and quality.\n\n* Azure/SQL focus\n\n* Strong understanding of data lake and Lakehouse architecture principles, data modeling techniques, and data warehousing concepts.\n\n* 5-8 yearsโ experience using Azure Data Factory pipelines and Databricks.\n\n* 5 yearsโ experience working with Azure databases.\n\n* Extensive experience with MS SQL stack. (SSIS and ADF)\n\n* Extensive experience with Azure - Cloud migration.\n\n* Nice to have: Python experience. \n\n\n \n\n#Salary and compensation\n
No salary data published by company so we estimated salary based on similar jobs related to Design, Python, Cloud, Senior, Junior and Engineer jobs that are similar:\n\n
$62,500 — $105,000/year\n
\n\n#Benefits\n
๐ฐ 401(k)\n\n๐ Distributed team\n\nโฐ Async\n\n๐ค Vision insurance\n\n๐ฆท Dental insurance\n\n๐ Medical insurance\n\n๐ Unlimited vacation\n\n๐ Paid time off\n\n๐ 4 day workweek\n\n๐ฐ 401k matching\n\n๐ Company retreats\n\n๐ฌ Coworking budget\n\n๐ Learning budget\n\n๐ช Free gym membership\n\n๐ง Mental wellness budget\n\n๐ฅ Home office budget\n\n๐ฅง Pay in crypto\n\n๐ฅธ Pseudonymous\n\n๐ฐ Profit sharing\n\n๐ฐ Equity compensation\n\nโฌ๏ธ No whiteboard interview\n\n๐ No monitoring system\n\n๐ซ No politics at work\n\n๐ We hire old (and young)\n\n
\n\n#Location\nRemote, United States
๐ Please reference you found the job on Remote OK, this helps us get more companies to post here, thanks!
When applying for jobs, you should NEVER have to pay to apply. You should also NEVER have to pay to buy equipment which they then pay you back for later. Also never pay for trainings you have to do. Those are scams! NEVER PAY FOR ANYTHING! Posts that link to pages with "how to work online" are also scams. Don't use them or pay for them. Also always verify you're actually talking to the company in the job post and not an imposter. A good idea is to check the domain name for the site/email and see if it's the actual company's main domain name. Scams in remote work are rampant, be careful! Read more to avoid scams. When clicking on the button to apply above, you will leave Remote OK and go to the job application page for that company outside this site. Remote OK accepts no liability or responsibility as a consequence of any reliance upon information on there (external sites) or here.