— Experience with ETL processes, SSIS packages, data modeling, data warehousing, SSAS data models and cubes, and relational database design required, preferably within a healthcare setting.
— Data warehousing, data modeling, ETL and variants there-of, Microsoft SQL Server (SSIS, SSAS — 2014+) required.
— Developing parameterized/hierarchical reports in SSRS using SSAS as a data source.
— Familiar with source control systems such as TFS
If you know about the following:
— Min. Bachelor’s degree preferred
— Experience with data visualization tools and insurance environment experience preferred
— SQL Server 2017, Visual Studio and SSRS (SQL Server Reporting Services) highly preferred.
— Strong understanding of modern data architecture and DevOps highly preferred.
— Microsoft MCSA: BI Development
— Microsoft MCSE: Data Management and Analytics, Data Platform or Business Intelligence
— Several years of experience from bank and finance.
— Good analytical, problem solving, creative thinking and design skills applicable to multiple products
— Good communication and presentation skills to communicate with application developers, customers, support personnel and management — advising key stakeholders towards the right solution
— Mentoring and training skills to guide and direct work of less experienced specialists
— Ability to handle multiple tasks simultaneously and switch between tasks quickly
— Ability to work independently and as part of a team
— A unique working environment where you communicate and work directly with clients and top management as well as other team members
— Continuous learning based on a training & development program
— Competitive salary
— State of the art, cool, centrally located offices with warm atmosphere which creates really good working conditions
— Understand and work with multiple data sources to create a unified, integrated solution which implements defined business rules and supports analytical needs.
— Design, architect and implement scalable data acquisition and processing pipelines, transformations, and semantic layers to support end-to-end business intelligence solutions, workflows, applications and enable self-service reporting.
— Create, test, implement and maintain all ETL procedures, support large data volumes and processing, and ensure the best possible performance and data quality.
— Lead the organization in planning and defining requirements, then design, develop, test and maintain the organization’s data warehouse.
— Design, implement, test and document SQL Server components — schemas, stored procedures, tables, views, SSIS packages, indexing, foreign key relationships, SSAS cubes, etc.
— Ensure proper source control, documentation, testing and quality assurance processes are developed and followed to maintain high data integrity.
— Lead the development, specification and communication of a data management plan, and the infrastructure components required to support it.
— Partner with the IT Operations team to review and optimize database performance (create baseline performance reports, rewrite queries and stored procedures, implement and tune indexing, hardware bottlenecks, file structure and storage, memory utilization, etc.).
— Provide thought leadership in the areas of data governance, master data management, data mining, data warehousing, data modeling and analytics
— Develops new and standard reports utilizing data warehouse information.
— Programs and writes queries and reports
We are hiring a business intelligence developer to advance our new business intelligence solution. You will work alongside analysts and controllers from the business and report directly to the head of projects. To succeed in this role, you should have exceptional analytical thinking skills and be able to explain difficult concepts to non-technical users. A background from bank and finance will be considered a plus.
Your key tasks will be to design, build and maintain ERV’s data and DWH infrastructure. Oversees all aspects of ETL (Extract-Transform-Load) processes, development and maintenance. Primary developer for ETL and data integration processes, including acquisition, staging, transformations and cleansing. All this done in close corporation with Line of Business, so it is expected that you can guide and advice around best-practice.