DWH System Analyst

We are an accredited IT company, BI Consult. 16 years in the Data sphere: BI system integration, DWH construction, our own Training Center, Gromov Circles research project. We are inviting a System Analyst with DWH project implementation experience to our team.

Description

BI Consult

BI Consult – where data turns into solutions.

• Collecting, analyzing, and formalizing requirements for data loading, transformation, and consolidation into the warehouse
• Designing DWH architecture and integration solutions for heterogeneous data sources (internal accounting systems, 1C, etc.)
• Developing data models and implementing them in transformation tools (dbt)
• Analyzing source report structures, describing the logic of indicator formation, and preparing requirements for data transfer to the warehouse
• Describing integration scenarios: data sources, transformation rules, data quality checks, and requirements for data marts
• Preparing technical specifications and integration schemes
• Decomposing requirements into tasks for developers, coordinating assignments with business stakeholders and architects

• Willingness to work in an office format in Saint Petersburg (flexible start time from 8:00 to 11:00)
• 3+ years of commercial experience as a System Analyst
• Experience in designing DWH and integration solutions for heterogeneous data sources
• Knowledge and practical application of data modeling methodologies (Kimball, Inmon, Data Vault 2.0, etc.)
• Experience in developing data models using dbt (or similar transformation tools)
• Knowledge of ETL tools (Airflow, NiFi)
• Solid SQL knowledge (analytical functions, query optimization, stored procedures)

• Reliability and comfort: Official employment according to the Labor Code, white salary (level determined based on interview results). An office where you can work peacefully and spend time with teammates
• Development and expertise: Unlimited number of courses in the BI Consult Training Center. Access to certifications from leading vendors. Courses from our partners
• Variety: Wide tech stack, work with well-known clients and modern technologies. Opportunity to participate in our research project "Gromov Circles."
• Employee care: Voluntary medical insurance (comfort +). Yoga during lunch breaks. 1-to-1 meetings, performance reviews, open dialogue with the team
• Joint leisure: Tech meetups, book club, large corporate events. Traditions – from various tournaments to Newcomers' parties