SQL Data Analyst and Report Developer

Provider Network Solutions, LLC
Miami, United States of America
26 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 80K

Job location

Miami, United States of America

Tech stack

Data analysis
Databases
Data Normalization
Relational Databases
Database Queries
Software Debugging
Electronic Data Interchange (EDI)
Entity Relationship Models
Web Servers
Online Analytical Processing
Online Transaction Processing
Power BI
SQL Stored Procedures
SQL Databases
SQL Server Reporting Services
SQL Server Integration Services
Systems Integration
T-SQL
Data Processing
Information Technology
Data Delivery
Data Pipelines
QNXT

Job description

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., * 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

Do you have experience in Writing skills?, * 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., * 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.

Apply for this position