Proven ability to optimize SQL scripts using stored procedures, temp tables, table variables, and CTEs.
Experience analyzing, designing, and delivering ETL processes, X12 EDI flat files, BI reports, and data marts.
Proficiency in the Microsoft BI Stack and .NET architecture for dashboards and user interfaces.
Experience in large-scale SQL development supporting data cubes, information exchange, and BI dashboards; ability to monitor ETL schedules and develop new ETLs.
Requirements:
Create database tables and cubes using normalization (academic forms) to optimize resource allocation and BI delivery.
Build frameworks to provide accurate information quickly; analyze, design, and build reports, ETL, and assist in data marts as needed.
Design dashboards and interfaces using the Microsoft BI Stack and .NET; monitor ETL schedules and develop ETLs for new applications and dashboards.
Serve as an expert technical resource to management, clients, and development staff; provide IT capability consultations, contribute to task estimation and scheduling, and support software/hardware releases and installations.
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.
