Job Expired

This posting has expired and applications are no longer being received and this job does not show up on the main job list.

Data Integration and Operations Engineer

by J.D.Power/Autodata Division

Location: London, ON
Date Posted: May 30, 2023
J.D.Power/Autodata Division

Job Description


Data Integration and Operations Engineer

The Role

As a Data Operations & Integration Engineer within J.D. Power’s Data & Analytics unit you will be responsible for the development and routine maintenance of data transformation & reporting processes that support the Power Information Network’s ability to provide near real-time market intelligence and unparalleled transparency to the retail automotive landscape.

Impact

This is an important developmental position as the database plays a crucial role in transforming PIN transactional data into digestible information for key decision-makers within automotive manufacturers, suppliers, dealer groups and industry analysts. Supporting this operation will provide opportunities to participate in ad hoc data/ industry analysis and new business development activities in addition to standard data operations

Responsibilities

  • Ensure accuracy & integrity of data & applications through analysis, coding & problem resolution
  • Provide ongoing maintenance of legacy platforms and upgrades to next generation to enhance capacity, capabilities, and efficiency. Includes development of data pipelines from on-premises (SQL Server) to cloud-based storage locations (GCP)
  • Re-engineering existing Excel & SAS based reports to a more robust & fully automated reporting solution
  • Analyze & translate functional specifications into technical specifications.
Qualifications
  • Master’s degree and 3+ years’ work experience with related technologies (preferred)
  • Bachelor’s degree and 7+ years’ work experience
  • Solid technical competency, general programming skills
  • Excellent problem-solving & troubleshooting skills
  • Strong communication skills
  • Database experience and programming in SQL, T-SQL or PL/SQL (required)
  • Demonstrated expertise in building pipelines and transformations in AWS / Google cloud platforms
  • Experience with Talend, SSIS or related data integration tools
  • Experience with SSRS, Eclipse BIRT reporting tools (desired)
  • Demonstrated expertise with SAS, Python & Advanced Excel data analysis tools (desired)

The Career Opportunity

This role will allow you to hone your technical skills while developing a foundational knowledge of the PIN business model, enabling career growth opportunities within IT, analytics, operations and modeling teams.

The Team / The Business

As a data integration engineer you will work with a group of talented database professionals and collaborate with members of modeling, statistics, operations and consulting teams who support multi-billion-dollar decisions across a multitude of clients.

J.D. Power is a global leader in consumer insights, data, analytics, and advisory services that helps clients drive growth and profitability. The company’s industry benchmarks and reputation for independence and integrity have established it as one of the world’s most well-known and trusted brands.

Our Hiring Manager says: “I’m looking for the kind of person who thrives on tackling difficult problems in a dynamic and fast-paced environment. If you’re right for this role, you will enjoy the challenge of working with large, complex, and dynamic datasets and thrive on the ability to broaden your skill set via collaboration with industry experts.”

J.D. Power is a global leader in consumer insights, advisory services and data and analytics. A pioneer in the use of big data, artificial intelligence (AI) and algorithmic modeling capabilities to understand consumer behavior, J.D. Power has been delivering incisive industry intelligence on customer interactions with brands and products for more than 50 years. The world's leading businesses across major industries rely on J.D. Power to guide their customer-facing strategies.

Company Mission

J.D. Power is?clear about what we do to ensure our success into the future. We unite industry leading data and insights with world-class technology to solve our clients’ toughest challenges.

Our Values

At J.D. Power, we strive to be Truth Finders, Change Makers and Team Driven - the distinct behaviors that, together, define our unique culture.

Truth Finders - At J.D. Power, we are proud of the unbiased data and findings we provide. As individuals,?each and every?member of our team is dedicated to living this same objectivity and embodying the highest ethical and professional standards – the only ‘favorite’ we have is the truth

Change Makers - At J.D. Power, we never stand still. We constantly seek better ways – innovating and evolving in everything we do to support our colleagues and our clients alike – and all in service of delivering data and insights that drive meaningful business impact.

Team Driven -?At J.D. Power, we are one?team?and we are activated. Regardless of individual role, every member of our team is dedicated to supporting their immediate colleagues and our broader J.D. Power family to deliver on our collective purpose and make us greater than the sum of our parts.?At J.D. Power, these values are more than words. We bring these values to life throughout our organization through our employee event series — J.D. Power Values Days. Each quarter, we celebrate one of our core values and hold an annual event to celebrate our combined values at the end of the year.

We are dedicated to leveraging comprehensive and equitable practices which contribute to the overall success of the company and its employees. We invite you to learn more about our DE&I efforts.



J.D. Power is an equal opportunity employer and compliant with AODA/ADA legislation.? If you require?accommodations?during the recruitment and selection process, please specify.?

 

Apply for this Job