Job Description :
Cerebra Consulting Inc is a System Integrator and IT Services Solution provider with a focus on Big Data, Business Analytics, Cloud Solutions, Amazon Web Services, Salesforce, Oracle EBS, Peoplesoft, Hyperion, Oracle Configurator, Oracle CPQ, Oracle PLM and Custom Application Development. Utilizing solid business experience, industry-specific expertise, and proven methodologies, we consistently deliver measurable results for our customers. Cerebra has partnered with leading enterprise software companies and cloud providers such as Oracle, Salesforce, Amazon and able to leverage these partner relationships to deliver high-quality, end-to-end customer solutions that are targeted to the needs of each customer.
Here are the details: Position: Data Engineer Location: 100% Remote (Client sits in Basking Ridge, NJ) Duration: 12 month Contract to Hire Project: Behavioral Health Encounter Management Information System Projects Project team supports the ETL processes from various internal claims systems for EDI submissions to State Medicaid systems. Current team size is five with both database and report developers. Day-to-day responsibilities: 1. Extract data from various internal claims systems for Behavioral Health Medicaid claims, transform to meet the EDI requirements and load to SQL Server environment. 2. Work with team to ensure data quality 3. Load Responses from state into SQL Server environment for reporting 4. Identify and help report data that needs additional research to be valid for EDI submission 5. Identify rejected responses and report to Encounter research team What software tools/skills are needed to perform these daily responsibilities? MS SSIS MS SSRS SQL Server Complex SQL querying ETL (any type is fine) What skills/attributes are a must have? MS SSIS, SQL What skills/attributes are nice to have? .NET (C# or VB) Required Skills : What software tools/skills are needed to perform these daily responsibilities? MS SSIS MS SSRS SQL Server Complex SQL querying ETL (any type is fine) What skills/attributes are a must have? MS SSIS, SQL