Data Engineer will be responsible for ETL and documentation in building AssistRx data warehouse and analytics capabilities. Additionally, maintain existing systems/processes and develop new features, along with reviewing, presenting and implementing performance improvements. Requirements
- Build ETL (extract, transform, and loading) jobs using Fivetran and dbt for our internal projects and for customers that use various platforms like Azure, Salesforce, and AWS technologies
- Monitoring active ETL jobs in production.
- Build out data lineage artifacts to ensure all current and future systems are properly documented
- Assist with the build out design/mapping documentation to ensure development is clear and testable for QA and UAT purposes
- Assess current and future data transformation needs to recommend, develop, and train new data integration tool technologies
- Discover efficiencies with shared data processes and batch schedules to help ensure no redundancy and smooth operations
- Assist the Data Quality Analyst to implement checks and balances across all jobs to ensure data quality throughout the entire environment for current and future batch jobs.
Engineering, or related field AND 6+ years experience in business analytics, data science, software development, data modeling or data engineering work
- 3-5 year’s experience with a strong proficiency with SQL query/development skills
- Develop ETL routines that manipulate and transfer large volumes of data and perform quality checks
- Hands-on experience with ETL tools dbt, Azure Data Factory
- Experience working in the healthcare industry with PHI/PII
- Creative, lateral, and critical thinker
- Excellent communicator
- Well-developed interpersonal skills
- Good at prioritizing tasks and time management
- Ability to describe, create and implement new solutions
- Experience with related or complementary open source software platforms and languages (e.g. Java, Linux, Apache, Perl/Python/PHP, Chef)
- Big Data stack (e.g.Snowflake(Snowpark), SPARK, MapReduce, Hadoop, Sqoop, Pig, HBase, Hive, Flume)
Benefits Supportive, progressive, fast-paced environment Competitive pay structure Matching 401(k) with immediate vesting Medical, dental, vision, life, & short-term disability insurance AssistRx, Inc. is proud to be an Equal Opportunity Employer. All qualified applicants will receive consideration without regard to race, religion, color, sex (including pregnancy, gender identity, and sexual orientation), parental status, national origin, age, disability, family medical history or genetic information, political affiliation, military service, or other non-merit based factors, or any other protected categories protected by federal, state, or local laws. All offers of employment with AssistRx are conditional based on the successful completion of a pre-employment background check. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire. Sponsorship and/or work authorization is not available for this position. AssistRx does not accept unsolicited resumes from search firms or any other vendor services. Any unsolicited resumes will be considered property of AssistRx and no fee will be paid in the event of a hire
PHP HBase Azure Data Factory sqoop fivetran Python Apache Spark mapreduce Data Engineering flume Linux Apache Hive Chef Infra snowflake-cloud-data-platform apache-pig Perl SQL Java ETL Hadoop Apache HTTP Server DBT