Drive the design and delivery of a next-generation, cloud-hosted data platform, architecting large-scale data warehouse solutions and building high-performance ETL pipelines for a financial services ecosystem.
Compensation
$70-$73 on w2
Responsibilities
Architect and maintain Operational Data Stores (ODS), Enterprise Data Warehouses (EDW), data lakes, and marts
Design and build high-performance batch and real-time data pipelines using Informatica Cloud, Azure Data Factory, and SQL
Operationalize data lineage, cataloging, and quality standards
Lead end-to-end data testing strategies by building intelligent, automated test suites and integrating them into CI/CD pipelines
Build and present proofs of concept (POCs) to stakeholders, mentor engineering teams, and resolve critical production incidents
Requirements
Bachelor’s or Master’s degree in Computer Science, Computer Engineering, or a related field
The Data Developer joins the HR & IT Data Domain team to leverage SQL, Python, and data engineering expertise to design, develop and optimize scalable data warehouse solutions for reporting and analytics.
Responsibilities
Analyze and understand business requirements, translating them into scalable, efficient data warehouse solutions and data models.
Design, build, optimize and maintain ETL processes and data pipelines ensuring reliable, accurate and timely data delivery.
Perform data validation, testing and root cause analysis to identify and resolve data quality, performance and consistency issues.
Support troubleshooting and incident resolution for data integration and reporting issues.
Produce and maintain clear technical documentation for data models, ETL processes, reporting semantic models, data mappings and development activities.
Hiring Manager Notes:
Priority is programming and data warehousing, applied within a clinical environment.
Needs strong SAS programming experience.
Needs intermediate-to-advanced SQL.
Must have data warehouse development and maintenance experience, including clinical database management.
Still needs solid understanding of CDISC, CDASH and SDTM.
Needs real clinical trial data experience. Generic SAS or SQL backgrounds without it won't work.
External data acquisition applies here too: vendor data, SFTP transfers, and integration and transformation of that data.
Builds database schemas and edit checks, and maintains studies in the CDR across the study lifecycle.
AI programming/automation exposure is a preferred plus.
If choosing between a strong clinical systems/CDISC candidate and a strong SAS/SQL/warehouse candidate, the manager picks the SAS/SQL/warehouse one for this role.