At TDW we put people first - that means working everyday to ensure the pipelines that run through our communities are operating safely and reliably. What sets us apart is our expertise, experience and commitment.

Each day we dedicate ourselves to treating each other, our customers and our community with care and respect.

Overview

As a Database Analyst for T.D. Williamson, your team will be expanding the role of our Enterprise Data Warehouse to promote business intelligence and provide consistent global reporting. You will be responsible for developing high quality extraction/transformation/load (ETL) programs, creating logical and physical data models, entity relationship diagrams and building business intelligence reports using SQL Server, SQL Server Integration Services (SSIS) and PowerBI.

Key Responsibilities

Primary duties may include, but are not limited to:

Design, develop, test, implement and manage complex ETL processes sourcing data from a variety of internal and external systems supporting Manufacturing, Distribution, Sales, Marketing, Finance and Human ResourcesAdvanced knowledge in database and report performance engineering, diagnosing and tuning of ETL programs and reportsAdvanced understanding of data warehouse concepts such as star schemas, snowflake schemas, operational data stores, data warehouses and data martsDesign, develop, maintain and publish logical and physical data models, entity relationship diagrams and a common data dictionaryTrack record of building and maintaining solid relationships with internal and external customers, vendors and peersWorks collaboratively with key business users to understand their information needs and provide high quality, high performing and intuitive data solutionsSelf-motivated, able to work independently and collaboratively with IS peers and managed service providers to identify, understand and analyze complex data in a variety of source systems such as: ERP, WMS, CRM, E-Com, HRMS, etc.Strong organization and prioritization skills. Comfortable creating high level plans, setting dates, making commitments and delivering high quality results on timeComfortable assisting in the design and development of reports, charts and graphsComfortable operating as a subject matter expert, leader and mentor to improve the knowledge, skills and capabilities of DW/BI throughout the companyParticipates in the evaluation of new business intelligence technologies such as data modeling, ETL, appliances, reporting tools and portal solutionsParticipation on-call duties is required

Experience

Bachelor’s degree in computer science, Information Technology, Engineering or related field is strongly preferred; minimum of associate's degree is required3 - 5 years of experience using Microsoft SQL Server Database, SSIS, SSRS is requiredExperience with other relational databases, BI reporting and data discovery tools is highly desirable