• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 18th Apr 2022

 

Extract, transform, and load (ETL)processing routines and data feeds to transmit data to and from clients andsubcontractors

Create necessary data structures or datamodels to support data at all stages

Design and implement custom data analyticand BI/reporting products.

?Perform extensive data profiling andanalysis based on the client’s data

?Work with UI teams and/or client to defineBI and reporting requirements

?Developer custom reports and datavisualization products

?Support project delivery on DataWarehouse/BI projects for external and internal clients, including partneringwith ICF subject matter experts on project execution

Actively participate in Agile ceremoniessuch as stand ups, grooming, Sprint planning, retrospectives, and demos

Whatyou must have:

 

Bachelor’s degree (e.g., Computer Science, Engineering, or relateddiscipline)

6-8 years’ experience developing database ETL environments withbusiness intelligence applications

5 or more years of experience ingesting large datasets data so thatthey can accurately report findings to internal and external customers.

5 or more years identifying database structural necessities byevaluating client operations, applications, and programming.

5 or more years of experience Implemented procedures to ensure databasefunctionality, quality and compliance.

Whatwe'd like you to have:

 

Understand ETL concepts of data flow, dataenrichment, data consolidation, change data capture and transformation

Strong problem-solving and analyticalskills

Understand database concepts of referentialintegrity, indexes and keys, and table metadata

Ability to understand new technologyconcepts quickly and apply them accurately through an evolving, dynamicenvironment

Effective organizational, teamwork, andinterpersonal skills

Excellent written and verbal communicationskills, including presentation skills

Proven ability to deliver work within timeconstraints, in teams and individually

Passion and ability to make a difference

Ability to take ownership of activities andwork independently

Demonstrated experience showing strongcritical thinking and problem-solving skills paired with a desire to takeinitiative

Experience in Real Property and/orfacilities management databases and solutions for property management andtracking.

Experience in Real Property and FacilitiesManagement databases and analytics.

Experience working with Oracle &Informatica.

Experience in Databricks or otherDataware/DataLake Architecture.

Experience working with SQL Queries andPower Apps

Experience in Government Real Propertyand/or facilities management databases.

Experience with Dashboard creation inArcGIS, PowerBI, and Tableau.

Experience with JIRA and Confluence

What you'll love about working here:

 

 

SQL, AWS Glue, Redshift/Postgres, Lambda,Tableau/ PowerBI, R/Python, Agile, CI/CD, Oracle, Informatica, Databricks,ArcGIS, PowerBI, Tableau, Jira, Confluence ?