SQL Data Analyst and Report Developer at Provider Network Solutions

Doral, Florida, United States -

Full Time

Start Date

Immediate

Expiry Date

30 Sep, 26

Salary

80000.0

Posted On

02 Jul, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

T-SQL, SSRS, SSIS, PowerBI, Data Modeling, OLTP, OLAP, Data Analysis, Debugging, Entity Relationship Design, Data Normalization, Relational Databases, Data Pipelines, Technical Documentation, Problem Solving, Communication Skills

Industry

Hospitals and Health Care

Description

Description Description *Not a remote position - Authorization to work in the US is required* Position Summary The SQL Analyst and Report Developer role is to write and optimize SQL statements for data processing from different sources. This role inspects, cleans, models' data to discover useful information the business might need, and collects requirements from business to convert them into technical solutions. Duties and Responsibilities · Develop comprehensive views, functions, triggers, and procedures to implement complex data processing. · Develop, maintain, monitor, and optimize the performance of OLTP queries. · Perform data research, analysis, conceptual and logical data modeling to solve data issues. · Design and automate reports using (SSRS) Report Builder and PowerBI. · Design and implement highly distributed, scalable processes to extract, manipulate, stage, and ingest data using T-SQL language and/or (SSIS) Integration Services · Understand data needs and construct data pipelines for automating and accelerating data delivery multiple sources. · Collaborate closely with other developers, and other departments to identify key business processes and deliver viable solutions. · Analyze and assess technology and industry trends to determine organizational objectives. · Assist in the definition, and documentation of business data artifacts, objectives, deliverables, and specifications on a project-by-project basis. · Maintain high quality documentation of projects, requirements, and business rules. · Translate business requirements into technical and non-technical, lay terms. · Liaise with partners for efficient implementation of new reporting and analytic products. Requirements Knowledge · University degree or College diploma in the field of computer science and 3-5 years related experience. Experience with QNXT platform is a plus. · Strong proficiency knowledge of TSQL language to query data, create views, functions, triggers, and stored procedures. · In-depth understanding of entity relationship design, data normalization, relational databases and modeling techniques · Excellent understanding of principles and best practices to build OLTP and OLAP · Deep knowledge of information technology infrastructure such as databases and web server technologies, security, etc. · Maintain professional and technical knowledge by attending educational workshops, reviewing professional publications, establishing personal networks and/or participating in professional societies. · Healthcare experience related to data analysis would be a plus. · Healthcare experience working with Electronic Data Exchange (EDI) solutions would be a plus. · Conventional understanding of applicable data privacy practices, HIPPA regulations, Healthcare laws would be a plus. Skills · Keen attention to detail and proven analytical problem-solving skills. · Highly skilled at debugging and optimizing large, complicated SQL statements. · Strong knowledge of T-SQL, SSRS, SSIS, PowerBI. · Strong written, oral, and interpersonal communication skills.

Responsibilities

The role involves writing and optimizing SQL statements to process data from various sources and creating technical solutions based on business requirements. Responsibilities include designing automated reports using SSRS and PowerBI, as well as building scalable data pipelines using T-SQL and SSIS.