Data Integration Specialist

1 week ago


Grove City, Ohio, United States Western Alliance Bank Full time
About the Role

Western Alliance Bank 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, developing, and deploying data extracts, transformations, and loads using Azure Data Factory and SSIS packages.

Key Responsibilities
  • Design and develop data warehouse ETL processes in SSIS & SQL stored procedures
  • Analyze business user requirements and design data flow to implement ETL process using Microsoft SSIS tool
  • Develop reports using SSRS & SQL stored procedures
  • Analyze and provide suggestions to tune database stored procedures to ensure optimal performance
  • Troubleshoot and fine-tune database configurations, ETL processes, and SQL code for optimal performance
  • Set and maintain database standards
  • Recommend and implement emerging database solutions
  • Contribute to continuous improvements of existing applications
  • Conduct code reviews
  • Develop SQL server stored procedures to implement business logic
  • Follow bank processes and procedures for each development cycle
  • Maintain documentation patterns for all applications
  • Adhere to all data security and integrity policies
  • Actively participate in all aspects of the software engineering process
Requirements
  • 7+ years of solid experience in SQL development
  • 7+ years of hands-on experience in ETL design and development using Microsoft SQL server ETL tools or Informatica
  • 5+ years of experience in database administration
  • 4+ years of experience in Azure data factory
  • Good understanding of data cleansing, normalization, standardization, enrichment, fuzzy match techniques, and data governance concepts
  • Excellent troubleshooting and problem-solving skills
  • Outstanding SQL and data analysis skills
  • Experience in analyzing and building reports/dashboards using BI reporting tools such as Tableau
  • Experience in BI development, database development, and SQL database
  • Good understanding of development life cycle, data architect, and related methodologies


  • Ohio City, Ohio, United States Westfield Full time

    About the RoleWe are seeking a highly skilled Data Warehousing Specialist to join our team at Westfield. As a key member of our IT department, you will be responsible for designing, building, and managing custom data pipelines and ETL processes to support our data warehousing initiatives.Key ResponsibilitiesData Pipeline Design and Development: Design and...


  • Ohio City, Ohio, United States Worldpay Full time

    About the RoleWe are seeking a highly skilled ITSM Data Reporting Analyst to join our rapidly growing Governance, Improvement & Reporting (GIR) team at Worldpay. As a key member of this team, you will play a critical part in defining and driving the global implementation of ITSM data collection, management, analysis, and reporting.Key ResponsibilitiesForm an...


  • Plain City, Ohio, United States PCR Staffing Full time

    About the RoleWe are seeking a highly skilled Data Center Installation Specialist to join our team at PCR Staffing. As a Data Center Installation Specialist, you will be responsible for installing, maintaining, and troubleshooting network infrastructure in a data center environment.Key ResponsibilitiesInstallation and Maintenance: Install, maintain, and...


  • Grove City, Ohio, United States Hazelden Betty Ford Full time

    {"title": "Development Operations Specialist", "content": "Job SummaryThe Hazelden Betty Ford Foundation is seeking a highly skilled Development Operations Specialist to join our team. As a key member of our Development team, you will be responsible for managing and reporting on Development's production, net assets, and cost per dollar raised goals. You will...


  • Grove City, Ohio, United States Reliant Staffing SolutionsRSS Medical Full time

    Job Title: Travel Nurse RN ICU SpecialistJob Summary:Reliant Staffing Solutions/RSS Medical is seeking a skilled Travel Nurse RN ICU Specialist to join our team. As a Travel Nurse RN ICU Specialist, you will be responsible for providing high-quality patient care in an intensive care unit setting.Responsibilities:Provide direct patient care to critically ill...


  • Grove City, Ohio, United States Booz Allen Hamilton Full time

    Cloud Infrastructure SpecialistProficient in AWS Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) technologies along with industry best practices.Familiarity with AWS cloud-native technologies and their optimal usage.Experience in cloud development, migration processes, and implementation strategies.Knowledge of Department of Defense (DoD)...


  • Grove City, Ohio, United States Department of Veterans Affairs Full time

    Position OverviewThe Department of Veterans Affairs is in search of a dedicated Practical Nurse Specialist, GS-7, to enhance our Connected Care team. The Practical Nurse Specialist plays a crucial role in facilitating the daily functions of Telehealth across various facilities and Selected Specialty Medicine Clinics. This role requires a comprehensive...


  • Grove City, Ohio, United States Cyberonics Full time

    Transform Patient Lives with LivaNovaLivaNova is a global leader in cardiovascular systems, committed to providing comprehensive perfusion solutions and customer support through continuous training and education. We are excited to be launching our next generation heart lung machine and are currently looking to add to our Clinical Specialist team.Key...


  • Grove City, Ohio, United States Actalent Full time

    Job SummaryWe are seeking a highly skilled GMP Sanitation Specialist to join our team at Actalent. As a key member of our operations team, you will be responsible for maintaining a clean and safe environment in our cleanroom facilities.Key ResponsibilitiesCleaning and Sanitation: Perform routine cleanroom facility cleaning, adhering to GMP regulatory...


  • Ohio City, Ohio, United States US Acute Care Solutions Full time

    Job DescriptionThe Electronic Records Specialist plays a crucial role in facilitating the billing process by gathering, compiling, and collating patient data and records in a document imaging setting.Key Responsibilities:Gather and compile patient data and records to ensure accurate and timely billing.Collate and prepare patient data for the Electronic...

  • Data Architect

    4 hours ago


    Dexter City, Ohio, United States AICA Orthopedics Full time

    Data Architect Job OverviewAICA Orthopedics is seeking a skilled Data Architect to support our data-driven decision-making processes. The ideal candidate will have a strong background in compiling, organizing, and managing data from various systems and platforms, creating insightful reports using tools like Power BI, and presenting findings to...


  • Grove City, Ohio, United States Western Alliance Bank Full time

    Software Quality Assurance SpecialistLocation: CityScapeKey Responsibilities:Integral member of the Identity and Access Management (IAM) team ensuring the excellence of project outputsEngage in requirements analysis sessions to understand project needsDevelop comprehensive Manual Test Plans and Test Cases for application evaluationsConduct thorough frontend...


  • Grove City, Ohio, United States Trinity Health Full time

    Job Summary:We are seeking a skilled Medical Laboratory Specialist to join our team at Trinity Health. As a Medical Laboratory Specialist, you will play a critical role in supporting our clinical operations by performing laboratory and/or phlebotomy testing.Key Responsibilities:Perform routine scheduled and specialized maintenance of laboratory...


  • Grove City, Ohio, United States Fabcon Full time

    About the RoleFabcon is seeking a skilled Concrete Quality Assurance Specialist to join our team. As a key member of our quality control team, you will be responsible for ensuring the highest quality standards in our precast concrete manufacturing environment.Key ResponsibilitiesQuality Control and Assurance: Conduct thorough inspections and tests of...


  • Grove City, Ohio, United States Martin Painting Full time

    Industrial Coating SpecialistMartin Painting is seeking a committed professional to contribute to our industrial painting operations, guided by our core principles of Respect, Integrity, Teamwork, and Effort.Key Responsibilities:Preparation of surfaces and application of protective maskingSpraying of original equipment manufacturer (OEM) componentsExecuting...


  • Grove City, Ohio, United States Capstone Logistics Full time

    About the JobWe are seeking a highly motivated and physically fit individual to join our Warehouse Sanitation Team as a Warehouse Sanitation Specialist. As a key member of our team, you will be responsible for maintaining a clean and safe working environment in our warehouse.Key ResponsibilitiesPerform sanitation duties to ensure a clean and safe working...


  • Grove City, Ohio, United States Fabcon Full time

    About the RoleFabcon is seeking a skilled Concrete Quality Assurance Specialist to join our team. As a key member of our quality control team, you will play a critical role in ensuring the highest quality products are delivered to our customers.Key ResponsibilitiesQuality Control and Assurance: Conduct thorough inspections and tests of materials, products,...


  • Grove City, Ohio, United States Millennium Health Full time

    Position: Male Specimen Collection SpecialistLocation: Columbus, OhioSchedule: Full Time, Monday to Friday, 8:00 AM - 3:00 PMOverview:At Millennium Health LLC, we are dedicated to enhancing the well-being of our community through effective medication monitoring and drug testing services. As a Male Specimen Collection Specialist, you will play a vital role in...


  • Grove City, Ohio, United States Horizon Industries Full time

    Position Overview:As a Cybersecurity Operations Specialist at Horizon Industries, you will play a pivotal role in safeguarding our digital infrastructure. This position offers a unique opportunity to enhance your skills in a supportive and progressive environment. Company Background:Horizon Industries is a leading IT and Management Consulting firm located in...


  • Grove City, Ohio, United States Owens Corning Full time

    HR Operations Specialist Location(s): Grove City, OH, US Function:Human ResourcesAudience:HourlyWork Arrangement:On SiteRequisition ID:63130The HR Operations Specialist is an hourly, FLSA non-exempt role reporting to the HR Lead. This position is responsible for delivering administrative support, payroll processing, recruitment, benefits management,...