Highlights
Develop scalable solutions, collaborate across teams, and contribute to mission-driven initiatives.
Description
Job Summary
pWe are seeking a skilled and experienced Data Engineer to join our dynamic team at IntegriChain. As a key member of the data engineering team, you will be responsible for developing scalable data pipelines using tools like dbt and Python, implementing robust data orchestration solutions, and collaborating with cross-functional teams to ensure accurate and timely data delivery.
Responsibilities
- Develop and maintain scalable data pipelines using dbt, Python, or other ELT tools.
- Implement and maintain scalable data orchestration and transformation to ensure data accuracy and consistency.
- Collaborate with cross-functional teams to understand data requirements and translate them into technical solutions.
- Work closely with data analysts and scientists to provide clean and structured datasets for analysis and modeling.
- Create scalable, complex DBT models and design data orchestration workflows.
Required Skills
- Data Integration (ETL)
- Datawarehouse Development
- SQL Proficiency
- PYTHON Programming
- DBT Experience
Required Skills Explained
- Databases and SQL: Understanding of database structures, queries, and indexing to ensure data accuracy and performance.
- Python or ELT Tools: Proficiency in using Python for data processing or ETL tools like dbt, SSIS, or PowerCenter for data integration tasks.
- Data Orchestration: Experience with building scalable processes that manage the flow of data through different stages from extraction to transformation and loading.
- Dimension/Fact Types 1/2 SCD: Knowledge in Slowly Changing Dimensions (Type 1, 2) to handle changes in historical and current data effectively.
- Data Marts Updates: Ability to keep data marts updated with relevant and timely information for decision-making processes.
- MDM Integration: Expertise in integrating master data management systems to maintain a single version of the truth across multiple databases or applications.
Who is this for
pThis role is ideal for a data-driven professional with a strong background in data engineering and a passion for transforming raw data into actionable insights. If you are a problem-solver who enjoys working on complex projects, this opportunity could be a perfect fit.
Why This Job is a Good Opportunity
ulliImpactful Work: Direct contribution towards improving patients' lives by optimizing market access and patient services for Life Sciences manufacturers.liDiverse Projects: Opportunities to work on complex data pipelines, integrations, and transformations across various stages of the data lifecycle.liLearning and Development: Access to over 700 development courses free of charge to enhance your skill set and stay updated with industry trends.liCareer Growth: A strong foundation in database management and data integration can lead to leadership roles within data analytics or enterprise architecture.
Interview Preparation Tips
- Understand the company’s mission and how it aligns with your career goals.
- Be prepared to discuss your experience with ETL tools, SQL, and Python if applicable.
- Pull examples from previous projects where you demonstrated data orchestration or transformation skills.
- Practice explaining technical concepts in simple terms for a non-technical audience.
Career Growth in This Role
pThe role offers significant opportunities for career advancement as you build expertise in complex data management and integration. You can progress to senior positions such as Data Architect or even lead roles within the organization's data strategy team. The skills gained here are highly sought after across various industries, providing a strong foundation for transitioning into related fields like business intelligence, data science, or cloud engineering.
Explore More Opportunities
Skills
Frequently Asked Questions
What certifications are preferred?Certifications in dbt, Python, or other relevant tools are a plus.
Is there any specific data integration tool preference?Experience with ETL tools like DBT, Python, SSIS, or PowerCenter is preferred.
What benefits does IntegriChain offer?IntegriChain offers excellent medical and non-medical perks including student loan reimbursement, flexible time off, and a 401(k) plan with company match.
