Senior Data Engineer
New
I
IntellectsoftSoftware Development
UkraineFull-TimeSenior
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 4+ years
- Required Skills
- PostgreSQLSQLETLMicrosoft Power BIData modeling
Requirements
- 4+ years of professional experience in data engineering
- Experience with PostgreSQL and SQL
- Knowledge of data warehouse schemas: bronze, silver, gold, semantic, and governance
- Power BI as the reporting and dashboarding layer
- Experience with Power BI Apps, Deployment Pipelines, and Paginated Reports
- Power Apps / Power Automate integration for action writeback
- ETL/ELT ingestion from ERP, CRM, production, budget, quality, catalog, and organization systems
- Data quality SQL assertions and acceptance testing
- Scheduled daily and hourly refresh pipelines
- Role-based access and secure semantic reporting views
Responsibilities
- Design, build, and maintain the reporting data warehouse using a layered model: bronze, silver, gold, semantic, and governance.
- Build reliable ELT/ETL pipelines from ERP, CRM, production, budget, quality, catalog, and organization data sources.
- Develop and optimize SQL transformations for daily facts, conformed dimensions, KPI views, cohort analytics, client 360 views, alerting views, and operational dashboards.
- Maintain semantic views used by Power BI reporting, ensuring business users only access approved reporting layers.
- Implement data quality checks, freshness validation, reconciliation tests, and SLA monitoring.
- Support daily and hourly refresh pipelines, including incremental refresh logic for operational order and production data.
- Implement governance, role-based access, and secure data access patterns for group, lab, clinic, owner, and user-level visibility.
- Partner with BI developers to ensure Power BI reports are backed by clean, stable, documented semantic datasets.
- Collaborate with business stakeholders to validate KPI definitions, reporting grain, ownership logic, and actionability of alerts.
- Maintain documentation for data lineage, metric definitions, pipeline runbooks, and acceptance tests.
View Full Description & ApplyYou'll be redirected to the employer's site
