Offer summary

Qualifications:

Strong experience with SQL scripting, including stored procedures, temp tables, table variables, and CTEs., Background in designing and developing ETL processes, business intelligence reports, and data objects., Knowledge of data analysis, data marts, and dashboard creation using Microsoft Business Intelligence Stack and .NET., Ability to work independently in a remote setting across the US..

Key responsibilities:

Develop and optimize SQL scripts and database structures.

Design and build reports, ETL processes, and data marts.

Create dashboards and user interfaces using BI tools and .NET.

Monitor ETL schedules and support information delivery projects.

Job description

About the Job:

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.

Required profile