Website:
unicorn-workforce.com
Job details:
Role - Power Platform
Shift Time : 6:30 pm - 3:30 am IST
Years of Experience - 5 Years
REMOTE
Job Description:
The creation and maintenance of Digital campaigns in DSPs is a manual process with many inputs that are critical to get correct as dentsu is at risk for any errors.
The Automation Engineer will build lightweight automation tools to compare campaign data between internal systems and DSP platforms.
The goal is rapid deployment of a practical QA solution using JavaScript, Power Automate, Power BI, and Excel-based tooling.
Key Responsibilities:
● Develop scripts to extract and normalize data from DSP exports
● Build comparison engines to identify discrepancies for:
○ Geo targeting
○ Audience / Campaign
○ Creative
○ URL / Tagging
● Automate validation workflows using:
○ JavaScript
○ Power Automate
○ Excel macros
● Build Power BI dashboards for discrepancy reporting
● Iterate quickly in sprint cycles
Required Qualifications:
● Bachelor’s or Master’s degree in technical/related field
● 4-5 years related experience in lieu of degree or equivalent combination of education
and experience is required
● 3+ years experience in JavaScript development
● Strong Excel VBA skills
● Experience with Microsoft Power Platform
● Strong communication and interpersonal skills
Nice to Have:
● Experience working with DSP APIs
● Background in digital media buying or ad ops
● Power BI dashboard development experience
_*MUST HAVE -*_
1. Power Apps – Canvas & Model-Driven
Canvas app development
Model-Driven app usage
Responsive design
Power Fx formulas
Componentization and layout logic
2. Dataverse (Core Strength)
Dataverse tables and security
Environment-to-environment data sync
ALM practices
Role-based access
3. Power Automate (Cloud + Desktop)
Large-volume data handling
Performance optimization
Error handling
External system integration
4. Integration & Custom Connectors
REST API integration
OAuth handling
Custom connectors
5. Power BI / Power Query (Supporting Skill)
Power Query vs DAX
Data transformation vs calculations
Click on Apply to know more.