<h3>Job Description</h3><div>Job Description<div>Position Title: Data AnalystLocation: Remote CanadaReports to: Manager, Strategy & Analytics The Role:The objective of this role is to analyze and process automotive data to meet accuracy, timeliness and completeness guidelines set by the department (which is driven by client demand). The Data Analyst assumes roles and responsibility for tasks related to ongoing improvement of the content group by closely working with our partners to connect tactics to results and recommend future activities. Each Data Analyst is ultimately responsible to ensure the content "Gold Standard".Core Job Duties and Responsibilities:<ul><li>Responsible for developing, testing, improving and maintaining new and existing databases</li><li>Process the most complex and high-profile SQL queries and reports in an extremely timely and accurate manner</li><li>SQL Development</li><li>Perform advanced analyses to understand and explain trends and drivers of key marketing metrics</li><li>Prioritize work assignments to maximize personal efficiency and to meet completion commitments</li><li>This individual is considered a data "go to" person or subject matter expert (SME) for a department function, process or data subset.</li><li>Participate in the development and implementation of departmental policies and controls to ensure data accuracy, security, and compliance with company policies and procedures</li><li>Represent the content department in a professional/consultative manner to other departments</li><li>Act as a positive Role Model for other members of the Data Department</li></ul>Qualifications:<ul><li>Excellent verbal and written communication skills</li><li>Able to work well under pressure and to excel in a constantly changing environment</li><li>Strong self-management and analytical abilities</li><li>Very high accuracy and attention to detail is required and must be demonstrated in decision making and entry of information</li><li>Self-motivated and able to work with a team</li><li>Computer skills – MS office, excel, word</li><li>Post-secondary education would be an asset</li><li>Time management skills, organized and able to meet deadlines</li><li>This role requires flexible hours (including OT) which may at times include early mornings, late nights and weekends</li><li>Experience as a Data Analyst for a minimum of 3 years including SQL Development.</li><li>Relevant experience in business intelligence, research, data analytics, data science, or a related field.</li><li>Advanced SQL skills (PostgreSQL). Optimization of queries of high complexity in large dataset.</li><li>Command of QlikView. Must be adept at crafting stories from your data and insights through reports and visualizations.</li></ul>The Hiring Manager says:"I'm looking for the kind of person who is an ambitious self starter with critical thinking and problem solving abilities."The Way We Work:<ul><li>Leader Led</li><li>Remote First</li><li>Foster Flexibility</li><li>Reward Performance</li><li>Time Off Matters</li></ul>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. J.D. Power is committed to employing a diverse workforce. Qualified applicants will receive consideration without regard to race, color, religion, sex, national origin, age, sexual orientation, gender identity, gender expression, veteran status, or disability. J.D. Power is an equal-opportunity employer and compliant with AODA/ADA legislation. Should you require accommodations during the recruitment and selection process, please reach out to tarecruitment@jdpa.com.  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.  </div></div>

<h3>Job Description</h3><div>Job Description<div>A Data Analyst with Cognos reporting and ETL experience possesses a comprehensive skill set for working with data. They excel in extracting data from various sources, transforming it into usable formats, and loading it into databases for analysis. Additionally, their proficiency in reporting involves creating meaningful visualizations and reports that communicate insights effectively to support informed decision-making. This combination of skills allows them to handle the end-to-end data lifecycle, from collection and preparation to analysis and reporting, making them valuable assets for data-driven organizations.</div></div>

Designing and maintaining data systems and databases. Designing, developing, updating and maintaining Marketing Campaigns to implement new features, correct errors, improve functionality and build new marketing strategies. Mining data from client's primary data source AWS S3 data lake and filtering the data to gather the apt population for marketing as per campaign's intent and requirements. Collaborating with Business analysts, Programmers, Engineers and other Organizational leaders to evaluate campaigns performance, recommend modifications and identify opportunities for improvements. Working on Erwin/ER- Studio, ETL tools like Informatica, SAS, AB initio and Datastage, Databases, Amazon RedShift, Oracle, Tera Data, SQL Server, Hive, Python and SQL programming languages, Pyspark framework in Databricks. Using Statistical tools like Microsoft Excel and Quick sight to interpret data and identify trends and patterns. Must be willing to travel to set up systems to various clients at unanticipated locations across the nation and perform feasibility studies and evaluate user requirements.

Work closely with Global Sourcing Team, Mechanical Engineers, Financial Team, and 3rd Party Suppliers to deep understand the supply chain shortage pains and insights.? Analyze and solve business problems at their root, stepping back to understand the broader context.? Draft a supply chain shortage fulfillment proposal that utilizes the highest standards of analytical rigor and data integrity.? Integrate data from 5 data resources and cleansed messy and incomplete datasets. Build a quantitative model for evaluation and implementation of the existing supply chain shortage crisis.? Build a supervised machine learning date model for predicting patient handling motor failures.? Regularly reporting of key insight trends, using rigor to simplify and inform the larger team of noteworthy storylines (Tableau).? Drive the development of tools, reporting improvements, and automation, and create new innovative and insightful reports.? Write high-quality code to retrieve and analyze data (SQL and Python).

Data Analyst Jobs in Troy, MI

Data Analyst Smartdigital
November 15, 2024

Healthcare Senior Data Analyst
November 15, 2024

Senior Data Analyst
November 4, 2024

Data Analyst
October 30, 2024

Data Analyst
October 30, 2024

Data Analyst
October 27, 2024

Data Analyst
October 27, 2024

Data Analyst
October 26, 2024

Quick filters

Top companies

Data Analyst Jobs in Troy, MI

Data Analyst SmartdigitalNovember 15, 2024

Healthcare Senior Data AnalystNovember 15, 2024

Senior Data AnalystNovember 4, 2024

Data AnalystOctober 30, 2024

Data AnalystOctober 30, 2024

Data AnalystOctober 27, 2024

Data AnalystOctober 27, 2024

Data AnalystOctober 26, 2024

Quick filters

Top companies

Data Analyst Smartdigital
November 15, 2024

Healthcare Senior Data Analyst
November 15, 2024

Senior Data Analyst
November 4, 2024

Data Analyst
October 30, 2024

Data Analyst
October 30, 2024

Data Analyst
October 27, 2024

Data Analyst
October 27, 2024

Data Analyst
October 26, 2024