Job Description Summary
As a Data Engineer, some of the primary responsibilities of this role include developing database solutions, ensuring that new database code meets team standards for readability, reliability, and performance. The data engineer role requires a service-oriented mentality, high sense of ownership of the problems and requests assigned. The ability to work on multiple application development projects serving in a hands capacity while maintaining multiple production environments. Also responsible for managing and maintaining metadata data structures besides providing necessary support for post-deployment related activities. Accountable to deliver results in a timely manner using agile methodologies.
Job Description
As a Data Engineer, some of the primary responsibilities of this role include developing database solutions, ensuring that new database code meets team standards for readability, reliability, and performance. The data engineer role requires a service-oriented mentality, high sense of ownership of the problems and requests assigned. The ability to work on multiple application development projects serving in a hands capacity while maintaining multiple production environments. Also responsible for managing and maintaining metadata data structures besides providing necessary support for post-deployment related activities. Accountable to deliver results in a timely manner using agile methodologies.
Responsibilities
* Maintain production SQL Server instances
* Install and maintain Always On Availability Groups
* Ensure data security using SQL Server Technologies
* Write complex stored procedures, functions, views, triggers, and T-SQL
* Collaborate with system engineers, frontend developers and software developers to implement solutions that are aligned with and extend shared platforms and solutions
* Apply principles of SDLC and methodologies like Lean/Agile/XP, CI, Software and Product Security, Scalability, Documentation Practices, refactoring, and Testing Techniques
* Tune T-SQL queries. Conduct performance tuning query optimization reviews for projects
* Perform production database administration tasks such as backups, restores and maintenance routines
* Build a variety of data loading & data transformation methods using multiple tools and technologies.
* Design & build automated Extract, Transform & Load (ETL) jobs based on data mapping specifications
* Manage metadata structures needed for building reusable Extract, Transform & Load (ETL) components.
* Analyze reference datasets and familiarize with Master Data Management (MDM) tools.
* Analyze the impact of changes to downstream systems/products and recommend alternatives to minimize the impact.
* Derive solutions and make recommendations from deep dive data analysis proactively.
* Ensure meta data quality by using Data Quality (DQ) rules through code or MDM.
Qualifications
* At least 5 years experience administering SQL Server databases in development and/or production environments
* A minimum of 8 years of experience working on T-SQL/SQL Server experience working on T-SQL/SQL Server
* Bachelors Degree in Computer Science, Information Technology or equivalent (STEM)
* Performance Tuning SQL Server Instances
* Extensive T-SQL Programming Skills
* Experience using High Availability Features such as Always On
* PowerShell Scripting
* SSIS Development Experience
* Experience working with Visual Studio Database Projects desired
* Experience working in cloud environment such as Azure
* Experience working with performance monitoring tools like Query Store
* Experience working with Master Data Services
* Exposure to unstructured datasets and ability to handle XML, JSON file formats
* Has the ability to take ownership of small tasks and deliver without supervision while using their discretion to seek help when necessary
* Voices opinions by presenting clear rationale and uses data driven analysis to influence decisions.
* Recognizes collaborative behavior and participates in collaborative activities
Desired Skills
* Prior Healthcare Domain Experience a plus
* Offers data solutions as a method to achieve bus objectivesOur total rewards are designed to unlock your ambition by giving you the boost and flexibility you need to turn your ideas into world-changing realities. Our salary and benefits are everything youd expect from an organization with global strength and scale, and youll be surrounded by career opportunities in a culture that fosters care, collaboration and support.#LI-CHI
Additional Information
GE offers a great work environment, professional development, challenging careers, and competitive compensation. GE is anEqual Opportunity Employer. Employment decisions are made without regard to race, color, religion, national or ethnic origin, sex, sexual orientation, gender identity or expression, age, disability, protected veteran status or other characteristics protected by law.
GE will only employ those who are legally authorized to work in the United States for this opening. Any offer of employment is conditioned upon the successful completion of a drug screen (as applicable).
Relocation Assistance Provided: No
About Us
GE (NYSE:GE) rises to the challenge of building a world that works. For more than 125 years, GE has invented the future of industry, and today the company?s dedicated team, leading technology, and global reach and capabilities help the world work more efficiently, reliably, and safely. GE?s people are diverse and dedicated, operating with the highest level of integrity and focus to fulfill GE?s mission and deliver for its customers. www.ge.com
Boston, MA
General Electric Company operates as a high-tech industrial company worldwide. It operates in Power, Renewable Energy, Aviation, Oil & Gas, Healthcare, Transportation, Lighting, and Capital segments. The Power segment offers technologies, solutions, and services related to energy production, including gas and steam turbines, generators, and high voltage equipment; and power generation services. The Renewable Energy segment provides wind turbine platforms, and hardware and software; offshore wind turbines; solutions, products, and services to hydropower industry; and blades for onshore and offshore wind turbines.
The Oil & Gas segment offers oilfield and oilfield equipment, turbomachinery and process solutions, and digital solutions. The Aviation segment provides jet engines and turboprops for commercial airframes; maintenance, component repair, and overhaul services, as well as replacement parts; and additive machines and materials, and engineering services. The Healthcare segment provides healthcare technologies in medical imaging, digital solutions, patient monitoring, and diagnostics, drug discovery, biopharmaceutical manufacturing technologies and performance enhancement solutions. The Transportation segment provides freight and passenger locomotives, and rail and support advisory services; parts, integrated software solutions, and data analytics; software-enabled solutions; mining equipment and services; and marine diesel engines, and stationary power diesel engines and motors for drilling rigs, as well as overhaul, repair and upgrade, and wreck repair services.
The Lighting segment offers light emitting diode products; and energy efficiency and productivity solutions. The Capital segment leases and finances aircraft, regional jets, turboprops, freighters, engines, helicopters, as well as offers financing and materials; financial and underwriting solutions; and insurance services. The company was founded in 1892 and is headquartered in Boston, Massachusetts.