Note: The job is a remote job and is open to candidates in USA. The Fountain Group is a national staffing firm seeking a Senior Data Engineer for a prominent client. This remote position involves designing, developing, and optimizing data infrastructure and pipelines while ensuring data accessibility and security across the organization.
Responsibilities
- Responsible for the design, development, and optimization of enterprise-scale data infrastructure and pipelines
- Support the engineering strategy, ensures data platform scalability, and delivers high-quality data solutions
- Ensure data is accessible, reliable, and secure across the organization
- Design scalable systems and build complex, end-to-end ETL (Extract, Transform, Load) pipelines to move data from various sources to data warehouses
- Enforce strict data quality standards and ensure all system designs meet security compliance requirements
- Mentor junior engineers, translate complex business requirements into technical solutions
- Continuously monitor and troubleshoot data pipelines and databases to improve processing speed, scalability, and cost-efficiency
- Ensure implemented Data Products meet the vision and goals of Data Consumers
- Enforce and adhere to best practices for technical documentation related to architecture, transformation logic and coding standards
Skills
- Minimum of 10+ years of prior experience as a Data Engineer working directly with Data Warehouses, Data Lakes, ELT/ETL, Data Pipelines
- Bachelor's degree in STEM field required
- Languages: Advanced proficiency in SQL and Python
- Cloud Platforms: Amazon Web Services (AWS), Google Cloud Platform (GCP), or Microsoft Azure
- Data Warehouses & Frameworks: BigQuery and/or Redshift
- Orchestration & Streaming: Apache Airflow, dbt (data build tool)
- Fluent English Speaker
- Prior experience working in the Pharma / Biotech industry
- Experience optimizing Data Pipelines is nice to have
- Experience with BI Tools (e.g. Tableau) is nice to have
Company Overview