Data Engineer

Title - Data EngineerDepartment - TechnologyReports to - CTOEmployment Status - Full-timeFLSA Status - ExemptLocation - US-Remote
PE backed start-up, DoseSpot is a dynamic and innovative leader in the electronic prescribing software market. We are on a hyper-growth curve at the intersection of the software and healthcare industries. We need great team members to capitalize on these opportunities and improve the healthcare experience for patients and doctors alike. DoseSpot has an exciting opportunity to join a fun and growing team, benefit from strong market tailwinds, and be part of an exciting opportunity to ensure mission-critical prescriptions are delivered on time and without error.
What we are looking for We are looking for an experienced Data Engineer to join our technical team. You'll be responsible for building a new data warehouse to transform our current data, which will fulfill internal and external requests around data analytics and reports. Additionally, you'll expand and optimize our data and data pipeline architecture. You'll have the opportunity to work with existing big data and build new data structures from the ground up. In this newly created and highly impactful role, you will work closely with others in the product, technical, and other departments.
What you'll do

• Analyze and adjust existing data and data structures
• Conceptualize and own the data architecture for multiple large-scale projects, while evaluating design and operational cost-benefit tradeoffs within systems
• Write and tune complex queries and jobs
• Design, build, launch, and maintain sophisticated data models, optimal data pipeline architecture and infrastructure
• Work to ensure data quality and reliability from multiple sources and after necessary transformations
• Evaluate business requirements and develop plans to meet those
• Develop tools and reports to illustrate key data
• Convert manual steps into automated processes
• Review data for trends and patterns and produce visualizations that support multiple use cases across different products or domains
• Collaborate with engineers and product managers to understand data needs, representing key data insights in a meaningful way
• Manage SLA for all data sets in allocated areas of ownership

RequirementsRecommended Minimum Qualifications: Education and Experience: or any equivalent combination of education, training, and experience which provides the required knowledge, skills, and abilities to perform the key responsibilities of the job.

• Bachelor's degree in Computer Science, Information Systems or equivalent experience with at least five (5) years of experience in a Data Engineering position
• Experience leading the design and implementation of a data warehousefrom scratch within a cloud platform
• Advanced SQL knowledge and working with relational databases
• At least 3 years' experience working in a cloud environment - Azure preferred but not required
• At least 3 years' experience working with Azure DataFactory, Synapse, PowerBI, or similar data tools
• Some experience in at least 1 object-oriented or scripting programming language
• Experience building and optimizing 'big data' data pipelines and architecture and defining data transformations
• Experience working in a highly available and scalable environment (working on an application that is used consistently and has very large data sizes)
• Comfortable training and mentoring more junior engineers, dependent on future growth
• Strong analytical skills with data sets
• Ability to collaborate and communicate with cross functional teams to accomplish business goals

Benefits 80+ person remote work environment with flexible scheduling to encourage work-life balance Remote Team OffsiteCompetitive compensation plus yearly bonusesA generous leave package including flexible time off policy that encourages team members to take time off to relax and recharge; plus 13 paid holidays, paid sick leave, and paid parental leave100% Company paid premiums for Medical, Dental, Vision, STD, LTD, AD&D, and Life insurance for you and your family, plus a Company funded FSA & HRA of up to $2,000 annually401(k) Company Match plus a Company Contribution for all team members each year to help build financial security even if they can't participate right nowGenerous Workspace Reimbursement - to help you optimize your remote workspaceFor more information on our benefits, go to https://www.dosespot.com/careers#benefits
Please be aware of hiring scams! You can read more information on here: https://www.dosespot.com/blog/red-flags-identifying-a-job-scam
Sponsorship All applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa.
DoseSpot is an equal opportunity employer and we value diversity and inclusion. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations. It is our intent to maintain a work environment that is free of harassment, discrimination, or retaliation on the basis of race, color, ancestry, national origin, religion, sex (including sexual orientation, transgender status, and gender identity), pregnancy (including childbirth, lactation, and related medical conditions), age (40 or older), physical or mental disability, genetic origin, military service, veteran status, or any other protected status by federal, state, or local laws. Applicants have rights under Federal Employment Laws:

• Family and Medical Leave Act (FMLA) [https://www.dol.gov/agencies/whd/posters/fmla];
• Equal Employment Opportunity (EEO) [https://www.dol.gov/agencies/ofccp/posters]; and
• Employee Polygraph Protection Act (EPPA) [https://www.dol.gov/agencies/whd/posters/employee-polygraph-protection-act]