• Data Architect Modeler Engineer

    Job Locations US-OK-Oklahoma City
    Location Zip Code
    73128
  • Overview

    Lead and develop the technical transformation of data into revenue generating information in the retail c-store sector. Convert business intelligence strategy into a data warehousing and analytics solution by integrating multiple operational systems, ERP and data from external sources into a single reporting and predicative analytics solution.  

    Duties

    • Proficient writing, troubleshooting and optimizing TSQL/SQL code and stored procedures
    • ETL, integration and data loading
    • Master Data Management MDM
    • Data modeling and cube building
    • Business Objects
    • Data analysis and mapping
    • Data Integration
    • Business Intelligence
    • GIS knowledge
    • Proficient in designing and development of database architecture in an enterprise model
    • Creation and Maintenance of data warehouses and data marts
    • Creating triggers, constraints, functions, views and indexes
    • OLTP and OLAP design and development experience
    • SSRS, SSIS experience
    • Custom report design and development experience
    • Strong understanding of Relational data modeling, entity diagrams, data mapping, profiling, metadata, and relational schema
    • Proactive scaling, tuning and performance optimization
    • Security and disaster recovery options for SQL: mirroring, clustering, and log-shipping
    • Ability to convert summary and/or unstructured data into a SQL environment
    • Develop documentation and full transparency of all database architecture
    • Troubleshooting and root cause analysis
    • Knowledge of both Windows and Linux operating systems
    • Knowledge of big data concepts: data warehousing and data marts
    • Tool experience: Erwin, Tableau
    • On call support
    • SQL Certifications

    Qualifications

     

    PHYSICAL REQUIREMENTS:

     

    Requires extensive sitting, viewing and utilizing computer equipment, keyboarding, listening and speaking with telephone equipment, walking and occasionally lifting 10 to 40 lbs. No exposure to adverse working conditions.

       

    EDUCATION:

     

    Bachelor's Degree and SQL certification

       

    EXPERIENCE:

     

    10+ years experience in retail sector as a data architect / modeler /analyst in an Information Systems environment. 10+ years experience developing data warehouse, data mart and analytics solutions.  Understanding of database administration and architecture, data modeling tools, process and workflow tools and software automation technologies. Experience working with project methodologies and adhering to project plans. Experience with the following technologies:

    Languages - SQL, PL/SQL, SSIS, SSRS
    Integration - WSDL, SOAP, XML Web Service, XML
    Tools – SSRS, SSIS, Erwin, ETL Development, MDM
    Database: SQL Srvr

       

    OTHER PERSONAL

     

    Social and personal skills

    OR TECHNICAL

     

    Analytical and Critical Thinking

    SKILLS:

     

    Detail Oriented

      

    Process Focus

      

    Self motivated

      

    Excellent planner

      

    Thinks strategically

      

    Works unsupervised

       
      

    Active Listener

      

    Exceptional communication skills

    Options

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