SQL Data Analyst

2 weeks ago

Winnipeg, Canada LotLinx, Inc. Full time

**Role Details**:
LotLinx is a leading automotive SaaS data company, we build AI-powered technology to provide clients with end-to-end Vehicle Management and Marketing Systems. We are looking for an experienced Data Analyst to work on internal analysis and customer facing products.

This is an exciting, collaborative and challenging position that will involve significant analysis, problem solving and critical thinking skills. You will work with massive automotive industry datasets that include supply, demand, Google Analytics, marketing, customer behavior and industry trends to create analytical models that are used by thousands of clients to automatically optimize their inventory strategies and advertising across dozens of marketing channels.

**What you’ll do**:

- Work closely with our Data Engineering, Data Analytics and Machine Learning teams on complex customer facing projects
- Work with and maintain multi-terabyte, complex data sources
- Define, collect, study and manage the data used to power our SaaS products
- Report writing and visualization for internal and external stakeholders
- Compile, analyze, validate and transform data using data validation and statistical methods
- Interpret data and analyze results using statistical techniques
- Support databases and processes
- Proactively implement data standards, guidelines on data ownership, coding structures

**What we’re looking for**:

- Team player - this is a cross-functional role that works directly with multiple teams
- Proven ability to work independently and proactively with little supervision
- 3+ years of advanced SQL experience including:

- Extensive use of advanced features (CTEs, UDFs, SPs, recursion, window & geospatial functions)
- Optimizing SQL for multi -terabyte datasets
- Indexing, partitioning, sharding, clustering strategies
- Data Architecture and Warehousing experience
- Experience with visualization technologies such as Looker or Google Data Studio
- Excel and/or Google sheets experience
- Familiarity with Data Engineering best practices
- A strong combination of analytical skills, intellectual curiosity, and reporting acumen
- Ability to take ambiguous requirements from conception to production

**Stand-out Experience**:
We know a lot of experience is transferable and that great team members can learn anything but these are some specific things that would make you really stand out.
- Working experience as a software developer
- Extensive BigQuery experience including using nested repeating structs
- Experience working with raw GA360 data
- Python or R experience
- In depth knowledge of Google Analytics
- Experience with Data Engineering tools like Airflow, Kafka, Dataflow
- Experience working with Automotive industry data and general industry knowledge
- Experience working on advertising focused products
- Experience analyzing data from third-party providers such as Google Ads or Facebook advertising etc
- Degree in mathematics, statistics, or business, with an analytics focus

**About LotLinx**:
LotLinx is the best-in-class, AI-powered Inventory Management solution for the automotive industry. LotLinx uses advanced machine learning technology to help vehicle sellers analyze shopper data, identify high intent purchasers, and execute inventory-specific strategies to reduce days on lot and improve margin per vehicle.

  • Senior SQL Systems Analyst

    1 week ago

    Winnipeg, Canada Randstad Canada Full time

    We are seeking a Senior SQL Analyst to join our client's team. We need a highly skilled and adaptable professional to support a diverse range of technology-driven projects across our organization. This is a dynamic role where you'll apply your expertise in a fast-paced environment, working with various teams and leaders to deliver successful...

  • Data Analyst

    2 days ago

    Winnipeg, Canada Cabela's Full time

    **Summary**: Reporting to the E-commerce & Data Analytics Manager, the Data Analyst is responsible for the analysis of omnichannel sales, performance, and behavioral data. This position will require a technical skillset that includes daily use of SQL, DAX (Microsoft Power BI), and Python. This role requires an entrepreneurial outlook as we continue to find...

  • Data Migration Analyst/ms SQL

    1 week ago

    Winnipeg, Canada Buzzclan Full time

    **Job Title: -** Data Migration Analyst **Responsibilities: -** - Engage on multiple data migration/transformation client initiatives - Design test strategy, including data reconciliation strategy and perform data validation post migration to ensure successful transfer - Collaborate with IT and business stakeholders on a regular basis to understand...

  • Data Analyst

    5 days ago

    Winnipeg, Canada GoDigi InfoTech Full time

    **Role: Data Analyst** **Openings: 10+ hiring's** **Location: - Winnipeg, MB** **Model: - Remote** **Salary: - c2c Pay: $65 CAD** **Skill: Advanced English** **Basic Requirements**: - Senior Data Analyst with 10+ years' experience - Data Profiling Expertise - Data Modeling Experience - MDM Experience - Able to write data integration specifications -...

  • Data Analyst

    2 weeks ago

    Winnipeg, Canada Canada Life Full time

    Join to apply for the Data Analyst role at Canada Life Join to apply for the Data Analyst role at Canada Life Get AI-powered advice on this job and more exclusive features. Permanent Full TimeWe are looking for aData Analyst, Internal AuditIt’s an exciting time to join Internal Audit at Canada Life. As we continue to enhance our capabilities delivering...

  • Data Analyst

    3 weeks ago

    Winnipeg, Canada Canada Life Full time

    Join to apply for the Data Analyst role at Canada LifeJoin to apply for the Data Analyst role at Canada LifeGet AI-powered advice on this job and more exclusive features.Permanent Full TimeWe are looking for aData Analyst, Internal AuditIt’s an exciting time to join Internal Audit at Canada Life. As we continue to enhance our capabilities delivering...

  • Data Migration Analyst/ms SQL

    2 weeks ago

    Winnipeg, Canada Buzzclan Full time

    **Job Title: -** Data Migration Analyst **Responsibilities: -** - Engage on multiple data migration/transformation client initiatives - Design test strategy, including data reconciliation strategy and perform data validation post migration to ensure successful transfer - Collaborate with IT and business stakeholders on a regular basis to understand...

  • Data Analyst

    5 days ago

    Winnipeg, Canada Western Canada Lottery Corporation Full time

    Western Canada Lottery Corporation (WCLC) is looking for a fulltime **Data Analyst - Corporate Insights & Analytics, **to join our team in Winnipeg, Manitoba. To support our strategic vision to “Lead with Data”, we’re transforming our culture, ways of working, systems, tools and processes toward developing and making fact-based and data-driven...

  • Business Intelligence Data Analyst

    2 weeks ago

    Winnipeg, Canada Compugen Inc Full time

    **Job Title** - Business Intelligence Data Analyst **Vacancy No** - VN6028 **Work Location** - Winnipeg, MB **Job Details** **Title: Business Intelligence Data Analyst** **Location: Winnipeg, MB** **About Compugen** Compugen is one of Canada's largest privately-owned Information Technology (IT) Solution Providers. We help customers design, acquire,...

  • Data Analyst — Quality Metrics

    1 week ago

    Winnipeg, Canada Smartrend Manufacturing Group (SMG) Full time

    A leading manufacturing company in Manitoba is seeking a Data Analyst to drive improvements in business processes through data management systems and quality metrics analysis. The ideal candidate will have a Bachelor's degree in a relevant field, experience with data analysis tools like Power BI and SQL, and strong analytical skills. This role offers a...