5-7 years of experience in SQL development and ETL processes
Strong understanding of database design and normalization
Experience with Microsoft Business Intelligence Stack and .NET architecture
Proficient in creating business intelligence reports and dashboards
Ability to analyze and interpret complex data sets
Familiarity with data warehousing concepts and practices
Previous experience in consultation roles involving IT solutions
Responsibilities
Creates database tables and cubes with a focus on efficient resource allocation
Develops frameworks for timely and accurate information delivery
Analyzes, designs, and builds ETL processes and reports
Designs user interfaces and dashboards using BI tools
Monitors ETL schedules and develops new ETLs for applications
Handles large-scale SQL development for decision support applications
Provides expert consultation on IT technical and business processes
Benefits
Remote work flexibility from anywhere in the US
Opportunities for professional development
Exposure to cutting-edge technology and methodologies
Involvement in major system development projects
Collaboration with industry experts and management
Full 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.
