Mid Level Subject Matter Expert Jobs

INTRODUCTION

MatchPoint is a fast-growing, young, energetic global IT-Engineering services company with clients across the US. We provide technology solutions to various clients like Uber, Robinhood, Netflix, Airbnb, Google, Sephora and more! More recently, we have expanded to working internationally in Canada, China, Ireland, UK, Brazil and India. Through our culture of innovation, we inspire, build, and deliver business results, from idea to outcome. We keep our clients on the cutting edge of the latest technologies and provide solutions by using industry specific best practices and expertise. We are excited to be continuously expanding our team. If you are interested in this position, please send over your updated resume. We look forward to hearing from you!

ROLE AND RESPONSIBILITIES

Job: SigmaFlow Subject Matter Expert (SME)
Location: Remote USA
Duration: 6+ Months
Rate: $95 to $100 per hour

Job Summary

We are seeking a highly skilled SigmaFlow Subject Matter Expert (SME) with experience in database technologies and to support, optimize, and extend SigmaFlow-based data pipelines and workflows. This role will serve as the technical authority for SigmaFlow implementations, ensuring reliable data ingestion, transformation, analytics, and integration with enterprise systems. The ideal candidate combines hands-on engineering skills with architectural insight, and can partner effectively with data engineers, platform teams, and business stakeholders to deliver scalable, performant, and secure data solutions.

Key Responsibilities

• SigmaFlow Platform Ownership
• Act as the primary technical authority for SigmaFlow design, configuration, and operational best practices
• Design, implement, and maintain SigmaFlow workflows for batch and near-real-time data processing
• Optimize existing SigmaFlow pipelines for performance, reliability, and scalability

• Troubleshoot and resolve complex workflow failures, data quality issues, and performance bottlenecks

• Database & Data Engineering

• Design and maintain integrations between SigmaFlow and relational and non-relational databases (e.g., Oracle, PostgreSQL, SQL Server, MySQL, Snowflake, or similar)
• Develop efficient SQL queries, stored procedures, and data models to support analytics and downstream applications
• Ensure data integrity, lineage, and consistency across multiple data sources

• Support large-volume data ingestion, transformation, and archival strategies

• Integration & Architecture

• Collaborate with enterprise architects to design end-to-end data flow architectures
• Integrate SigmaFlow with upstream and downstream systems such as OMS, ADMS, AMI, GIS, and enterprise data lakes (where applicable)
• Support CI/CD pipelines for SigmaFlow and Python-based deployments

• Ensure solutions align with security, compliance, and governance standards

• Operations & Support

• Provide Tier 3 / SME-level support for production incidents and platform issues
• Participate in root cause analysis (RCA) and implement long-term corrective actions
• Create operational runbooks, standards, and technical documentation
• Mentor engineers and analysts on SigmaFlow, Python, and database best practices

BASIC QUALIFICATIONS

Technical Skills

- 5+ years of experience in data engineering, workflow orchestration, or analytics platforms
- Demonstrated hands-on expertise with SigmaFlow (design, configuration, troubleshooting)
- Some understanding of Python for data processing, automation, and integrations
- Advanced proficiency in SQL and relational database design
- Experience working with large datasets and high-availability data platforms

Platform & Tooling

- Experience with Linux-based environments
- Familiarity with version control systems (Git)
- Experience with job scheduling, workflow orchestration, or ETL tools
- Understanding of monitoring, logging, and alerting practices

MatchPoint Solutions provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.