SQL data engineer

Title: SQL data engineer Client: Kroger Rate: $65/hour Location: Local to Cincinnati, Ohio Visa: USC or GC Holder Strong SQL and Data pipelining skills This role is in the Customer Experience pillar supporting Customer Data Acceleration. Accountable for developing and delivering technological responses to targeted business outcomes. Analyze, design and develop enterprise data and information architecture deliverables, focusing on data as an asset for the enterprise. Understand and follow reusable standards, design patterns, guidelines, and configurations to deliver valuable data and information across the enterprise, including direct collaboration with 84.51, where needed. • Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. • Experience building and optimizing 'big data' data pipelines, architectures and data sets. • Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement. • Strong analytic skills related to working with unstructured datasets. • Build processes supporting data transformation, data structures, metadata, dependency and workload management. • A successful history of manipulating, processing and extracting value from large disconnected datasets. • Working knowledge of message queuing, stream processing, and highly scalable 'big data' data stores. • Strong project management and organizational skills. Key Responsibilities • Utilize enterprise standards for data domains and data solutions, focusing on simplified integration and streamlined operational and analytical uses • Ensure there is clarity between ongoing projects, escalating when necessary, including direct collaboration with 84.51 • Leverage innovative new technologies and approaches to renovate, extend, and transform the existing core data assets, including SQL-based, NoSQL-based, and Cloud-based data platforms • Define high-level migration plans to address the gaps between the current and future state • Contribute to the development of cost/benefit analysis for leadership to shape sound architectural decisions • Analyze technology environments to detect critical deficiencies and recommend solutions for improvement • Promote the reuse of data assets, including the management of the data catalog for reference • Draft architectural diagrams, interface specifications and other design documents