Proven capability to enhance the functionality and performance of various SQL scripts using stored procedures, temp tables, table variables, and CTEs. Analyzes, designs the framework for and participates in the development and delivery of ETL/ X12 EDI flat files, business intelligence reports, and other information objects. The primary focus of the job deals with Information Delivery and Data Analytic projects.
This position is open to REMOTE / TELECOMMUTE / WORK FROM HOME candidates form anywhere in the US.
Responsibilities to include:
Creates database tables and cubes utilizing academic methodology (normal forms) ensuring business smart resource allocation
Creates frameworks to provide accurate information quickly to the organization.
Analyze, design and build reports, ETL and assists in the creation of data marts as needed.
Designs user interfaces and dashboards using the Microsoft Business Intelligence Stack and .net architecture
Monitors ETL schedules and develops new ETLs to support new application and dashboard/information delivery
Responsible for large scale SQL development that drives cubes and information exchange for decision support applications and BI dashboards
This position services as an expert technical and industry resource to management, clients and development staff in new uses of information technology and in all phases of major system and subsystem development. Provides consultation on internal and industry IT technical and business process capabilities including leadership in the identification and recommendation of new IT opportunities. Formulates, contributes to, and directs task identification, work effort estimates, and work schedules for research, prototype, and proof-of-concept IT activities. Directs and participates in software/hardware releases and installation tasks.
