Open Systems Technologies

About the Company

Open Systems Technologies is a tier-one vendor for the world's most competitive financial and technology companies, offering both full-time and contract recruiting services across the country. We offer a positive, entrepreneurial, high performing culture where all employees have the unique opportunity to run a full desk. Our office looks, feels, and operates like a start-up, but with the stability, clientele, and resources that only an industry veteran can provide.

At our core, we are structured to be flexible. With over 30 years of experience, OST has been able to stand the test of time and remains the leading provider of IT staffing solutions in NY due to our forward thinking and adaptability through fluctuating job markets and evolving work cultures.

Open Systems Technologies is an Equal Opportunity Employer. All decisions regarding employment will be made without regard to age, race, color, religion, creed, sex, sexual orientation, gender identity or expression, national origin, marital status, the presence of any physical or mental disability, or any other status or characteristic protected by federal, state or local law.

Listed Jobs

Company Name

Open Systems Technologies

Job Title

Data Integration Specialist

Job Description

**Job title:** Data Integration Specialist **Role Summary:** Design, develop, and optimize robust ETL workflows using SSIS, SQL Server, and Python to support high‑volume financial data environments. Lead data pipeline construction, performance tuning, and integration across disparate systems while ensuring data integrity, lineage, and regulatory compliance. **Expectations:** - Deliver scalable, high‑performance ETL solutions that meet financial reporting and analytics needs. - Maintain rigorous data quality, auditability, and security standards. - Collaborate cross‑functionally and document solutions for maintainability. **Key Responsibilities:** - Design, build, and maintain SSIS packages and T‑SQL scripts for large‑scale data extraction, transformation, and loading. - Write Python scripts for advanced transformations, automation, and data quality checks. - Translate business requirements into technical design and scalable solutions. - Optimize package performance, troubleshoot issues, and monitor execution metrics. - Use Git for version control and integrate ETL processes into CI/CD pipelines. - Produce and maintain technical documentation, data dictionaries, and process flow diagrams. **Required Skills:** - 8+ years of hands‑on data integration/ETL experience. - Advanced expertise in SSIS, SQL Server, and T‑SQL. - Proficiency in Python for data processing and automation. - Experience in finance or investment banking environments with high‑volume transactional data. - Familiarity with Git and CI/CD workflows for data deployment. - Strong analytical, problem‑solving, and communication abilities. **Required Education & Certifications:** - Bachelor’s degree in Computer Science, Information Systems, or related field. - Relevant certifications (e.g., Microsoft Certified: Azure Data Engineer Associate, SSIS Developer).

Mississauga, Canada

Hybrid

Senior

28-10-2025

Company Name

Open Systems Technologies

Job Title

Application Production Support Analyst

Job Description

**Job Title:** Application Production Support Analyst **Role Summary:** Provide day‑to‑day operational support for legal, regulatory, and reporting application batch processes. Diagnose and resolve failures on Unix/Linux platforms, write and troubleshoot SQL and Python code, and coordinate with development and vendor teams to meet SLA requirements. **Expectations:** - Minimum 3–4 years of production support experience. - Strong command‑line, Unix/Linux, SQL, and Python proficiency. - Experience with batch scheduling tools (Autosys preferred). - Ability to analyze production failures, perform root‑cause analysis, and implement preventive measures. - Excellent written and verbal communication, prioritization, and ticketing (ServiceNow) skills. **Key Responsibilities:** - Monitor daily batch runs, perform start‑of‑day checks, and ensure timely completion. - Investigate, triage, and resolve production incidents and outages. - Liaise with internal technology groups, vendors, and users to maintain seamless communication. - Manage ticket system, documenting issues, resolutions, and best‑practice solutions. - Participate in application releases: build, test, deploy, and post‑deployment support. - Update technical support documentation and provide knowledge transfer to teams. **Required Skills:** - Unix/Linux system administration, shell scripting. - Advanced SQL development (complex DML, performance tuning). - Python scripting for automation. - Scheduling tool knowledge (Autosys, Cron). - ETL concepts (experience with Ab Initio or similar). - Ticketing systems (ServiceNow) and monitoring tools. - Strong analytical, decision‑making, and communication abilities. **Required Education & Certifications:** - Bachelor’s degree (B.E./B.Tech) in Computer Science, Information Technology, or related engineering field. - First‑class academic standing. - Certifications such as Certified Unix Professional or Microsoft SQL Server/Oracle DBA are advantageous but not mandatory.

Irving, United states

Hybrid

Junior

02-11-2025

Company Name

Open Systems Technologies

Job Title

Data Quality Analyst

Job Description

**Job title** Data Quality Analyst **Role Summary** Lead data quality management for banking business lines, owning processes, reports, and remediation initiatives. Drive compliance with regulatory and internal standards, act as subject‑matter expert, and influence cross‑functional teams to improve data integrity and operational efficiency. **Expectations** - 6–10 years of experience in data quality programs within large banks or Big‑Four consulting. - Deep understanding of Client ICM, Capital Markets, Commercial Banking, Security & Issuer Services, Research, Reference, and Master Data. - Proven ability to resolve complex data quality issues and control risks, ensuring adherence to policies and regulations. **Key Responsibilities** - Own and manage data quality processes and remediation projects across multiple business lines. - Analyze and resolve intricate data problems, interpreting policies and guidelines. - Prepare status reports for working groups, steering committees, and executives. - Supervise junior staff and provide technical guidance. - Assess risk in business decisions, uphold compliance, and report control issues transparently. - Present balanced analyses to stakeholders, senior management, and IT partners. - Collaborate with global functions (Finance, Risk, Compliance) to maintain a Controlled Data Management Environment. **Required Skills** - Implementation and governance of data quality programs. - Expertise in banking data domains (ICM, Capital Markets, Commercial Banking, etc.). - Strong analytical, problem‑solving, and organizational abilities. - Excellent communication and diplomacy skills for influencing cross‑functional stakeholders. - Ability to work under pressure, manage competing priorities, and deliver high‑quality work. **Required Education & Certifications** - Bachelor’s degree (Master’s preferred). - Data Quality/Data Management certification (preferred).

Irving, United states

Hybrid

Mid level

02-11-2025

Company Name

Open Systems Technologies

Job Title

Data Analyst

Job Description

**Job Title:** Data Analyst **Role Summary:** Senior business‑facing analyst in a cross‑functional strategic program. Translate stakeholder questions into data insights, design and maintain Power BI dashboards, and support data‑driven decisions that drive process and technology improvements. **Expectations:** - Become a trusted analytics partner, delivering accurate dashboards and actionable insights. - Establish repeatable measurement processes for pilots, launches, and process improvements. - Collaborate with data engineering to ensure data quality and a single source of truth. **Key Responsibilities:** - Partner with program leads, product, operations and engineering to define business problems and success metrics. - Own day‑to‑day reporting: design, build and maintain Power BI dashboards and operational reports. - Conduct hands‑on data analysis using SQL and Excel to explore trends, validate hypotheses, and quantify opportunities. - Present data‑driven stories and actionable recommendations to non‑technical audiences. - Support A/B test design, cohort definition, outcome calculation and significance assessment for pilots and post‑launch measurement. - Document data sources, definitions and analysis processes; maintain program metrics repository. - Work with data engineering/analytics engineering to ensure data quality, perform required transformations and prioritize new data requirements. - Identify and mitigate data or reporting risks, escalating issues with clear mitigation plans. **Required Skills:** - 3–5 years of business‑facing analytics or program analytics experience. - Strong SQL skills; ability to write complex queries against production data. - Advanced Excel (pivot tables, lookups, formulas) for ad‑hoc analysis. - Hands‑on experience building and maintaining interactive dashboards in Power BI. - Excellent communication; ability to translate analysis into concise recommendations for business stakeholders. - Proven record of cross‑team collaboration delivering insights that drive operational or process improvements. **Required Education & Certifications:** - Bachelor’s degree in Data Analytics, Statistics, Computer Science, Business Analytics or a related quantitative field. - (No specific certifications required.)

Philadelphia, United states

Hybrid

04-11-2025