Data Engineer II

AssistRx, Inc.; Florida; Presencial; USD 111.000 - 139.000; Jornada completa

Descripción de la vacante

AssistRx, Inc. is seeking a Data Engineer to own data architecture, ETL, and documentation across client implementations and internal systems. You will build and optimize data pipelines in Azure, Snowflake, dbt, and Salesforce, while shaping data flow standards and best practices.

The role requires 6+ years in analytics or data engineering, strong SQL, ETL tooling, and BI experience (Power BI, Cognos). You will collaborate with healthcare data teams in Florida, ensure PHI/PII compliance, and

Formación

• 6+ years in business analytics, data science, software development, data modeling, or data engineering.
• Strong SQL query/development skills and experience building ETL routines.
• Experience with healthcare PHI/PII data and multi-tenant environments.

Responsabilidades

• Design ETL processes within Azure, dbt, Snowflake and Salesforce for client migrations.
• Build data matching and cleanup pipelines prior to loading migration data.
• Document data flows from client implementations and internal processes.
• Develop and document data integration tooling and BI data models.

Conocimientos

SQL

Excellent communicator

Interpersonal skills

Prioritizing tasks

Creative thinker

Critical thinker

Ability to describe solutions

Educación

Bachelor's Degree in CS/Math/SE/CE or related field

Herramientas

Informatica

Talend

dbt

Azure Data Factory

Snowflake

Power BI

Tableau

Cognos

Spark

Hadoop

Sqoop

Descripción del empleo

Overview

Data Engineer will be responsible for best practices related to data architecture, ETL and documentation of data flow within AssistRx source systems and client implementations. Additionally, support existing systems/processes and develop new features and functionality, along with reviewing, presenting and implementing enhancements.

Responsibilities

• Design ETL (extract, transform, and loading) processes within Azure, dbt, Snowflake and Salesforce for client migrations
• Build processes for data matching and clean-up prior to loading of migration data. Responsible for all data flow documentation from a client implementation perspective.
• Assist with the database design, the build out and documentation of internal processes as it relates to Salesforce multi-tenant solutions to ensure it meets customer requirements for downstream data products. 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
• Hands-on experience in developing and implementing large-scale data warehouses, Business Intelligence and MDM solutions, including Data Lakes/Data Vaults.

Qualifications

• Bachelor's Degree in Computer Science, Math, Software Engineering, Computer 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 (e.g Informatica, Talend, dbt, Azure Data Factory)Experience working in the healthcare industry with PHI/PIICreative, 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)Knowledge / Hands-on experience with BI tools and reporting software (e.g. Cognos, Power BI, Tableau)Big Data stack (e.g.
• Snowflake(Snowpark), SPARK, Map
• Reduce, Hadoop, Sqoop, Pig, HBase, Hive, Flume)

Pay Range

USD $111,496.00 - USD $139,370.00 /Yr.