What are the responsibilities and job description for the Senior Data Engineer- REMOTE position at Sierra Solutions?
Job Summary
We are seeking a highly skilled Senior Data Engineer to support a key initiative with our life sciences client. In this role, you will be responsible for designing, building, and optimizing data pipelines that support analytics, reporting, and operational needs across supply chain and manufacturing functions. You'll work closely with technical and business stakeholders to translate existing reporting logic into scalable SQL-based data models and views, ensuring data is accurate, accessible, and production-ready. This is an excellent opportunity for someone who thrives in a fast-paced environment, is deeply knowledgeable in enterprise data systems, and has direct experience supporting data workflows within regulated industries.
Primary Responsibilities
- Design, develop, and maintain robust data pipelines, data models, and SQL-based transformations to support analytics, reporting, and operational workflows.
- Translate existing reporting requirements into optimized SQL views, datasets, and ETL/ELT processes.
- Work with cross-functional teams to map, cleanse, and integrate data from Oracle and other enterprise systems into centralized data platforms.
- Ensure data quality, reliability, and compliance across all pipeline components—particularly for life sciences manufacturing and supply chain processes.
- Collaborate with business analysts and solution architects to align technical solutions with business objectives.
- Troubleshoot data pipeline issues and optimize performance for large-scale, complex datasets.
- Document data flows, schemas, and transformation logic to support governance and reproducibility.
Education and Experience
- 5 years of experience as a Data Engineer, ETL Developer, or similar role.
- Deep expertise in SQL with the ability to translate complex logic into efficient SQL views and transformations.
- Hands-on experience building data pipelines in modern data engineering environments (ETL/ELT tools, cloud platforms, or on-prem SQL ecosystems).
- Strong familiarity with Oracle databases, schemas, and data structures.
- Prior experience working within life sciences, specifically supporting supply chain or manufacturing operations.
- Solid understanding of data modeling concepts, relational database design, and data integration best practices.
- Ability to work independently, communicate effectively, and collaborate with stakeholders across technical and functional teams.
- Must be willing and able to work Eastern Standard Time (EST) hours.
- Experience with Oracle EBS, OPM data structures, or translating EBS/OPM data into analytical models.
- Knowledge of GxP or other life sciences regulatory considerations.
- Familiarity with cloud data platforms (AWS, Azure, GCP) or tools like DBT, Snowflake, or Informatica.
- Experience supporting reporting or analytics teams using tools like Power BI, Tableau, or similar.