Position: Senior DWH/BI Developer
Company: Українська Кадрова Група
Experience required: 3y
Category: Other
English level: upper
Published: 2021-08-01T00:00:00+03:00

Customer:

The customer is changing the way providers and payers manage their billing and payment processing needs for workers’ compensation, property & casualty, and group health industries. With the customer’s products, providers streamline billing operations, improve payment cycles, and reduce the frictional costs of checking bill & payment status.

The customer is a key technology-enabled partner of leading insurance companies, bill review and claims software companies, managed care networks, provider organizations, and clearinghouses. They build and manage eBilling, eRemittance, ePayment, eAdjustor, and eProvider Gateways. The customer’s flexible product suite allows providers and payers to achieve compliance with emerging jurisdictional rules requiring electronic bill receipt and remittance advice delivery.

The customer is widely recognized for its deep knowledge and technical competence within the insurance industry. They provide strong participation and thought leadership within both legislative and standards setting organizations. The customer’s expanding connectivity network now links over 5,000 insurance payers with 1,500,000 providers nationally.


Project:

The customer is building an Enterprise Data Warehouse Platform to consolidate data sources and provide a multitude of reports to leadership and working professionals. Current initiative heavily relies on Cloud offerings, but does not require dedicated BigData and real-time processing technologies.

One of the primary goals is to retrieve data increments from Oracle Cloud Infrastructure without slowing down or disrupting operational processes.
Another goal is to investigate available technological solutions for Data Warehouse and for ETL processes based on the business requirements.

Responsibilities:

● Participate in prototyping the platform components and comparing technologies
● Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization
● Consolidate and optimize knowledge about available systems and data sources
● Design data models based on business requirements
● Participate in building the company’s Analytics culture

Requirements:

● Knowledge of Enterprise Data Warehousing concepts, experience with building Warehouses and Lakehouses (3+ years of experience)
● Experience (in order of priority) with AWS, Azure or GCP data-related services
● Experience (in order of priority) with Snowflake, Azure Synapse, Redshift or Azure SQL
● Good understanding of ETL tools such as Airflow, Talend, Fivetran, etc.
● Experience with Oracle Cloud Infrastructure, or ability to quickly learn the technology
● Some experience with on-premises Oracle RDBMS

Nice to have:
● Domain knowledge in Insurance, Healthcare
● Experience with retrieving data from various sources by API
● Experience with PII data management