Data Engineer
Clark, NJ Information Technology
Job Type
Full-time
Description

At Clarity, our mission is to deliver quality services by embracing Technology, Innovation and Sincerity and adopting a Simply Smarter approach for service delivery. Under general to close supervision, this position exercises latitude for independent action and discretion supporting all aspects of the SQL Database, related scheduled tasks, integration to multiple platforms, and code development. Projects will span all consumer benefit services (health care and COBRA). Data Engineer works collaboratively with internal and certain external customers to deliver quality services within the specified timeline and scope defined.

REPORTING STRUCTURE & WORK SETTING

This position typically resides at Company headquarters. This position will report to the Associate Director of Application Development. The nature of the work entails that candidate collaborate and work closely with other team members and includes cross-functional departments.

PRIMARY JOB RESPONSIBILITIES

  1. Designing database tables and structures via SQL
  2. Creating views, functions, and stored procedures
  3. Writing optimized SQL queries for integration with other applications (Salesforce, Clarity Portal)
  4. Creating database triggers for use in automation and integrations with other applications (Billing, Finance)
  5. Supporting front end applications written in Java, C++, and C# (Portal, Intranet/SharePoint)
  6. Experience with WordPress, PHP and .NET framework helpful

Work or Related Experience:

  • Reliable and dependable with an attention to detail along with strong analytic ability.
  • Must have at least 3-5 years’ experience.
  • Strong problem solving, multitasking and time management skills.
  • Be detail oriented and work well under deadlines
  • Understand client/server architectures: Azure & AWS
  • Single Sign On experience preferred.
  • Experience designing and executing SQL queries to manage database schemas and data.
  • Experience working with structured file formats such as XML and JSON.


TRAVEL REQUIREMENTS & CONDITIONS

Indicate applicable: Minimal travel to attend training or company meetings may be required.

Requirements

Education:

Bachelor’s degree

Microsoft Certifications (MTA, MSCA, Azure Fundamentals, etc.)

Specialized Knowledge, Skills & Abilities:

Design, develop, implement, and maintain workflows to load, aggregate, and extract data to meet a wide range of business and system requirements using Informatica (or SSIS, or other ETL tools)

Consolidation and standardization of data flows across the organization to technology stack (Informatica or SSIS other ETL tools, SQL Server)

Experience with a variety of data feed types, including JSON, XML, CSV, and SOAP

developing and executing test plans to verify logic of data movement and ETL scripts

Experience troubleshooting and resolving data, system, and performance issues

Proficiency with Microsoft Office suite and strong technical knowledge of current Windows operating systems required

Must have excellent customer service skills with the ability to empathize and professionally troubleshoot and resolve customers' issues

Strong organizational, verbal, and written communication skills with high attention to detail

Excellent written and verbal communication skills

Strong attention to detail with excellent analytical, multitasking, and judgment capabilities

Ability to effectively work independently and in a team environment.

Experience with the ANSI and X12 standards for EDI 834 file development and maintenance

Net Web API, Web Services (would be a plus)

Azure Data Factory (would be a plus)

Applications:

Proficiency with MS Office 365 Suite (Word, Excel, PowerPoint, Teams and Outlook) is required. A strong, hands-on knowledge of Salesforce, Single Sign On, Dell Boomi and Active Directory are good to possess