{"id":205,"date":"2024-03-14T12:18:58","date_gmt":"2024-03-14T12:18:58","guid":{"rendered":"https:\/\/financeboxus.com\/careers\/?post_type=awsm_job_openings&amp;p=205"},"modified":"2024-03-14T12:18:58","modified_gmt":"2024-03-14T12:18:58","slug":"data-engineer","status":"publish","type":"awsm_job_openings","link":"https:\/\/simaxive.com\/careers\/jobs\/data-engineer\/","title":{"rendered":"DATA ENGINEER"},"content":{"rendered":"<p><strong>Description<\/strong><\/p>\n<p>Supports business decision-making by designing and developing data warehouse infrastructure, capabilities, and system.Duties: * Determines data requirements by interviewing customers; analyzing business requirements and applications; evaluating existing systems, hardware, and software; defining and analyzing data sources; validating data required; documenting requirements. * Develops data strategies by establishing integrated architecture and hierarchy; establishing metadata and modeling standards; developing and evaluating logical and physical models; defining ETL strategies, including designing and validating schema; preparing transformation rules, indexing, directories, synchronization, sharing, replication, back-up, retention, recovery, and summarization strategies; mapping data from source to target. * Analyzes data by defining quality requirements; assessing data quality, availability, and change data capture. * Implements data schema by developing program, process, procedure, and quality solutions for data acquisition, extraction, cleansing, transformation, integration, loading, and replication; developing filtering, formatting, and data delivery processes to data marts; building SQL code, stored procedures, and triggers; creating views of data structures; documenting system. * Designs interfaces by developing visualization and access methods; designing application reports and testing. * Tests data quality by analyzing data integration from all sources; defining load validation, meta data updating, and data integrity processes; establishing quality standards, monitoring systems, and audit and reconciliation processes. * Maintains database performance by completing SQL performance tuning; supporting system operation cycle; coordinating requirements and actions between applications and operating area staffs; monitoring standards; modifying system documentation; designing and conducting training in data management and transformation. * Improves database performance by evaluating requests; implementing enhancements. * Updates job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations. * Accomplishes organization goals by accepting ownership for accomplishing new and different requests; exploring opportunities to add value to job accomplishments.Skills\/Qualifications:Database Management, Data Mining, Software Algorithm Design, Software Development Fundamentals, Research Skills, Strategic Planning, Operating Systems, Requirements Analysis, Data Warehousing, Data Modeling, Data Marts.<\/p>\n<p><strong>Technologies we use:<\/strong><\/p>\n<ul>\n<li>ETL (Extract Transform Load)<\/li>\n<li>ELT (Extract Load Transform)<\/li>\n<li>Database Design and Development<\/li>\n<li>Data Integration<\/li>\n<li>Data Analytics &#8211; BI Report generations, Data Mining, Statistical reporting<\/li>\n<li>Data Governance<\/li>\n<li>Data Architecture<\/li>\n<li>Data Modeling for Data Warehouse and DBMS systems<\/li>\n<li>Python<\/li>\n<li>Snowflake<\/li>\n<li>Oracle<\/li>\n<li>SQL<\/li>\n<li>DBT<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Supports business decision-making by designing and developing data warehouse infrastructure, capabilities, and system.Duties<\/p>\n","protected":false},"author":3,"featured_media":0,"template":"","meta":[],"class_list":["post-205","awsm_job_openings","type-awsm_job_openings","status-publish","hentry","job-type-full-time","job-location-east-brunswick","job-location-nj-09916","job-location-us"],"_links":{"self":[{"href":"https:\/\/simaxive.com\/careers\/wp-json\/wp\/v2\/awsm_job_openings\/205","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/simaxive.com\/careers\/wp-json\/wp\/v2\/awsm_job_openings"}],"about":[{"href":"https:\/\/simaxive.com\/careers\/wp-json\/wp\/v2\/types\/awsm_job_openings"}],"author":[{"embeddable":true,"href":"https:\/\/simaxive.com\/careers\/wp-json\/wp\/v2\/users\/3"}],"wp:attachment":[{"href":"https:\/\/simaxive.com\/careers\/wp-json\/wp\/v2\/media?parent=205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}