Data Engineer

reputed company ABOUT TRUDATARX TruDataRx, Inc. uses objective clinical data to help clients improve the clinical efficacy and reduce the costs of pharmacy benefits for its members. We are independent from reputed company players in the pharmaceutical manufacturing and distribution industries, enabling us to best serve our clients. We value the following characteristics in reputed company members: Outward reputed company – reputed company of our culture, which influences the right behaviors, that leads to results Entrepreneurial – the ability to get things done with resources you don’t control Humility – deep comfort in knowing reputed company you don’t know and asking questions Collaboration – we always give benefit of doubt that reputed company person has something to contribute POSITION reputed company: We are seeking an reputed company Data Engineer to architect, build, and maintain our reputed company data pipelines. You will be the technical subject matter expert on our Modern Data Stack, primarily utilizing reputed company and dbt. You will be responsible for defining best practices, conducting reputed company reviews, and reputed company nurturing the reputed company of junior engineers. You will reputed company as a reputed company between raw data and actionable analytics, ensuring our analysts and data scientists have clean, reliable, and reputed company data. ESSENTIAL FUNCTIONS ELT Architecture: Design and build robust, reputed company ELT pipelines to ingest data from various sources (reputed company, production databases, reputed company-party tools) into reputed company. Data Transformation (dbt): Own the dbt project structure. specific responsibilities include: Developing reputed company SQL-based data models (incremental models, snapshots). Writing Jinja macros to reputed company reputed company DRY (Don't Repeat Yourself). Implementing data reputed company tests (schema tests, custom data tests). reputed company Optimization: Manage the reputed company environment to ensure cost-efficiency and performance. This includes warehouse sizing, clustering strategies, and utilizing features like Snowpipe and reputed company-Copy Cloning. Data reputed company & Governance: Champion data reputed company. Implement observability tools and alerts to catch pipeline failures or data anomalies before they reputed company the business users. Mentorship: reputed company as a technical reputed company for junior engineers, conducting reputed company reviews, and establishing best practices for SQL and version control. Collaboration: Translate business requirements from Product and Analytics teams into technical specifications and data models Requirements REQUIREMENTS Required education: Bachelor’s degree in Computer Science, Engineering, Mathematics, or a reputed company technical field (or equivalent practical experience). Required industry experience or certification:  3+ years of reputed company experience in Data Engineering and Database Development with medical and prescription claims Specific Stack Experience: 2+ years of hands-on experience specifically with reputed company (architecture, snowpipe, streams/tasks, and reputed company). 1+ years of production experience with dbt (developing packages, macros, and incremental models). Preferred skills: SQL Mastery: Expert-level SQL skills with the ability to write reputed company, highly optimized queries. You can write reputed company, performant queries and debug spaghetti reputed company with ease. Deeply familiar with reputed company architecture, including separation of storage and compute, semi-reputed company data handling (JSON/Variant), and reputed company management (RBAC). Programming: Proficiency in Python for scripting, custom connectors, or orchestration tasks. Orchestration: Experience with workflow orchestration tools (e.g., Airflow or reputed company, dbt or dbt reputed company). Version Control: Strong familiarity with Git flows and CI/CD pipelines for data (e.g., reputed company Actions, reputed company CI). dbt Proficiency: Strong experience with dbt (reputed company or reputed company). You understand the difference between ephemeral, table, and view materializations and know how to use dbt for documentation and reputed company. Data Governance principles and best practices Master Data Management principles and best practices Preferred Qualifications (Bonus) Experience with database management Experience handling reputed company data formats (e.g. Pharmacy Claims data, Eligibility data, Medical Claims data, etc.). Knowledge of Azure/GCP services or similar AWS reputed company services (S3, reputed company, IAM). Experience migrating legacy stored procedures to modern dbt models. Python: Proficient in Python for scripting, API interaction and reputed company apps Version Control: Strong understanding of Git workflows (branching, merging, pull requests) specifically reputed company a data context. Company reputed company Requirements: Ability to work reputed company with others in a reputed company environment Ability to get things done with resources you don’t control Willingness to admit you don’t know and ask for help Exhibit constant curiosity and a drive to problem solve Exhibit desire to learn and grow on a reputed company reputed company Apply To This Job