Position: Senior BI Engineer/Reporter
Company: Intetics
Category: SQL
Experience required: 3y
English level: upper

The project

We are working on a healthcare product — from scratch, we developed a high-performance scalable web platform with multiple integrated applications (.NET Core microservices). The product is aimed at automation of the full cycle of patient-clinic-doctor relations.

The project is in the active development phase (the product is used at the market). Customer Location — USA.


Project advantages:


- Developing solutions for an industry leader

- Playing with cutting edge technologies and innovative digital solutions

- Direct communication with business owners and matter experts

- Cross product analytics

- Cooperation with a cross functional teams

- Opportunity to learn customer's company business


Responsibilities:

- Work with the internal stakeholders to create best-of-breed enterprise dashboards - throw database design, performance tuning, dimensional analysis and modeling

- Work with internal and external data providers and subject matter expert to understand data sources and formats

- Analyze data requirements, application and processing architectures, data dictionaries

- Advocate for additional data sets and elements to improve delivered data products

- Create custom SQL to query complex data models in the most effective way for the database and application server

- Identify and initiate process improvement initiatives that might improve the customer experience, enhance work flow, and/or improve the work environment

The dashboards have to follow industry best practices for design and technical needs, with a strong focus on delivering app-like analytical experience to business

Job requirements:

- 4+ years' experience with DW.MS SQL Server

- 4+ years of experience developing reporting and dashboard solutions with BI tools such as Tableau, Power BI, Power Apps

- Experience in getting data from Big Data into BI tools

- Experience with LOD calculations

- Understanding of Dimensional Data Models and Data Warehouse concepts

- Experience with UI/UX prototyping to refine requirements

- Medical or insurance industry experience

- Experience with cloud hosting AWS
- Experience with other data analysis and data visualization tools


Must have:

- Expertise with DW.MS SQL Server

- Expertise in DBMS, e.g. MS SQL Server or MySQL

- Strong SQL, T-SQL skills

- Expertise in Data Warehousing, ETL and Analytics tools, e.g. MS tools (SSIS, SSAS, SSRS)

- Expertise in designing and developing reporting and dashboard solutions for large enterprise project