About the company:
Softermii (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 (www.softermii.com/solutions/vidrtc) or an application for real estate with 3D visualization (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.
‼️Time zone: EST
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, pu
