Etl Developer - Santiago de Chile - Softserve

Softserve

Empresa verificada

Santiago de Chile

hace 3 semanas

Publicado por:

Valentina Hurtado

beBee Recruiter

Descripción

WE ARE- Our Client is the world's largest provider of healthcare products and services to office-based dental and medical practitioners. They provide a broad suite of electronic health records, integrated revenue cycle management, patient communication services, and analytics.- The product is a leading US cloud-based solution that completely re-imagines dental practice management. It offers an all-in-one product that includes numerous features from such domains as clinical, insurance, finance, scheduling & reminders, patient management, and access management.

YOU WANT TO WORK WITH:

Directing communication with business and product stakeholders from the client side
Understanding the data and reporting needs of the end users, support and enhancing current Data Warehouse architecture and integration model
Providing effective requirements analysis, adherence to Scrum practices, and proven data warehouse development and deployment strategies
Defining, documenting, and developing mapping rules for data from disparate data sources and into the various components
Delivering the development, testing, and ongoing evaluation of even sourced architecture, and validating organizational data structures
Providing best practices and guidance on ETL usage, data modeling (relational and dimensional), and reporting deliverables
Monitoring and troubleshooting production environments in collaboration with DevOps team
Investigating and fixing complex cases from real users in production
Supporting the development of the future product strategy for data sharing, analytics, and visualization using Micro Services

YOU ARE:

Strongly experienced in ETL (Extract, Transformation, and Load), Data Warehousing concepts, dimensional data modeling, and ETL integration concepts (Star schema vs. Snowflake, OLAP cube, etc.)
Aware of logical and physical data modeling concepts (relational and dimensional)
Using ETL transformations via SQL (MS SQL Server, or similar relative DB) and/or Java used inside BI tools: Pentaho, Talend, Informatica
Experienced with Business intelligence, either Pentaho, Power BI, Tableau, or any other modern reporting tools
Understanding DB design and DWH concepts well
Aware of data integration issues (validation and cleaning); and complex data and structures
Successfully working with Linux and Git and familiar with AWS
Possessing an analytical mind and problemsolving attitude
A holder of great interpersonal communication skills; can easily with multiple teams
Able to manage multiple priorities and adjust quickly to changing priorities
Showing practice in Agile methodology

Your extra power is:

Knowledge of Java, Hibernate, Kafka, eventdriven data warehouse, streaming, and storage
Performance tuning experience related to reporting queries. Knowledge of advanced database features; creating/optimizing SQL queries, stored procedures, functions, partitioning data, indexing, and reading execution plans
Microservice development, in particular, domaindriven design practices

TOGETHER WE WILL:

Have a friendly and mature team
Grow professionally
Enjoy flexible working hours
Propose and implement own solutions
Access the knowledge base of Software Engineering Institute and Best Practices

Accessible An infrastructure adequate for people with special mobility needs.
Pet-friendly Pets are welcome at the premises.
Flexible hours Flexible schedule and freedom for attending family needs or personal errands.
Life insurance Softserve pays or copays life insurance for employees.
Bicycle parking You can park your bicycle for free inside the premises.
Digital library Access to digital books or subscriptions.
Health coverage Softserve pays or copays health insurance for employees.
Dental insurance Softserve pays or copays dental insurance for employees.
Free car parking You can park your car for free at the premises.
Computer provided Softserve provides a computer for your work.
Fitness subsidies Softserve offers stipends for sports or fitness programs.
Informal dress code No dress code is enforced.
Vacation over legal Softserve gives you paid vacations over the legal minimum.
Beverages and snacks Softserve offers beverages and snacks for free consumption.
Vacation on birthday Your birthday counts as an extra day of vacation.

Remote work policy:

Hybrid
This job takes place some days from home and others at the office in Santiago (Chile).