Data Analytics Engineer

Company Description

Take a seat on the Xplor rocketship and join us as a Data Engineer to help people succeed across the world.

We are a global team of builders, listeners, and problem solvers who are relentlessly focused on simplifying life, thus enabling our customers to focus on developing their business, engaging consumers, and pursuing their passions.

Job Description

Overview

As part of the global data engineering team and reporting to the Data and Analytics Manager, this role has a primary focus on contributing to our enterprise data warehousing and reporting deliverables.
Responsibilities include designing, creating, and maintaining business intelligence assets and reports that drive innovation, client value, and business efficiency.

This position will involve working with our largest business units, therefore experience with multi-terabyte database systems is required.

Key Responsibilities

The primary tasks, duties, and responsibilities are:

• Maintaining and enhancing reporting and Power BI solutions.
• Producing reporting stored procedures via T-SQL scripting and DAX.
• Data Modelling and Transformation design.
• ELT development.

• Contribute to cloud migration and ensure system uptime for data warehouse products.
• Participate in Agile work planning, testing, and quality assurance.

Qualifications

Technical Skills

• Experienced level knowledge - Business Intelligence/reporting tools including Microsoft SQL, SRSS, SSIS, SSAS, Power BI, DAX.
• Proficient at designing and implementing effective data models and Extract, Transform, Load () processes slowly changing dimensions for transforming and loading data into the data warehouse.
• Experience incorporating data from various relational systems (e.g., MySQL, Postgres, etc.), flat-file, API, and No-SQL sources.
• Understanding of data governance practices, data lineage, and data quality management to ensure accurate, consistent, and reliable data.
• Familiarity with cloud base tooling – Snowflake, DBT or Coalesce, Fivetran.

Education/Qualifications

• BA/BS degree in Computer Science, Computer Engineering, or related field, or equivalent practical experience.
• Preferred Qualifications include:
  • Expertise in parallel processing warehouses (Snowflake/Redshift),
  • high-frequency differential ETL processes,
  • and Agile development methodology.

Additional Information

Ready to apply?

To start your application, please submit your resume and we'll reach out as soon as possible. Please include the word "moonshot" at the top of your message to the Hiring Manager so that we know you took the time to read our job advertising.