Data Engineer Intern

Lensa • Internship • Alpharetta, GA, US • 1d ago

Lensa is a career site that helps job seekers find great jobs in the US. We are not a staffing firm or agency. Lensa does not hire directly for these jobs, but promotes jobs on LinkedIn on behalf of its direct clients, recruitment ad agencies, and marketing partners. Lensa partners with DirectEmployers to promote this job for RELX. Clicking "Apply Now" or "Read more" on Lensa redirects you to the job board/employer site. Any information collected there is subject to their terms and privacy notice.

Within EDI we have a lot of data refreshes running in Azure using Data factory (DF) pipelines. These pipelines copy data into our Synapse data warehouse. The data in the data warehouse is used for presenting and providing insights in PowerBI dashboards. To facilitate this the data is copied from the warehouse into datasets in PowerBI workgroups. To update the data in these datasets, refreshes can be scheduled in PowerBI. This process is error prone, and we run in situations where data isn't yet updated in the warehouse or where the refresh runs at the same time data is updated which can cause failed refreshes.

Scope

The project scope encompasses working with the designated EDI personnel and PowerBI team to accomplish the following:

Build integration between Azure Data Factory and PowerBI API.
Securely authenticate ADF with the Power BI REST API using appropriate methods like Managed Identities or Service Principals.
Implement robust error handling in ADF pipelines to handle potential failures in API calls or data loading processes.
Design ADF pipelines for scalability to handle large datasets and frequent refreshes without performance bottlenecks.
Occasional on-site work at Alpharetta during business hours (8am-6pm ET) preferred
Approximately 10 hours per student required weekly

Skill Set

Proficiency in Azure, preferably Azure Data Factory
Experience in Python programming
Proficiency in PowerBI API client and Synapse is a pre.
Innovative and creative mindset
Excellent documentation and communication skills as this needs cross team alignment.
Ability to organize tasks into milestones and successfully execute to project completion
Can work independently with little direct supervision

We are committed to providing a fair and accessible hiring process. If you have a disability or other need that requires accommodation or adjustment, please let us know by completing our Applicant Request Support Form or please contact 1-855-833-5120.

Criminals may pose as recruiters asking for money or personal information. We never request money or banking details from job applicants. Learn more about spotting and avoiding scams here .

Please read our Candidate Privacy Policy .

We are an equal opportunity employer: qualified applicants are considered for and treated during employment without regard to race, color, creed, religion, sex, national origin, citizenship status, disability status, protected veteran status, age, marital status, sexual orientation, gender identity, genetic information, or any other characteristic protected by law.

USA Job Seekers

EEO Know Your Rights .

RELX is a global provider of information-based analytics and decision tools for professional and business customers, enabling them to make better decisions, get better results and be more productive.

Our purpose is to benefit society by developing products that help researchers advance scientific knowledge; doctors and nurses improve the lives of patients; lawyers promote the rule of law and achieve justice and fair results for their clients; businesses and governments prevent fraud; consumers access financial services and get fair prices on insurance; and customers learn about markets and complete transactions.

Our purpose guides our actions beyond the products that we develop. It defines us as a company. Every day across RELX our employees are inspired to undertake initiatives that make unique contributions to society and the communities in which we operate.

If you have questions about this posting, please contact support@lensa.com