DWH Developer-Analyst for the team

DOM.RF DWH Developer-Analyst for the team Work format: remote possible

☑️ Responsibilities -Conduct project communication with business customer representatives to clarify business requirements -Identify and analyze business requirements, needs, and problems of the business customer -Formulate requirement specifications, descriptions of logical models, data structures, and design solutions (data warehouses and data marts) -Coordinate design solutions with architects, developers, and analysts from related teams -Design and develop ETL/ELT processes, warehouse layers, and data marts -Develop and optimize SQL queries -Conduct internal testing and quality control of information products implemented by developers -Participate in acceptance testing of information products and documentation with customers -Ensure data quality control and integrity

☑️ Our requirements for candidates -Higher education: technical, mathematical, or financial -At least 5 years of experience -Proficient knowledge of Python, GIT, Airflow (DAGs with task decomposition, dependencies, sensors) -In-depth knowledge of SQL: window functions, procedures, functions, nested queries, query optimization experience -Understanding of indexes, partitions, keys, normal forms, SCD -Understanding of data modeling, data warehouse construction, data replication, and consistency -Ability to refactor code and migrate from one system to another -Knowledge of CI/CD principles -Will be a plus: -Knowledge of PL/SQL for Oracle, Postres, Greenplum or experience with other MPP DBMS -Experience with API -Knowledge of OOP, DBT, Kafka, Bash, SAS, development of custom Airflow operators

Contacts: recruiter contact