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 & Analytics Engineer

by J.D. Power

Location: London, ON
Date Posted: Jan 25, 2022
J.D. Power

Job Description

Data & Analytics Engineer


The Role:

The Senior Data Developer/Engineer will be part of the core PIN Data & Analytics team and will be responsible for building out our data lake, processing many terabytes of data, and developing efficient ETL pipelines to deliver data and insights to JD Power's internal & external clients. They will also be responsible for the development and routine maintenance of data transformation & reporting processes that support PIN’s ability to provide near real-time market intelligence and unparalleled transparency to the retail automotive landscape.

 This candidate will think innovatively and constantly be seeking to challenge and improve the Data Intelligence & Analytics process and be a part of the larger digital transformation initiatives of the PIN business group delivering critical business solutions to external clients.

This position requires a mindset of continuous integration and continuous delivery to meet the needs of the Business unit.

Drive and Focus of the Role:

  • Responsible for working with full range of data technologies and architectures including big data platforms, data lakes, object stores, logical and physical data warehouses and multiple analytic frameworks and tools
  • Responsible for implementing a modern data platform using technologies such as cloud data technologies that will enable the consumption of different types of data (semi/non-structured) and integration with external and internal data by the analytics team for the purposes of analytical modeling.
  • Enabling a platform with data ingested from on-premise or cloud technologies to connect, ingest, collect and store various types of data, either in batch or streaming and enable the data to be analyzed, visualized and apply advanced intelligence tools like machine learning and predictive modelling
  • Keeping fluent in the industry and marketplace evolution-staying current with vendor product offerings and common and emerging data solutions in use across the industry. Execute proof-of-concept or innovation oriented technical efforts and projects to evaluate options, prove out the viability of new technologies or approaches.
  • This position will work collaboratively with business and technology stakeholders to establish and maintain the enterprise data reporting architecture, strategy and roadmap and will define, document, and apply business rules to enterprise data. This resource will also assist as needed in the design and development of ETL standards, policies, procedures, and metadata to ensure accuracy, quality, integrity, and optimization of this information.
  • Involved in all phases of the development life cycle right from development of data flow, transformation and loading data using optimized data marts, Analytic visualizations, testing, user acceptance, deployment, and post transition support
  • Provide support with ongoing systems development and business intelligence activities within the assigned function(s).
  • Architecting the growing landscape of interconnected systems, builds efficient and well-maintained data flows and ensures proper documentation and up to date systems.
  • Utilizes standard methodologies, define, and govern BI architecture standards, leads, and supports development efforts
  • Provide user support, resolve incidents, and ensure smooth functioning of data warehousing, analytics, and intelligence processes.

What we're looking for:

Experience, Knowledge, & Skills You Bring:

  • 6+ years of IT experience including development of large scale, complex data architectures
  • Proven hands-on experience in advanced SQL & SQL Analytics
  • Experience with Data Virtualization, on prem (MS SQL/ ORACLE/ DB2 etc.) & cloud data warehousing technologies (like AWS/ Snowflake/Azure/Google data cloud platform, Cloud data lakes using big data technologies.
  • Experience in data pipelines connecting with different sources of data using JDBC, ODBC, APIs, XML, JSON, file based, streaming data ingesting technologies
  • Exposure to Data science technologies like Python, JavaScript. Jupyter Notebooks using data science frameworks like Tensorflow, Sagemaker, Spark etc. or frameworks
  • Understanding of data security and compliance
  • Exposure to data visualization tools such as Tableau, Looker, Microstrategy, Qlik etc.


What You’ll Need to Succeed:

  • Ability to adapt to new technologies in the field of data and analytics and data intelligence
  • Creative in problem solving to provide cost effective and scalable solutions
  • Strong team player and interpersonal skills in a multi-national and multi-cultural environment with cross functional and technical teams
  • Willingness to “do what it takes” attitude and self-starter approach with a deep sense of customer/client satisfaction

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. 


To all recruitment agencies: J.D. Power does not accept unsolicited agency resumes and we are not responsible for any fees related to unsolicited resumes. 


Apply for this Job