No applications. Teams find and message you directly.
✓ Direct apply: you message the hiring person. No ATS.
DOM.RF is looking for a Senior Data Warehouse Developer with at least 5 years of experience. The role involves project communication, business requirement analysis, and ETL/ELT process development.
DOM.RF is looking for a Senior Data Warehouse Developer with at least 5 years of experience. The role involves project communication, business requirement analysis, and ETL/ELT process development.
Responsibilities
- Conduct project communication with business representatives to clarify business requirements
- Identify and analyze business requirements, needs, and issues
- Formulate requirement specifications, logical models, data structures, and project solutions (data warehouses and data marts)
- Coordinate project solutions with architects, developers, and analysts from adjacent teams
- Design and develop ETL/ELT processes, data 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 clients
- Ensure data quality control and integrity
Requirements
- Higher education: technical, mathematical, or financial
- At least 5 years of work experience
- Proficient knowledge of Python, GIT, Airflow (DAG with task decomposition, dependencies, sensors)
- Deep knowledge of SQL: window functions, procedures, functions, nested queries, experience in query optimization
- Understanding of indexes, partitions, keys, normal forms, SCD
- Understanding of data modeling, warehouse construction, replication, and data consistency
- Ability to refactor code and migrate from one system to another
- Knowledge of CI/CD principles
- Knowledge of PL/SQL for Oracle, Postgres, Greenplum or knowledge of other MPP DBMS (a plus)
- Experience with APIs (a plus)
- Knowledge of OOP, DBT, Kafka, Bash, SAS (a plus)
✓ Direct apply: you message the hiring person. No ATS.