Data Engineer

Data EngineerData EngineerFull TimeRemoteTeam 11-50H1B No SponsorCompany Site LinkedIn

Location

Colorado

Posted

60 days ago

Salary

$120K - $150K / year

Bachelor Degree10 yrs expEnglishAirflowAmazon RedshiftAWSCloudETLPostgresPythonRDBMSSQL

Job Description

• Design and implement scalable data architectures using AWS cloud services, including data lakes, data warehouses, bulk data ingestion, and transaction processing. • Collaborate with stakeholders and other cross-functional teams, to comprehend data requirements and align data models with business needs for optimal data utilization. • Assemble large, complex data sets that meet functional business requirements. • Support the development and implementation of ETL processes to ingest, clean, and transform data from various sources into our application data platforms. • Identify, design, and implement internal process improvements to automate manual processes and optimize data delivery. • Leverage AWS services, such as AWS Glue, AWS Lambda, AWS Step Functions, Redshift, Aurora, Amazon S3, MWAA-Airflow to build and optimize data workflows and process pipelines. • Administer AWS databases effectively, within Amazon RDS, RedShift, Aurora, and PostgreSQL. • Stay current with AWS services and recommend suitable tools for specific data engineering tasks. • Monitor and optimize data pipelines and data storage for performance, cost, and reliability. • Implement caching mechanisms and data partitioning strategies to enhance query efficiency and reduce data processing times. • Develop and support the internal applications using Python, SQL, and Stored Procedures. • Provide technical leadership and mentorship within the Data Engineering team, fostering collaboration and innovation.

Job Requirements

Bachelor’s degree in computer science, Informatics, Information Systems, or another quantitative field.
Strong Software development skills and prior experience using Python, SQL, and Stored Procedures, AWS Glue, Lambda, Step Functions, MWAA-Airflow.
10+ years of experience in data engineering or a similar role with demonstrated technical leadership experience.
Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL), writing views, stored procedures and triggers in an AWS Cloud Environment with RedShift, Aurora, PostgreSQL or similar RDBMS.
Strong database administration skills in AWS cloud databases, RedShift, RDS Aurora PostgreSQL.
Experience with healthcare data (HL7, Medical Claims, Rx Claims) or similar healthcare data is required.
Excellent communication and organizational skills.

Benefits

Great Health Insurance - The company pays 100% of medical, dental, and vision premiums for teammates, and 50% for dependents.
401K Match - Evio matches 100% of teammate contribution up to 5% of salary, subject to IRS limits. 401K is administered through Guideline.
Time Off - We have a flexible vacation policy for teammates to unplug and recharge when you need it. There is no minimum or maximum amount of vacation allowed per year, and there is no payment in consideration for unused vacation. Vacation is to be used at your discretion, with approval of leadership.
Parental Leave - Generous paid leave for new parents (includes birth and non-birth parents).