Staff Data Engineer (EL Focus - Azure/Snowflake)
Life Science Connect is dedicated to uniting life sciences professionals and suppliers to accelerate research, development, and manufacturing. We help professionals discover market opportunities by facilitating mutually beneficial connections between audiences and strategic partners. This accelerates the advancement of life-improving, life-extending, and life-saving therapies and devices. We serve a loyal, satisfied readership that demands original, compelling content with utility. Our comprehensive suite of capabilities for B2B sales and marketing enablement contributes significantly to the creation and maintenance of robust business development pipelines for our partners. The Mission: Data Force Multiplier
Life Science Connect is pivoting from a traditional publisher to a Data Authority . We are building a modern "Efficiency Stack" centered on Azure, Snowflake, and dbt to power our proprietary intent scoring and analytics products. We are seeking an expert, hands-on Staff Data Engineer to be the technical backbone of our data ingestion strategy. This is a critical, high-impact role focused specifically on the Extraction and Load (EL) portion of our architecture. You will not just build pipelines; you will architect the ingestion framework that feeds our entire analytics ecosystem. Your success will be measured by your ability to deliver high-quality, reliable, and timely raw data to our Analytics Engineering team, acting as a force multiplier that enables them to focus purely on business logic and transformation. Key Responsibilities 1. EL Pipeline Architecture & Execution
- Ingestion Architecture: Own the design, development, and optimization of scalable data ingestion pipelines using Azure Data Factory (ADF) . You will move beyond basic "drag-and-drop" configurations to build resilient, parameterized frameworks.
- Complex Source Integration: Design robust pipelines for high-volume, complex sources including Salesforce, Google Analytics (GA4), and internal APIs . You will be responsible for building custom connectors (using Python/Azure Functions) when native ADF connectors encounter API limits or sampling constraints.
- Snowflake Landing: Architect efficient loading patterns into Snowflake (Snowpipe, External Stages), ensuring that the "Raw Layer" is optimized for cost and performance before transformation begins.
- The "dbt" Bridge: Act as the primary partner to the Analytics Engineering team. You will collaborate on Raw Layer schema design , ensuring that data lands in a structure that is easily consumable by dbt, preventing "garbage in" scenarios.
- Data Reliability: Provide the downstream teams with thoroughly documented reliable raw data feeds. You are the guarantee that the data in the warehouse matches the source of truth.
- Advanced Orchestration: Design dependency-aware pipeline orchestrations that manage the full data lifecycle, ensuring data arrives in the correct order and at the required frequency.
- Performance Tuning: Continuously monitor pipeline performance (latency, throughput) and optimize ADF resource allocation to control costs without sacrificing speed.
- CI/CD Implementation: Define and lead the implementation of CI/CD pipelines for data workflows. You will enforce automated testing and deployment processes using Git/GitHub , treating infrastructure as code.
- Security & Compliance: Implement security best practices within the ingestion layer, specifically regarding Azure Key Vault for credential management and PIPL/GDPR compliance for PII handling.
- Experience: 7+ years of professional experience in data engineering with a focus on high-volume production pipelines.
- The "Hybrid" Skillset: You have expert-level proficiency with Azure Data Factory (ADF) , but you are also a strong coder. You are proficient in Python and SQL, capable of writing custom scripts for API interactions, data validation, and complex logic that GUI tools cannot handle.
- API Mastery: You understand the nuances of integrating with complex SaaS APIs (Salesforce, GA4). You know how to handle rate limits, pagination, and token management programmatically.
- Warehouse Expertise: You have extensive experience loading data into Snowflake and understand the architectural implications of loading patterns on warehouse costs.
- Stakeholder Focus: You understand that your "customer" is the Analytics Engineer. You take pride in delivering clean, reliable raw data that makes their job easier.
- Strategic Impact: You will build the foundation of our "Data Authority" platform, handling the data that drives our revenue.
- Modern Stack: Work with a clean, modern stack—Azure, Snowflake, Python, and dbt—without the burden of on-prem legacy debt.
- Empowerment: You report to the Director of Data Architecture with a mandate to define the standards for how data enters our ecosystem.
At Life Science Connect, our commitment to empowering innovation and facilitating growth within the life sciences sector extends to our employees. We offer a comprehensive total compensation program designed to support your overall health, financial well-being, and professional development.
In addition to a competitive salary, you'll enjoy:
- Medical/vision/prescription/dental coverage for you and your family
- 100% company-paid short- and long-term disability insurance
- 100% company-paid life insurance
- 401(k) with dollar-for-dollar company match up to 6%
- 15 vacation days and 6 personal days on day 1
- 13 company-paid holidays
Recommended Jobs
Host
Three stories of fun await you at the Continental Mid-town , affiliated with STARR Restaurants . Whether you’re relaxing in the lounge, swinging in a basket chair on the jet-set mezzanine or taki…
Associate Veterinarian
Associate Veterinarian – Pittsburgh, PA We are seeking a motivated Associate Veterinarian to join a team of passionate, highly skilled doctors. Our client is a busy, AAHA-accredited, 24-hour eme…
FedEx Delivery Driver
Delivery Driver – FedEx Ground | $160–$210/day | Full-Time, Part-Time, Weekend Location: Pittsburgh North Terminal – Zelienople, PA Ready for a driving career that pays well, offers full benef…
Inside Sales Team Lead
Bring more to life. Are you ready to accelerate your potential and make a real difference within life sciences, diagnostics and biotechnology? At Integrated DNA Technologies (IDT), one of D…
Advanced Cloud DevOps and Platform Engineer
Responsibilities for this Position Advanced Cloud DevOps and Platform Engineer ID: 2025-69662 USA-PA-Pittsburgh Required Clearance: TS/SCI, obtainable within reasonable time based on req…
Bag Jammer/Manual Encoder - Philadelphia International Airport - PHL - Oshkosh - Philadelphia, Pennsylvania, United States
About Oshkosh AeroTech, an Oshkosh company Oshkosh AeroTech is a leading provider of aviation ground support products, gate equipment and airport services to commercial airlines, airports, air-fre…
Director of Transportation
DESCRIPTION OF EMPLOYER: Founded in 1901, Feeser’s, Inc. is a family owned and operated full-line foodservice distributor located in Harrisburg, PA servicing the Mid-Atlantic region. Feeser’s provid…
To-Go Specialist
Text " BonefishWay " to 30437 to apply now! By texting BonefishWay to 30437 you will opt-in to receive hiring messages and account related messages from Bonefish Grill. Text HELP for help or sm…
Licensed Practical Nursing - 24k Tuition Reimbursement
Licensed Practical Nursing (LPN) - NEW HIGHER RATES Richland, PA Phoebe Richland was voted "Best Nursing Home" by US News and World Report! At Phoebe Ministries Richland , we’re more than…
Bell Ringer
Job Description Bell Ringer PeopleReady of Erie, PA is now hiring Bell Ringers! Apply today and you could start as soon as tomorrow. As a PeopleReady associate you'll benefit from: Nex…