• Data Architect Modeler Engineer

    Job Locations US-OK-Oklahoma City
    Location Zip Code
  • 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.  


    • 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





    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.




    Bachelor's Degree and SQL certification




    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




    Social and personal skills



    Analytical and Critical Thinking



    Detail Oriented


    Process Focus


    Self motivated


    Excellent planner


    Thinks strategically


    Works unsupervised


    Active Listener


    Exceptional communication skills


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