Icon hamburger
US
What job do you want?
Apply to this job.
Think you're the perfect candidate?
Apply on company site
Thumsup

You’re being taken to an external site to apply.

Enter your email below to receive job recommendations for similar positions.
Default1

Data Engineer

Advance Auto Parts Raleigh Full-Time
$98,759.00 (Careerbuilder est.)
Apply on company site


Job Description

The Data Engineer is responsible for aggregating data from various systems into a central data lake and warehouse to be used for statistical analysis, reporting, and dashboards.

This position will utilize modern cloud data warehouse technology and works with both unstructured and structured data. This is not a traditional data warehouse position and will not involve traditional schema-based relational database design. The successful candidate will have an understanding of cloud data warehouse technology, as well as how to organize and store data for use with advanced analytics.

Responsibilities:

  • Maintain, support, and enhance the business intelligence data backend, including data warehouses and data lakes.
    • Performs needed assessments
    • Implement data transformations and data structures for data warehouse and lake/repository.
    • Manage cloud and/or on-premises solutions for data transfer and storage.
    • Establish data structures for all enterprise data stored in business intelligence systems.
  • Collaborate and work with data analysts in various functions to ensure that data meets their reporting and analysis needs.
    • Establish interfaces between the data warehouse and reporting tools, such as PowerBI.
    • Assist data analysts with connecting reporting and analytics software to data warehouses, lakes, and other data sources.
    • Manage access and permissions to data.
  • Provide technical guidance for design and implementation of data governance systems and policy.
    • Work with the data governance team to manage an enterprise wide data governance framework, with a focus on improvement of data quality and the protection of sensitive data through modifications to organization behavior policies and standards, principles, governance metrics, processes, related tools, and data architecture.
    • Monitor data quality, identify data quality issues, oversee remediation plans, implementation of data controls, and manage data quality remediation strategies. Define data quality strategy and participate in a data quality working group.
    • Oversee and ensure that new systems implemented at the enterprise level follow data quality guidelines.
  • Keeps abreast of new business intelligence technologies; makes periodic recommendations for overall improvements

Qualifications 

Bachelor’s Degree plus at least 7-10 years of experience managing data warehouse and/or business intelligence systems. An advanced degree or certifications in a related field is a plus.

Knowledge, Skills & Abilities:

  • Demonstrated experience with setting up data structures (tables and views) for use with modern analytics software.
  • Expertise with Snowflake Data Warehouse, Amazon Web Services, SQL-based database systems, and/or other enterprise data warehouse solutions.
  • Experience working with integration tools such as APIs, Web Services, JDBC/ODBC connectors, and other integration technologies.
  • Solid experience working with programming languages used in ETL and/or ELT environments, such as SQL and Python.
 

Recommended skills

Business Intelligence
Data Quality
Data Governance
Data Warehousing
Data Architecture
Dashboard

Location

CareerBuilder Estimated Salary

This estimation is based on Job title, Industry, Location and Skills
$98,759
Avg. Yearly Salary
Apply to this job.
Think you're the perfect candidate?
Apply on company site

Help us improve CareerBuilder by providing feedback about this job: Report this job

Report this Job

Once a job has been reported, we will investigate it further. If you require a response, submit your question or concern to our Trust and Site Security Team

Job ID: R-57529

CAREERBUILDER TIP

For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using CareerBuilder you are agreeing to comply with and be subject to the CareerBuilder Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.