Current jobs related to Data Integration Specialist - Schenectady, New York - Brandon Consulting Associates, Inc.


  • Schenectady, New York, United States MVP Health Care Full time

    Job DescriptionTechnical Business Analyst Encounter Data Integrity & DeliveryMVP Health Care is seeking a skilled Technical Business Analyst to join our team. As a key member of our organization, you will be responsible for ensuring the accuracy and integrity of our encounter data.Key Responsibilities:Reconcile encounter data and provide root cause analysis...


  • Schenectady, New York, United States Union College Full time

    Job Summary:Maintains accurate and up-to-date information related to fundraising and constituent data within the College Relations department. Focuses on managing and ensuring data integrity, generating reports, and supporting fundraising efforts.Key Responsibilities:Manages and ensures data integrity, generating reports, and supporting fundraising...

  • Data Architect

    1 week ago


    Schenectady, New York, United States IMG Information Management Group, Inc. Full time

    Job DescriptionIMG is seeking a highly skilled Data Engineer to join our team. The ideal candidate will have a strong background in data engineering, with experience in designing, developing, and deploying data systems.The successful candidate will possess excellent communication skills, be able to thrive in a dynamic environment, and have a strong drive to...


  • Schenectady, New York, United States MVP Health Care Full time

    About the RoleMVP Health Care is seeking an experienced Enterprise Architect to lead our interoperability and integration efforts. As a key member of our team, you will be responsible for designing and implementing solutions that connect disparate systems, applications, and data sources in a seamless and composable way.Key ResponsibilitiesDevelop and...


  • Schenectady, New York, United States MVP Health Care Full time

    About the RoleMVP Health Care is seeking an Enterprise Architect for Interoperability and Integration to join our team. As a key member of our organization, you will play a critical role in shaping the future of healthcare by designing and implementing interoperability and integration solutions that connect disparate systems, applications, and data sources...


  • Schenectady, New York, United States MVP Health Care Full time

    Enterprise Architect for Interoperability and IntegrationMVP Health Care is seeking an Enterprise Architect for Interoperability and Integration to join our team. As a key member of our organization, you will be responsible for developing and maintaining the enterprise architecture framework, focusing on interoperability and integration. You will design...


  • Schenectady, New York, United States MVP Health Care Full time

    Enterprise Architect for Interoperability and IntegrationMVP Health Care is seeking an experienced Enterprise Architect to lead the development and implementation of interoperability and integration solutions across our organization. As a key member of our IT team, you will be responsible for designing and maintaining our enterprise architecture framework,...

  • Data Engineer

    1 week ago


    Schenectady, New York, United States Information Management Group Full time

    About the Role:Information Management Group is seeking a highly skilled Data Engineer to join our team of technical experts. As a Data Engineer, you will play a critical role in designing, developing, testing, documenting, deploying, and managing data systems.Key Responsibilities:Design and develop data architectures and systemsImplement data integration and...


  • Schenectady, New York, United States Information Management Group Full time

    Protect computer networks, systems, and data integrity as a Cybersecurity Specialist with Top Secret Clearance. Implement Risk Management Framework, audit IT development and monitoring principles, and strategize control reviews.Perform routine IT tasks with varying degrees of complexity, including monitoring system vulnerabilities, data encryption, and...


  • Schenectady, New York, United States Union College Full time

    Job SummaryThe Advancement Information Services Specialist plays a critical role in maintaining accurate and up-to-date information related to fundraising and constituent data within the College Relations department. This position focuses on managing and ensuring data integrity, generating reports, and supporting fundraising efforts.Key...


  • Schenectady, New York, United States The Golub Corporation - Price Chopper Supermarkets Full time

    The IT Operations Specialist will be responsible for data entry, scanning, and Mainframe related production printing. Key responsibilities include managing multiple tasks, utilizing various office equipment, and ensuring accurate data entry. This role requires attention to detail and the ability to work independently. The ideal candidate will have experience...


  • Schenectady, New York, United States US Tech Solutions Full time

    Marketing Solutions SpecialistThis role will contribute to the development of marketing solutions and campaigns for the Front Store Marketing team, with a concentration in the Price Value initiative in the Raleigh-Durham market. As a subject matter expert in the geographical region, you will conduct local research and provide insights on how to maximize...


  • Schenectady, New York, United States Lynkwell Full time

    Lynkwell, a leading EV charging technology and e-mobility company, is seeking a skilled Technical Implementation Specialist to join its team. The ideal candidate will have a strong analytical mindset, excellent communication skills, and a passion for delivering high-quality products that exceed customer expectations.The Technical Implementation Specialist...


  • Schenectady, New York, United States Schenectady City School District Full time

    Job Title: Information Processing Specialist IJob Summary:The Schenectady City School District is seeking a highly skilled Information Processing Specialist I to join our team. This role involves operating information processing equipment to record, edit, store, and revise correspondence, reports, and other data.Key Responsibilities:Operate information...


  • Schenectady, New York, United States GE Vernova Full time

    Job Description SummaryGE Vernova Wind Services is seeking a talented Data Analytics Intern to join our team. As a Data Analytics Intern, you will have the opportunity to work on hands-on data projects, enhance your business and professional skills, and learn from the best in the industry.What You'll DoWork on assignments similar to data governance,...


  • Schenectady, New York, United States Archway Physician Recruitment LLC Full time

    Cardiology Specialist OpportunityWe are seeking a skilled and motivated Cardiology Specialist to join our esteemed team on a full-time basis. As a Cardiology Specialist with our organization, you will play a pivotal role in delivering advanced cardiovascular care to our patients.Responsibilities:Perform diagnostic and interventional cardiac procedures,...

  • Ergonomics Specialist

    2 weeks ago


    Schenectady, New York, United States ATI Physical Therapy Full time

    Job Title: Ergonomic SpecialistJob Summary:ATI Physical Therapy is seeking an experienced Ergonomic Specialist to join our team. As an Ergonomic Specialist, you will play a critical role in identifying potential risks for musculoskeletal (MSK) injuries and developing strategic actions to mitigate these risks. You will work closely with our clients to develop...


  • Schenectady, New York, United States Transfinder Full time

    Job Title: Software Support SpecialistThis is a remote position.Software Support Specialist (2 Openings) Pay Status and Classifications: Exempt, Regular Full Time Supervisor Title: Support Services Manager Work location: Remote in New York or Texas. If in New York and local to company headquarters there are days the Software Support Specialist...


  • Schenectady, New York, United States Marathon TS Full time

    Job Title: Declassification SpecialistAbout the Role:Marathon TS is seeking a skilled Declassification Specialist to support a client in the field of nuclear propulsion. As a key member of our team, you will be responsible for reviewing technical program records in accordance with Executive Order 13526, as amended. Responsibilities:Review and analyze...


  • Schenectady, New York, United States DirectEmployers Full time

    Job Summary:DirectEmployers is seeking a skilled Clinical Care Specialist to join our team. As a Clinical Care Specialist, you will be responsible for providing high-quality patient care in the acute care setting.Key Responsibilities:Evaluate patient assessment data and establish nursing diagnoses.Develop individualized patient care plans based on patient...

Data Integration Specialist

2 months ago


Schenectady, New York, United States Brandon Consulting Associates, Inc. Full time
Job Description

**Job Summary**

Brandon Consulting Associates, Inc. is seeking a highly skilled Data Integration Specialist to join our team. As a key member of our data analytics team, you will be responsible for designing and developing a large-scale data integration system that extracts, transforms, and loads data from external OLAP databases to our internal systems.

Key Responsibilities:

  1. Design and develop SSIS packages and projects using Microsoft Visual Studio to ensure efficient data transfer and processing.
  2. Extract data from various sources, including databases, spreadsheets, flat files, and APIs, to support business intelligence and data analytics initiatives.
  3. Develop and maintain database stored procedures and functions to optimize data storage and retrieval.
  4. Contribute to the design of a data warehouse architecture that supports data storage, retrieval, and analysis, aligning with business objectives.
  5. Optimize query performance by creating indexes to ensure fast data retrieval and analysis.
  6. Diagnose and troubleshoot data issues on application reports using Crystal Reports to ensure data accuracy and integrity.
  7. Report status of current tasks and outstanding issues to the supervisor to ensure seamless project execution.

Requirements:

  • 7+ years of experience in ETL (Extract, Transform, and Load) using SQL Server SSIS objects.
  • Strong expertise in SQL Server programming, including views, stored procedures, and functions.
  • 5+ years of experience in data warehousing and OLAP (On-line Analytical Processing) to support business intelligence and data analytics initiatives.