Data Engineer (pharma; 100% remote)

About the Project

You will be the backbone of our data platform — designing, building and maintaining the pipelines, transformations and APIs that power Finance reporting, analytics and operational tooling across the organization.
You will work in a modern cloud-first stack centered around Snowflake, collaborating with data analysts, UX designers and software engineers to deliver reliable, scalable and well-governed data solutions. This role requires both deep technical expertise and the ability to translate complex Finance data requirements into clean, production-grade engineering.

Work Mode: remote

Duration of the project: 1 year (with possibility of extension)

Job Responsibilities

• Data Engineering & Architecture: Design, build, and maintain scalable ETL/ELT pipelines to ingest, transform, and deliver Finance data from multiple source systems into Snowflake.
  Implement data blending strategies to consolidate data across heterogeneous sources (ERP systems, flat files, APIs, databases) into unified, trusted datasets. Apply Snowflake-native capabilities: dynamic tables, streams, tasks, materialized views, data sharing, and time travel. Model data using dimensional and modern approaches (e.g. Data Vault, medallion architecture) appropriate to Finance use cases. Ensure data quality, consistency, and lineage through robust testing and monitoring practices. Optimize query performance and cost efficiency within Snowflake

• Pipelines & Orchestration: Build and maintain data pipelines using orchestration tools such as Apache Airflow, dbt, or equivalent. Implement CI/CD practices for data pipelines using GitHub Actions or similar, ensuring version-controlled, reviewable, and deployable data code. Monitor pipeline health, set up alerting, and own incident resolution for data failures

• Backend & API Development: Design and develop RESTful APIs to expose Finance data to internal web applications and downstream consumers. Collaborate with frontend and full-stack developers to define data contracts and ensure reliable, performant backend integration. Implement authentication, authorization, and data access governance appropriate for sensitive Finance data

• Cloud & Infrastructure: Work within cloud environments (AWS) and apply cloud data warehouse best practices around security, scalability, and cost management. Contribute to infrastructure-as-code practices where relevant (Terraform or equivalent). Champion data security and compliance standards, particularly around financial data sensitivity and regulatory requirements.

• Collaboration & Standards: Partner with Finance domain experts and analysts to understand data needs and translate them into technical solutions
  Contribute to and enforce data engineering standards, documentation, and best practices across the team. Mentor junior engineers and act as a technical reference point within the domain.
  

Expectations

• 5+ years of experience in data engineering, with at least 2 years working extensively with Snowflake in a production environment

• Strong hands-on experience with ETL design, data blending, and complex data transformation logic

• Proficiency in SQL (advanced level) and Python for data engineering tasks

• Experience building and maintaining data pipelines with orchestration tools (Airflow, dbt, Prefect, or similar)

• Solid understanding of cloud data warehouse concepts: partitioning, clustering, materialized views, query optimization, and cost governance

• Experience working with Finance data (general ledger, cost center structures, P&L, FP&A, or similar domains) is a strong advantage

• Proficiency with GitHub for version control, branching strategies, and collaborative code review

• Experience developing and documenting backend REST APIs

• Familiarity with CI/CD pipelines for data workloads

• Nice to Have: Experience with SAP (S/4HANA, BW4) or other ERP source systems as data origins. Knowledge of data governance frameworks and metadata management tools (e.g. Collibra, DataHub). Exposure to Snowflake's data sharing and Marketplace capabilities. Familiarity with dbt (data build tool) for transformation and testing. Understanding of dimensional modeling. Experience in regulated industries (pharma, finance, life sciences)
  

We offer

• Ongoing support from a dedicated agent, taking care of your project continuity, client contact, necessary formalities, work comfort and development

• Consultant Development Program – advice on growth planning based on the latest trends and market needs in IT, including consultations with agents and growth mentors

• Access to 7N Learning & Development – a development and educational platform with webinars, a library of articles and industry reports, and regular invitations to one-time and recurring development events – technical, business, and lifestyle

• Spectacular integration events, both for you (e.g., annual Kick-Off trip, Christmas parties, or Summer Olympics sports events) and for your loved ones (e.g., family picnics, movie premieres)

• Professional development not only during the project – you can get involved in knowledge transfer to others within the 7N Services offering directed at 7N clients

• Relationships and access to the knowledge of the most experienced IT experts in the market – the average professional tenure of our consultants in Poland is over 10 years

• A complete benefits package, including funding for medical care, life insurance, sports cards for you and your loved ones, as well as discounts in stores in Poland and abroad

About 7N

Constantly searching for projects, difficult rate negotiations, lack of development support – sounds familiar? At 7N, you gain not only stability of contracts but also the personal involvement of a dedicated agent who ensures your professional comfort and continuous access to development initiatives.

Our mission is to provide stable and rewarding collaborations that drive your success as an IT expert and the success of our clients. We build long-lasting relationships based on Scandinavian values and 30 years of experience creating IT solutions for over 200 organizations.