Job Description, Responsibilities & Requirements
About the Position
We are seeking a highly experienced Data Warehouse Subject Matter Expert (SME) to lead the design, implementation, and governance of enterprise data warehousing solutions. The ideal candidate will bring deep expertise in ETL processes, data architecture, and regulatory data controls, ensuring scalable, high-quality, and compliant data solutions.
Responsibilities
-
Data Warehouse Architecture & Design
- Lead the design and evolution of enterprise data warehouse architecture
- Provide expertise on Db2 environments and ensure optimal database performance, scalability, and reliability
- Define and implement data modelling standards (conceptual, logical, and physical models)
-
ETL Development & Optimization
- Oversee design and development of ETL processes using Informatica, Talend, or similar tools
- Ensure efficient data integration, transformation, and loading across multiple systems
- Optimize SQL queries and ETL workflows for performance and scalability
-
Batch Processing & Data Flow Management
- Govern and monitor batch data flows and scheduling processes
- Perform and guide data lineage analysis, ensuring full traceability of data across systems
- Conduct impact analysis for system or data changes, identifying downstream dependencies
-
Data Governance & Regulatory Compliance
- Define and implement regulatory data controls aligned with compliance requirements
- Ensure data quality, consistency, integrity, and auditability across the data landscape
- Support enterprise data governance frameworks, policies, and controls
-
Leadership & Stakeholder Engagement
- Act as a Subject Matter Expert (SME) for data warehouse and data engineering initiatives
- Provide technical leadership and mentoring to data engineers and ETL developers
- Collaborate with business, IT, and regulatory stakeholders to align data solutions with organizational needs
Requirements
-
Must have
- Extensive experience with ETL tools such as Informatica, Talend, or equivalent
- Strong proficiency in SQL and advanced data transformation techniques
- Deep expertise in data modelling and data warehouse design principles
- Hands-on experience with Db2 databases and enterprise data warehouse architecture
- Strong understanding of batch processing, job scheduling, and data pipelines
- Proven experience in data lineage, impact analysis, and metadata management
- In-depth knowledge of regulatory requirements and data controls in enterprise environments
-
Nice to have
We Offer
- Relocation options
- Experience in an international environment
- Cross-cultural experience
- Feedback culture
- Regular appraisals
- Annual holiday - 20 or 26 days (depending on seniority)
- Occasional leave - 1 or 2 days (depending on circumstances)
- Child care leave - 2 days or 16 hours per year
- Absence due to force majeure - 2 days or 16 hours per year
- Maternity Leave - 20 weeks
- Parental Leave - 41 weeks
- Paternity Leave - 14 days
- Expert-led tech courses
- Internal instructor-led soft skills courses
- Comprehensive in-house self-learning resources
- Access to external self-learning libraries
- Cloud Programs: MS Cloud Academy, AWS Partner Academy, Google Cloud Academy
- Custom Learning Programs: upskilling, reskilling, technical mentorship
- Leadership Programs for Managers
- Multisport card
- LuxGood Program: wellbeing seminars, contests, relaxation sessions, yoga sessions, etc.
- One Team Program: Buddy for each New Joiner; seminars, meeting and workplace space to support integration with local community and culture; “Hire me” workshops for partners
- Preferential banking offer
- Preferential car leasing offer
- Cafeteria program discounts
- Luxoft Social Benefit Fund: sport and recreation benefits
- Private Healthcare Insurance with unlimited access to specialists
- Full dental support
- Travel Insurance
- Possibility to add private healthcare coverage for family members at the corporate rate
- Life insurance at the corporate rate for employees and family members
- Reimbursement for corrective glasses
- Fun social activities organized by the Luxoft team
- Online entertainment events for the whole company and local team events
- A workplace where you’re treated with respect within a multicultural team
- Rotation between projects and accounts
- New career opportunities
About the Company
Luxoft is a global provider of digital transformation services, empowering businesses to innovate and thrive in the digital age. With a focus on delivering cutting-edge solutions, Luxoft combines deep industry expertise with advanced technology to drive success for its clients.
Application
Apply for Data Warehouse SME in Remote Poland
*Indicates a required field
*The acquisition of rights to the above benefits depends on the form of cooperation. Benefits apply to those employed under a contract of employment.
**Please note that relocation is not available for all open positions. At Luxoft Poland it is possible to work remotely only from the territory of Poland.
***Options offered by the Polish government.