US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 12th Jan 2024
What type of software is typically used by the Agency: MS SQL Server, SSIS, ODI, Oracle
What type of hardware is typically used by the Agency: Microsoft Windows server, AIX, EXADATA
Provide a short description of the Position: These data warehouse and business intelligence positions are required to support the continued development and maintenance of DW/BI solutions in response to critical ITS initiatives as well as requirements from various agencies. These positions will also develop and maintain ETL solutions, operational reports, executive dashboards, and analytics. Additionally, these positions respond to all data warehouse and BI related ad hoc inquiry requests, development of dashboard features, and development of BI technical solutions for continued reporting requirements.
Provide a complete list of the day-to-day tasks to be performed by the Selected Candidate:
Expert
84+ Months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
84 months of experience in building extraction and transformation of transactional data to drive data warehouse loads and end user BI as well as reporting requirements using ETL tools like SQL Server Integration Services (SSIS) or Oracle Data Integrator (ODI)
60 months of experience in reporting and analytics tools such as Tableau or Power BI
84 months of experience in complex SQL development leveraging analytics functions using in SQL Server or Oracle
84 months of experience in SQL Server Integration Services (SSIS) development.
60 months of experience in Dimensional or OLTP Modeling to support data warehouse environments.
84 months of experience in internal and external stakeholder communications and outreach, including the development of presentations and other material.