Analytics Engineer

About the company:
Softermii (https://www.softermii.com/) is an outsourcing/outstaffing company with more than 11 years of experience in web and mobile application development with a team of more than 120 specialists from 6 countries.

We have withstood multiple challenges, such as COVID-19 pandemic and war aggression against Ukraine, we have secured sustainable development processes, saved all our projects and jobs. Even more – we’re constantly growing.
Every day we add new project to our portfolio in the following areas of expertise:
Healthcare
Real estate
Livestream E-commerce
Fintech (WealthTech, Capital Trading)
Real-Time Communications (RTC)
In addition, we develop 2 of our own solutions that help our customers get faster applications for video or audio calls (https://www.softermii.com/solutions/vidrtc) or an application for real estate with 3D visualization (https://www.softermii.com/solutions/apartmii)
Company’s mission:
Softermii: Succeed Without (L) imitations
We will turn any idea into a valuable product.
Our plans as a company:
We want to move from a regular outsourcing business to an ecosystem of outsourcing, education, and product development companies.
Over the years, we have arrived at a highly personalized working model with transparent workflows. This model allows us to create software products that meet our clients’ goals with precision.
We operate in an AI-assisted development environment, where engineering thinking, logical validation, and responsibility for business outcomes are more important than simply writing code.
________________________________________________________________________________________________________________________________________________________________
📲Project:
The technology platform in the field of commercial real estate, which helps the company find, evaluate and purchase "last mile" objects throughout the United States. The platform combines data, analytics, risk models and investment algorithms to accelerate and automate the decision-making process in real estate investments.
Type of cooperation: Full-time.
‼️Work schedule: 1:00РM-8:00PM CET (After the start of cooperation, it can be discussed)
Team👨‍💻: 3-4 data engineers and analytics on the client side
⚡️Your responsibilities on the project will be:
Build and maintain SQL views, stored procedures, and transformation logic that convert raw source data into clean, reliable financial, operational, and portfolio analytics;
Develop and maintain data warehouse objects following dimensional modeling best practices – fact tables, dimension tables, and SCD patterns;
Work within our AWS environment – including Redshift as our core data warehouse and supporting infrastructure on S3 and Athena;
Extend and maintain Python-based pipelines supporting data ingestion, validation, automation, and output delivery;
Support quarterly and ad hoc reporting runs – troubleshoot issues, validate outputs, and coordinate with finance and asset management teams on discrepancies
Maintain data lineage documentation, calculation logic, and DDL registries so the team always knows what runs, why, and how;
Use Git for version control – branching, reviewing, and merging code changes following team standards;
Build BI-ready views consumed by dashboards and downstream reporting tools
Help extend our data lake infrastructure as new data products and business domains are onboarded;
Leverage AI coding tools (such as Claude Code or similar) to accelerate development, improve code quality, and document logic more effectively.
🕹Tools we use: Git, Figma, AI-assisted dev tools (Claude Code, Etc).
🗞Our requirements to you:
2+ years of hands-on SQL experience – comfortable writing complex queries, CTEs, window functions, and aggregations
Solid understanding of data warehousing concepts – fact/dimension modeling, SCD Type 1/2, ETL vs ELT.
2+ years of hands-on experience with a modern cloud DWH (Redshift, Snowflake, BigQuery, Databricks SQL, or similar)
Experience building or migrating a production project in dbt Core (the free/CLI version, not dbt Cloud)
Familiarity with Git – branching, pull requests, merge conflicts, meaningful commit messages
Comfort using AI coding assistants (Claude Code, GitHub Copilot, or similar) as part of a modern development workflow
Strong attention to detail – the outputs you produce inform real business decisions
Strong English communication skills – В2/C1 level
🗞Nice to Have:
Familiarity with Microsoft Fabric or the broader Microsoft data stack (Azure Data Factory, Synapse, Power BI)
Familiarity with data management principles – data quality frameworks, data lineage tracking, and metadata management
Familiarity with real estate finance concepts – NOI, Cap Rate, IRR, fund structures
Experience with Yardi, MRI, or other property management / accounting systems
Exposure to Airflow or similar orchestration tools
Understanding of GAAP / accrual accounting basics
Working knowledge of Python for data pipelines – file I/O, scripting, automation and validation (not required, but a strong plus)
Experience reading or reconciling financial statements – P&L structure, GL account hierarchies, balance sheet vs income statement concepts

👨‍💻Who will you have the opportunity to meet during the hiring process (stages):
call, HR interview, Technical interview on the client side, Final interview
🥯What we can offer you:
We have stable and highly-functioning processes – everyone has their own role and clear responsibilities, so decisions are made quickly and without unnecessary approvals.
You will have enough independence to make decisions that can affect not only the project but also the work of the company.
We are a team of like-minded experts who create interesting products during working hours and enjoy spending free time together.
Do you like to learn something new in your profession? We will be happy to pay 50% of the cost of courses/conferences.
Do you want an individual development plan? We will form one especially for you + you can count on mentoring from our seniors and leaders.
Do you have a friend who is currently looking for new job opportunities? Recommend them to us and get a bonus.
Do you want to volunteer? We will add you to a chat, where we can get a bulletproof vest, buy a pickup truck or send children's drawings to the front.
And we have the most empathetic HRs (who also volunteers!). So we are ready to support your well-being in various ways.
👨‍🏫A little more information that you may find useful:

• our adaptation period lasts 3 months, this period of time is enough for us to understand each other better;
• there is a performance review after each year of our collaboration where we use a skills map to track your growth;
• we really have no boundaries in the truest sense of the word – we have flexible working day is up to you.

Of course, we have a referral bonus system. So if you have a friend who likes our job opening, you can give us their telegram contact, and we in turn will thank you with a bonus if we start working with them!