Business Systems Analyst

Company: Eclaro
Location: Mahwah
Posted on: May 28, 2023

Job Description:

Business Systems AnalystJob Number: 23-01284Work for a logistics global leader. Eclaro is looking for a Business Systems Analyst for our client in Mahwah, NJ. Eclaro's client is the world's largest package delivery enterprise, providing expert transportation and logistics assistance to more than 220 countries worldwide. If you're up to the challenge, then take a chance at this rewarding opportunity!Responsibilities: Design and develop database interfaces to process data from data sources and storing data in Microsoft SQL Database. Database design and development for GRC data warehouse. Support effort to gather and document requirements and define the informational needs of the organization so that a database can be designed to meet those needs. Identify data file formats and transmission mechanisms to ingest data (i.e., CSV, JSON, API, etc.). Develop initial entity relationship diagram that shows the tables, fields, primary keys of the database, and how tables are related (linked) to one another. Lead the normalization process and resolve any problems associated with the database design so that the data can be accessed quickly and efficiently. Create the tables, fields, and primary keys. Create relationships between the tables. Create the transmission mechanisms to ingest data (i.e., CSV, JSON, API, etc.). Review entity relationship diagram in detail with larger team. Documentation that will allow the client to take over the maintenance and monitoring of the deployed database.Required Skills: MS SQL Server, Cloud based SQL, database design and development, relationship diagrams, database normalization, create database tables/primary keys/relationships & develop maintenance documentation.Experience: Experience with MS SQL Server and MS Dataverse; Cloud based SQL.If hired, you will enjoy the following Eclaro Benefits: 401k Retirement Savings Plan administered by Merrill Lynch Commuter Check Pretax Commuter Benefits Eligibility to purchase Medical, Dental & Vision Insurance through EclaroIf interested, you may contact:Joyce EleazarJoyce.Eleazar@eclaro.com(332) 206-3177Equal Opportunity Employer: Eclaro values diversity and does not discriminate based on Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.PDN-99294309-51aa-4bec-9345-e7818610695c

Keywords: Eclaro, Paterson , Business Systems Analyst, Professions , Mahwah, New Jersey