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.

Technologies we use:

  • ETL (Extract Transform Load)
  • ELT (Extract Load Transform)
  • Database Design and Development
  • Data Integration
  • Data Analytics – BI Report generations, Data Mining, Statistical reporting
  • Data Governance
  • Data Architecture
  • Data Modeling for Data Warehouse and DBMS systems
  • Python
  • Snowflake
  • Oracle
  • SQL
  • DBT
Job Type: Full Time
Job Location: EAST BRUNSWICK NJ 09916 US

Apply for this position

Allowed Type(s): .pdf, .doc, .docx
Contact Us

We're not around right now. But you can send us an email and we'll get back to you, asap.