Hope doing well!!
Have a look and let me know ASAP
Role- Senior ETL (SSIS) Developer
Location- Omaha, NE
Duration- 6 months to start
MODE OF INTERVIEW- SKYPE
Most Important Skills- SSIS / SQL Server / General ETL Experience / Communication.
Responsible for gathering requirements, analysis of source data systems, data modeling, and implementing ETL processes to populate the warehouse. It also includes development of semantic layers, creating reports using Business Intelligence tools, and providing second-tier support to power users. The Data Warehousing team uses a combination of SSIS and SQL Server stored procedures for their ETL work. These ETL Developer will be working to deeply analyze various sets and sources of data, specifically within claims data, and then will build out a greenfield system that will allow Nebraska Medicine to streamline and better manager the process of working with insurance providers going forward. We will be able to discuss the system they are looking to build in more detail as we gut further into the process.
For BI tools, the team uses Business Objects Web Intelligence, Tableau, Crystal Reports, and Microsoft SSAS cubes.
* Strong ETL SSIS and SQL data warehouses development experience and data marts designed to deliver analytics, data integration, and BI reporting on an enterprise basis required. * SQL ad-hoc query writing and SQL stored procedure writing required, using at least one of these database systems: Microsoft SQL Server, Oracle, Teradata, or MySQL. * Any Business Intelligence skills including use of at least one of SAP Business Objects Web Intelligence or Tableau preferred. * Preferred experience within an analytics department at a large health system or health information technology company preferred. * Crystal Reports experience preferred. * Big Data technologies such as HANA or Hadoop preferred. * OLAP data discovery tools such as Essbase or Microsoft SSAS preferred. * Statistical Analysis tools (SPSS, SAS, R, Stata, Python, MATLAB, etc.) preferred. * Data Quality tools for profiling, standardization, validation, enrichment, etc. preferred. * Data modeling experience and familiarly with those design tools such as Embarcadero preferred. * Experience with version control software such as Tortoise SVN or Microsoft TFS preferred.