Middle ETL Developer / Data Engineer

• Previous years of experience and a substantial understanding of data ingestion frameworks, data processing (CDC, ETL) frameworks, pipeline orchestration technologies, data storage engines, data access/warehousing tools.
• Understanding the strengths and weaknesses of each tool/service and what it’s best used for
• Proficiency in software development in Python or Java
• Deep familiarity with SQL
• Good understanding of distributed systems in general and how they are different from traditional storage and processing systems
• Experience with data visualization tools like Tableau will be a big plus

Job Responsibilities:

• Design, develop, and test data management related solutions
• Create and maintain optimal data pipeline architecture; build data pipelines to pull data from different source systems; integrate, consolidate, transform, and cleanse data according to business rules, and structure and for use by analytics applications
• Review business requirements; map reports, data subjects, and entities to source systems and artifacts in the Enterprise Data Warehouse (EDW) and/or Data Lake (DL)
• Strong data analysis skills
• Demonstrated experience with complex T-SQL including stored procedures, nested queries, and data transformation.
  •Document requirements and business rules into appropriate technical specifications
• Plan, test and implement enhancements to the EDW and DL environments on a regular release cycle
• Participate in work planning and estimation
• Present technical solutions to various stakeholders
• Perform data validation and quality assurance
• Provide day-to-day support of the EDW and DL environments, with excellent customer service to internal clients, monitor new deployments and services, escalating issues where appropriate
• Develop and maintain sufficient support documentation to facilitate day-to-day support of the EDW and DL environments
• Microsoft SQL Server DBMS
• Microsoft Business Intelligence stack: SSIS, SSAS Tabular Model (DAX), SSRS (SQL, MDX)
• TSQL or equivalent for purposes of ad-hoc analysis, creation/interpretation of complex stored procedures
• Tools and Software experience
• Tableau (creation of data sources, Tableau Server administration)
• AWS-based technologies such as: S3, Glue, Lambda, Lake Formation, CloudFormation, Athena
• Working with modern data warehouses (Azure Synapse Analytics, Google BigQuery, Snowflake)
• Data streaming technologies (Kafka/ksqlDB, StreamSets, Kinesis, etc.), stream processing, event-driven architectures, real-time data warehouses
• Jenkins Pipelines
• PostgreSQL
• IntelliJ IDEA
• Modern programming languages (Python, Java, Scala, C#, etc.)
• Excellent verbal and written skills in English.

What We Offer

• Exciting Projects: Come take your place at the forefront of digital transformation! With clients across all industries and sectors, we offer an opportunity to participate in creating market-defining products using the latest technologies.
• Collaborative Environment: Expand your skills by collaborating with a diverse team of highly talented people in an open, laidback environment — or even abroad in one of our global centers or client facilities!
• Work-Life Balance: GlobalLogic prioritizes work-life balance, which is why we offer flexible opportunities and options.
• Professional Development: Our dedicated Learning & Development team regularly organizes certification and technical / soft skill training to help you realize your professional goals.
• Excellent Benefits: We provide our consultants with competitive compensation and benefits
• Fun Perks: We want you to love where you work, which is why we host sports classes, cultural, social and team building activities such as sports competitions and end-of-year corporate parties. Our vibrant offices also include dedicated GL Zones and rooftop decks where you can drink coffee or tea with your colleagues over a game of table football or darts!