Data Engineer Sr - E3
标准职位描述提供整个数据处理管道中全套数据解决方案。这依赖于系统工程原则,设计和实施跨度数据生命周期的解决方案:以规模和速度收集,摄入,处理,存储,持久,访问和交付数据。它包括了解本地,分布式和基于云的技术;虚拟化和智能缓存数据;以及保护数据所需的所有安全和身份验证机制。构建清洁,转换和集成非组织数据为准备分析的数据库或数据来源的数据管道的数据管线;通过定义功能能力,安全性,备份和恢复规格设计和实施数据解决方案;在数据解决方案生命周期的各个阶段工作,例如分析/配置文件数据,创建概念,逻辑和物理数据模型设计,建筑和设计 ETL,报告和分析;通过识别和解决生产和应用开发问题来维持数据系统性能;计算参数最佳值;评估,集成和安装新版本;确定数据对象标准,最佳实践和认证流程基本资格 · 3年以上与 SAP,SAP HANA,Oracle 或 SQL Server (例如:关系数据库原则,SQL,SQL Script,PL/SQL,Transact-SQL 支持程序,功能和观点)工作经验;·知识和使用图表,Power BI 和 Qlik 等数据可视化工具的经验。·对数据挖掘和清理,识别和纠正错误/不一致性以及确保数据的准确性,一致性和完整性以及/或 ETL 数据仓储原理的经验;•解决问题和故障/解决复杂技术问题的经验;· 背景/实操了解,包括 Python,微软 (VBA) 或其他语言及其各种应用程序和使用案例所需技能 ·与内部及外部客户合作开发和改进解决客户需求的项目成果,流程和解决方案的经验 · 对现有数据产品进行变更协调的经验,对最终用户带来最小破坏 · ERP 系统功能的知识 ·关系数据库原则和强大的 SQL ·优秀沟通和协作
查看英文原文
Standard Job Description
Delivers full-stack data solutions across the entire data processing pipeline. This relies on systems engineering principles to design and implement solutions that span the data lifecycle to: collect, ingest, process, store, persist, access, and deliver data at scale and at speed. It includes knowledge of local, distributed, and cloud-based technologies; data virtualization and smart caching; and all security and authentication mechanisms required to protect the data.Build data pipelines that clean, transform, and aggregate unorganized data into databases or data sources that are ready for analysis; Design and implement data solutions by defining functional capabilities, security, back-up, and recovery specifications; Work through all stages of a data solution lifecycle, e.g., analyze / profile data, create conceptual, logical and physical data model designs, architect and design ETL, reporting and analytics; Maintain data systems performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; Define standards, best practices, and certification processes for data objects
Basic Qualifications
- 3+ years of demonstrated experience working with SAP, SAP HANA, Oracle, or SQL Server (example: relational database principles, SQL, SQL Script, PL/SQL, Transact-SQL in support of Procedures, Functions, and Views)
- Knowledge and experience with data visualization tools such as Tableau, Power BI, and Qlik.
- Experience with data mining and cleansing, recognizing and correcting errors/discrepancies and ensuring accuracy, consistency, and completeness of data, and/or ETL data warehousing principles
- Experience with problem-solving and troubleshooting/resolving complex technical issues
- Background in creating data solutions for Data Analytic products and services at scale and speed
- Background/working knowledge in multiple languages such as Python, Microsoft (VBA), or others and their various applications and use cases
Desired Skills
- Experience working with internal and external customers to develop and improve program deliverables, processes, and solutions that solve customer needs
- Experience in coordinating changes to existing data products with minimal disruption to end-user
- Knowledge of ERP system functionality
- Relational database principles and strong SQL
- Excellent communication and collaboration skills, with the ability to work with technical and non-technical stakeholders
Pay Information
GeoZone Definition: GeoZones are geographic groupings created by Lockheed Martin to align compensation ranges with regional labor markets and cost-of-labor differences across the United States. Locations are assigned a Geo Zone based on the primary work location of the role.
- Full-time salary range (GEOZONE 1): $106600.00 - $198000.00 · Includes metropolitan areas such as Sunnyvale CA; Pal Alto, CA; New York City metropolitan area; Newark, New Jersey; etc.
- Full-time salary range (GEOZONE 2): $95900.00 - $178100.00 · Includes metropolitan areas such as Denver, CO; King of Prussia, PA; Stratford, CT; Moorestown, NJ; etc.
- Full-time salary range (GEOZONE 3): $85300.00 - $158300.00· Includes metropolitan areas such as Dallas–Fort Worth, TX; Orlando, FL; Grand Prairie, TX; Marietta, GA; etc.
- Full-time salary range (GEOZONE 4): $76700.00 - $142500.00· Includes metropolitan areas such as Camden, AR; Lexington, KY; Lufkin, TX; etc.
At Lockheed Martin, we know mission success starts with taking care of our people. Our Total Rewards program is designed to attract top talent, support your well-being, and help you grow—both professionally and personally.
The salary range for this position is as listed on the requisition. Please note that the salary information listed is a general guideline only.
Lockheed Martin considers factors such as (but not limited to) scope and responsibilities of the position, candidate's work experience, education/ training, key skills as well as market(work location) and business considerations when extending an offer.
Benefits offered: Medical, Dental, Vision, Flexible work arrangements and schedules (e.g., 4x10), 401(k) match, Paid time off, Holidays, Parental Leave, EAP, Flexible Spending Accounts, Education Assistance, Life Insurance, Short-Term Disability, and Long-Term Disability.
- Annual short-term and/or long-term incentive compensation programs may be offered depending on the position. Payments under these annual programs are not guaranteed and can vary from year to year and are tied to a range of performance metrics.
- For (Washington state applicants only) Non-represented full-time employees: accrue at least 10 hours per month of Paid Time Off (PTO) to be used for incidental absences and other reasons; receive at least 90 hours for holidays. Represented full time employees accrue 6.67 hours of Vacation per month; accrue up to 52 hours of sick leave annually; receive at least 96 hours for holidays. PTO, Vacation, sick leave, and holiday hours are prorated based on start date during the calendar year.
Originally posted on Himalayas