SKYGEN · 2 weeks ago
Data Analyst
Remote USA
Full-time
Remote
Entry, Mid Level
$74K/yr - $105K/yr
2+ years exp
Maximize your interview chancesHealth CareInsurance
Insider Connection @SKYGEN
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
Develop, schedule, and generate reports including List, Matrix, Drill-Down, Drill-through, Chart, Cascaded reports, Multi-value, and Sub Reports by creating Expressions, Parameters, Sub-Reports, and Sorting & Grouping using SQL Server Reporting Services (SSRS)
Build complex T-SQL queries and stored procedures for reports in SSRS and Windward to apply business rules while integrating data using SSIS
Resolve new or existing modification reporting tickets using Azure
Document development and technical tasks with detailed documentation in Service Desk (Ticket tracking system) upon resolution
Use Actual and Estimated Execution Plans in SSMS and SQL profiler to find long running queries and performance tuning by creating Clustered and Non-Clustered Indexes
Modify SSIS packages by using Control Flow Tasks
Create databases, tables, stored procedures, DDL/DML Triggers, Views, User defined data types, effective functions, cursors, and indexes using T-SQL
Create modified Tables, Views, Indexes, Functions, Triggers, and Stored Procedures according to business requirements
Analyze requests from internal and external clients to determine scope of request and determine requirements to successfully complete the request
Provide technical assistance to lead and support new and existing client implementation and maintenance
Maintain responsibility for timely and accurate project completion
Evaluate and confirm incoming/outgoing data sets meet defined requirements
Monitor and assess quality of data contained within system databases
Research and resolve issues as requested by internal and external clients
Identify opportunities to use data to develop new strategies and improve business processes and performance
Conduct QA Peer Reviews to validate requirements, code and data
Provide training, feedback and mentoring to department staff
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Bachelor’s degree in Computer Science, or related field
two years of experience as a Data Analyst or related occupation
2 years of experience with Business Intelligence tools including SSRS, SSIS and T-SQL
2 years of experience with T-SQL programming using cursors, Triggers, functions, Indexes and SQL Profilers
2 years of experience with Agile and string in Systems Development Life Cycle (SDLC)
2 years of experience preparing ad hoc data extracts, reports, technical assistance to support data projects
Company
SKYGEN
SKYGEN powers dental and vision connectivity solutions that inspire clients to move confidently into the future by employing technology that creates unparalleled efficiencies, streamlines marketplace interactions and drives better healthcare access, value and satisfaction.
501-1000 employees
H1B Sponsorship
SKYGEN has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (8)
2022 (13)
2021 (10)
2020 (4)
Funding
Current Stage
Late StageLeadership Team
Craig Kasten
CEO and Managing Partner
Steven J. Berryman
Chief Executive Officer
Recent News
PR Newswire
2022-03-08
Company data provided by crunchbase
