T. D. Williamson, Inc.

  • Database Analyst

    Posted Date 2 months ago(2018-10-04 2:55 PM)
    City
    Tulsa
    Position ID
    Position-17238
    State/Province
    Oklahoma
    Country
    United States
  • 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, data flow diagrams, entity relationship diagrams and building business intelligence reports using SQL Server, SQL Server Integration Services (SSIS) and Report Services (SSRS) and PowerBI.

    Responsibilities

    • 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 Resources
    • Advanced knowledge in database and report performance engineering, diagnosing and tuning of ETL programs and reports
    • Advanced understanding of data warehouse concepts such as star schemas, snow flake schemas, operational data stores, data warehouses and data marts
    • Design, develop, maintain and publish logical and physical data models, entity relationship diagrams and a common data dictionary
    • Track record of building and maintaining solid relationships with internal and external customers, vendors and peers
    • Works collaboratively with key business users to understand their information needs and provide high quality, high performing and intuitive data solutions
    • Self-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 time
    • Comfortable assisting in the design and development of reports, charts and graphs
    • Comfortable operating as a subject matter expert, leader and mentor to improve the knowledge, skills and capabilities of DW/BI throughout the company
    • Participates in the evaluation of new business intelligence technologies such as data modeling, ETL, appliances, reporting tools and portal solutions
    • Participation on-call duties is required

    Qualifications

    • Bachelor’s degree in Computer Science, Information Technology, Engineering or related field is strongly preferred; minimum of Associate's degree is required
    • 3 - 5 years of experience using Microsoft SQL Server Database, SSIS, SSRS is required
    • Experience with other relational databases, BI reporting and data discovery tools is highly desirable

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Join our Talent Network!

    We're always looking for great people to join our team. If you didn't see a position that catches your interest please join our Talent Network. This will allow you to self identify your expertise and areas of interest.