Expert Data Designer

Project Information:

• Industry: banking

• Location: Poland - Warsaw, Lódź, Gdansk or Gdynia., with possible remote work (2 days per week in the office required).

• Rate: up to 150 PLN/H netto + VAT/B2B

• Summary: The Expert Data Designer will play a crucial role in transforming complex data initiatives into actionable projects. This position focuses on efficient data storage, organization, and quality, ensuring that data architectures meet business needs and function effectively within integrated systems.

Main Responsibilities:

• Break down complex data initiatives into manageable tasks.

• Estimate effort and timeline for data engineering projects.

• Design and implement database schemas that efficiently store and organize data.

• Create data models that accurately represent business entities and relationships.

• Develop and maintain data dictionaries and documentation.

• Design and suggest database performance optimization techniques (indexing, partitioning, etc.).

• Design and implement data validation rules and constraints.

• Design stored procedures, functions, and triggers as needed.

• Establish backup and recovery procedures in cooperation with the development team.

• Implement database security measures and access controls.

• Design and document data ingestion pipelines from various sources.

• Develop data transformation logic to standardize and clean data.

• Implement data quality checks and validation procedures.

• Suggest automated workflows for regular data processing.

• Propose error handling and recovery mechanisms for the database.

• Design message queues and event-driven architecture.

• Ensure data consistency across integrated systems.

• Troubleshoot integration issues and data synchronization problems.

• Document integration points and data flows.

• Collaborate with external teams on integration requirements.

• Identify technical debt and propose solutions.

• Facilitate knowledge sharing sessions and documentation.

• Help define the technical roadmap for data infrastructure.

Key Requirements:

• Experience with data warehousing solutions.

• Data architecture & design.

• Data modeling expertise.

• Proficient in data integration patterns.

• Familiarity with UML (specifically ERD, sequence & component diagrams).

• Understanding of BPMN.

• Data Governance principles & Data quality consciousness.

• Proficiency in database design and management (SQL and NoSQL).

• Knowledge of ETL processes and tools (datastage, informatica, snowflake ETLs).

• Understanding of big data technologies (Hadoop, Spark, etc.).

• CI/CD pipeline knowledge.

Soft Skills:

• Excellent communication skills to explain technical concepts to non-technical stakeholders.

• Collaboration abilities with data scientists, analysts, and business teams.

• Adaptability to learn new technologies and approaches.

• Problem-solving mindset.

• Attention to detail.

• Ability to think systematically about data flows.

• Performance optimization skills.

• Debugging and troubleshooting abilities.

Nice to Have:

• Strong programming skills (particularly in Python, SQL, Java, or Scala).

• Cloud platform expertise (AWS, Azure, GCP).