Data Factory Specialist
In this role you will focus on the technical implementation of data products, working with data vault models to create scalable, performant data products that serve specific business requirements. Partner with data architects, business analysts, and stakeholders to translate business needs into technical solutions while ensuring data products follow industry best practices and organizational standards.
Tasks & Responsibilities
- Technical Data Product Development
- Convert complex data vault models (hubs, links, satellites) into optimized dimensional models (star/snowflake schemas) based on business requirements.
- Optimize data transformations, queries, and data product performance to meet service level agreements.
- Build and maintain ETL/ELT processes that transform data vault structures into consumable data products.
- Develop robust, maintainable code for data product backends following best practices.
- Business Requirements Translation
- Analyze business requirements to understand data needs and translate them into technical data product specifications.
- Work with data modelers and business colleagues to understand existing data vault models and identify optimal transformation approaches.
- Create efficient dimensional schemas that support business analytics while maintaining data integrity and performance.
- Ensure data products are ready for consumption by analytics tools and applications while following security and compliance frameworks.
- Data Product Engineering and Maintenance
- Write clean, efficient, and well-documented code for data product backends, ensuring this can be expose in our EDGC tool.
- Implement comprehensive testing strategies including unit tests, integration tests, and data quality validations.
- Manage deployment pipelines and implement CI/CD practices for data product releases.
- Implement monitoring solutions and troubleshoot technical issues in data product systems.
- Documentation: Create and maintain technical documentation for data products.
Requirements
- Bachelor's or Master's Degree in Computer Science, Software Engineering, Data Engineering, or a related technical field.
- 4-6 years of professional experience in backend development, data engineering, or data warehouse development roles.
- Data Modeling Expertise:
- Deep understanding and expert-level knowledge of data vault modeling principles (hubs, links, satellites) and dimensional modeling techniques, including star schema and snowflake schema design.
- Ability to design scalable, maintainable, and high-performance data product architectures.
- Cloud Data Platforms and Tools:
- Extensive hands-on experience with cloud data platforms such as Snowflake, AWS, and BigQuery.
- Proficiency with data transformation tools like DBT and orchestration tools such as Apache Airflow for managing complex data pipelines and workflows.
- SQL and Query Optimization:
- Advanced SQL skills, including complex query optimization, cost-performance tuning, and data transformation.
- Proven ability to optimize data transformations and query performance for large-scale systems.
- Technical Development and Automation:
- Strong backend development experience with a focus on data processing, transformation, and automation.
- Knowledge of CI/CD pipelines and deployment automation to streamline workflows.
- Data Governance and Compliance:
- Familiarity with data cataloging, metadata management tools, and implementation of data governance and regulatory compliance standards.
- Strong analytical and troubleshooting skills for resolving complex technical issues.
- Ability to translate business needs into technical implementations and collaborate effectively with business analysts and stakeholders.
- Excellent English communication skills for technical documentation, stakeholder collaboration, and cross-functional teamwork.
#IamBoehringerIngelheim because…
We are continuously working to design the best experience for you. Here are some examples of how we will take care of you:
- Flexible working conditions
- Life and accident insurance
- Health insurance at a competitive price
- Investment in your learning and development
- Gym membership discounts
If you have read this far, what are you waiting for to apply? We want to know more about you!