Senior Data Engineer (part-time) (IR-523)

Intellectsoft is a software development company delivering innovative solutions since 2007. We operate across North America, Latin America, the Nordic region, the UK, and Europe.We specialize in industries like Fintech, Healthcare, EdTech, Construction, Hospitality, and more, partnering with startups, mid-sized businesses, and Fortune 500 companies to drive innovation and scalability. Our clients include Jaguar Motors, Universal Pictures, Harley-Davidson, and many more where our teams are making daily impactTogether, our team delivers solutions that make a difference. Learn more at www.intellectsoft.net/

Requirements

4+ years of professional experience in data engineering
Experience with PostgreSQL and SQL
Data warehouse schemas: bronze, silver, gold, semantic, governance
Power BI as the reporting and dashboarding layer
Power BI Apps, Deployment Pipelines, 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

Nice-to-have:

Experience with healthcare operational reporting
Experience building management cockpit, executive KPI, churn risk, client retention, or operational alerting datasets
Experience supporting action-tracking workflows or writeback patterns using Power Apps, Power Automate, Dataverse, or SharePoint staging
Experience with orchestration tools such as Airflow, dbt, Dagster, Prefect, cron-based jobs, or cloud-native schedulers

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

Benefits

Awesome projects with an impact
Udemy courses of your choice
Team-buildings, events, marathons & charity activities to connect and recharge
Workshops, trainings, expert knowledge-sharing that keep you growing
Clear career path
Absence days for work-life balance
Flexible hours & work setup - work from anywhere and organize your day your way

Senior Data Engineer (part-time) (IR-523)

Key Skills

Related Jobs

Senior iOS Software Engineer

Back End Java Developer

Back End Java Developer

Related Jobs

Senior iOS Software Engineer

Back End Java Developer

Back End Java Developer

Cookie Settings