Senior Data Engineer (Capacity & Forecasting Systems)

We at Sigma Software are looking for a skilled Senior Data Engineer to join an exciting short-term project with a US-based customer. This is a remote position, offering you the flexibility to work from anywhere while contributing to a high-impact data platform.

In this role, you will take ownership of designing and optimizing the data foundation for an automated storage capacity forecasting platform. You’ll work with modern technologies, collaborate with experienced engineers, and have the opportunity to influence both technical and process decisions.

Why join us? At Sigma Software, you’ll work in a culture that values innovation, encourages knowledge sharing, and offers the chance to make a real impact on projects used by thousands of businesses worldwide.

CUSTOMER
Our customer is ConnectWise — a US-based software company providing business automation solutions for Managed Service Providers (MSPs). ConnectWise offers a suite of tools for IT service management, cybersecurity, remote monitoring, and business process automation. Their solutions are used globally by thousands of MSPs to streamline operations, improve service delivery, and enhance security for small and medium-sized businesses (SMBs).

PROJECT
The project focuses on building an automated storage capacity forecasting platform for MSPs. The platform will model historical infrastructure data, enable predictive insights, and support lifecycle planning for hardware and storage resources.
It will integrate PostgreSQL, Python-based ETL pipelines, and PowerBI analytics to deliver accurate capacity forecasts and actionable reports for an 18-month planning horizon. The work environment encourages technical ownership, process improvement, and collaborative problem-solving with the customer’s engineering team.

• Design and optimize PostgreSQL data models for historical capacity and lifecycle tracking
• Build and maintain robust ETL pipelines using Python for structured and semi-structured (JSON) data
• Aggregate and structure data by Region, Node Type, and time dimensions
• Support time-series analysis and capacity forecasting use cases
• Develop and enable PowerBI datasets, models, and reports based on clean, reliable data
• Ensure data quality, performance, and scalability across the pipeline
• Translate infrastructure and business requirements into scalable data solutions
• Collaborate closely with software developers and stakeholders on end-to-end data workflows

• At least 5 years of experience as a Data Engineer or in a similar data-focused role
• Strong proficiency in SQL and relational databases, preferably PostgreSQL
• Solid experience with Python for data transformation and pipeline development
• Hands-on experience working with JSON and semi-structured data formats
• Proven track record of building and optimizing ETL processes
• Practical experience with PowerBI, including dataset modeling and report creation
• Experience working with time-series and historical datasets
• Strong understanding of data modelling principles for analytics and forecasting
• Upper-Intermediate level of English 

WILL BE A PLUS:

• Experience with Kibana or other BI / visualization tools
• Familiarity with monitoring, infrastructure, or capacity planning data
• Exposure to forecasting techniques or growth trend analysis
• Experience integrating data from metrics and inventory systems

PERSONAL PROFILE:

• Analytical mindset, able to reason about data trends and anomalies beyond raw numbers
• Strong stakeholder collaboration skills, translating business and infrastructure needs into actionable data models and reports
• High attention to detail and data quality, with a strong sense of ownership and accountability