ETL Developer in Softserve

Closed job - No longer receiving applicants

WE ARE
SoftServe is a leading technology solutions company specializing in software products, application development, and services. Our mission is to be a valuable partner for our clients (from start-ups to large enterprises) – we measure our success by our client's success. We are a 13,000+ team across the globe and are passionate about the development of advisory and consulting services.
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 problem-solving 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, event-driven 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, domain-driven 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).

Life's too short for bad jobs.
Sign up for free and find jobs that are truly your match.