Data Transformation Specialist

2 days ago

Columbus, Ohio, United States Western Alliance Bank Full time

About the Role:

Western Alliance Bank is seeking a highly skilled Data Transformation Specialist to join our team. As a key member of our data integration 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 for 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
  • Efficiently work in an Agile environment

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' 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

About Us:

Western Alliance Bank is a wholly owned subsidiary of Western Alliance Bancorporation. We are committed to equal employment and will consider all qualified applicants without regard to race, sex, color, religion, age, national origin, marital status, disability, protected veteran status, sexual orientation, gender identity, or genetic information.

  • Senior Oracle Data Integrator Specialist

    1 week ago

    Columbus, Ohio, United States Tata Consultancy Services Full time

    Job DescriptionWe are seeking a highly skilled Oracle Data Integrator Specialist to join our team at Tata Consultancy Services. As a key member of our data integration team, you will be responsible for designing, developing, and implementing data integration solutions using Oracle Data Integrator (ODI).Key Responsibilities:Data Integration Design and...

  • End-to-End Supply Chain Transformation Specialist

    2 weeks ago

    Columbus, Ohio, United States Schneider Electric Full time

    Position Overview:Schneider Electric USA, Inc. is seeking a Supply Chain Planning - End to End Transformation Expert. This role is based in Franklin, TN and focuses on enhancing the tools, processes, and personnel across the region within a defined scope.Key Responsibilities: - Serve as the Regional Authority on Kinaxis Planning Tool, Symmetry, and MPP. -...

  • Security Specialist

    1 week ago

    Columbus, Ohio, United States Alliance Data Full time

    Job SummaryA Security Specialist plays a vital role in safeguarding the assets and personnel of Alliance Data by minimizing risk and ensuring overall safety and security at assigned locations. This is a highly interactive position in a fast-paced environment that values our security team.Key ResponsibilitiesLife Safety - Secure premises and personnel by...

  • Senior Data Integration Specialist

    2 days ago

    Columbus, Ohio, United States Saransh Inc Full time

    About the Role:Saransh Inc is seeking a highly skilled SSIS Developer with extensive experience in SQL Server, Snowflake, and.NET to join our dynamic team.Key Responsibilities:Design and develop complex ETL processes using SSIS to extract, transform, and load data from various sources into SQL Server and Snowflake.Integrate.NET code within SSIS packages to...

  • Virtual IT Talent Acquisition Specialist at Transform Labs

    2 weeks ago

    Columbus, Ohio, United States Transform Labs Full time

    Job OverviewSalary: $50,000About the PositionTransform Labs is on the lookout for a proficient Virtual IT Talent Acquisition Specialist to become a part of our dynamic team. This role is pivotal in ensuring a remarkable candidate journey while effectively addressing our recruitment requirements. As a representative of Transform Labs within the tech sector,...

  • GIS Data Specialist

    2 weeks ago

    Columbus, Ohio, United States Transmap Corporation Full time

    Job OverviewAt Transmap Corporation, we are seeking a highly skilled GIS Data Specialist to join our team. As a GIS Data Specialist, you will play a critical role in interpreting, analyzing, and extracting roadway data from street-level imagery to provide location and descriptive information about roadway infrastructure for our GIS databases.Key...

  • GIS Data Specialist

    2 weeks ago

    Columbus, Ohio, United States Transmap Corporation Full time

    Job OverviewAt Transmap Corporation, we are seeking a highly skilled GIS Data Specialist to join our team. As a GIS Data Specialist, you will play a critical role in interpreting, analyzing, and extracting roadway data from street-level imagery to provide location and descriptive information about roadway infrastructure for our GIS databases.Key...

  • Digital Transformation Strategist

    2 weeks ago

    Columbus, Ohio, United States WillowTree Full time

    About the RoleWe are seeking a highly skilled Digital Transformation Strategist to join our team at WillowTree. As a key member of our team, you will play a critical role in empowering Fortune 500 companies' digital transformation goals to come to life with improved mobile technology capabilities.Key ResponsibilitiesConduct in-depth business and technical...

  • End-to-End Supply Chain Transformation Specialist

    2 weeks ago

    Columbus, Ohio, United States Schneider Electric Full time

    Position Overview:Schneider Electric USA, Inc. is seeking a Supply Chain Planning - End to End Transformation Expert. This role is pivotal in overseeing the Tools, Processes, and People within a designated region, ensuring excellence in supply chain operations.Key Responsibilities:1. Serve as the Regional Authority on Kinaxis Planning Tool, Symmetry, and...

  • End-to-End Supply Chain Transformation Specialist

    2 weeks ago

    Columbus, Ohio, United States Schneider Electric Full time

    Position Overview:Schneider Electric USA, Inc. is seeking a Supply Chain Planning - End to End Transformation Expert. This role is based in Franklin, TN and focuses on overseeing the Tools, Processes, and People within a designated scope across the region.Key Responsibilities: - Serve as the Regional Authority on Kinaxis Planning Tool, Symmetry, and MPP. -...

  • Digital Transformation Strategist

    2 days ago

    Columbus, Ohio, United States WillowTree Full time

    About UsWillowTree, a leading digital innovation partner, empowers Fortune 500 companies to drive business growth through cutting-edge mobile technology solutions. Our team of experts collaborates with clients to deliver seamless, trusted, and digitally-enabled experiences across various channels.Job SummaryWe are seeking a highly skilled Digital...

  • Senior Business Transformation Consultant

    2 weeks ago

    Columbus, Ohio, United States Nationwide Private Client Full time

    Join Our Team as a Senior Business Transformation ConsultantAre you driven by the desire to make a significant impact in the world of business consulting? At Nationwide Private Client, we are committed to providing exceptional service to our clients, helping them navigate their retirement planning with confidence. We believe in putting our clients first, and...

  • Safety and Security Specialist

    3 weeks ago

    Columbus, Ohio, United States Alliance Data Card Services Full time

    Join a team that values safety and security!Position OverviewA Safety and Security Specialist is essential in fostering a secure environment for Alliance Data Card Services and its workforce. This role involves safeguarding company resources, mitigating risks, and ensuring the overall safety of personnel at designated locations. Unlike traditional security...

  • Medicaid Data Support Specialist

    2 hours ago

    Columbus, Ohio, United States Ohio Department of Developmental Disabilities Full time

    Job SummaryWe are seeking a highly skilled Medicaid Data Support Specialist to join our team at the Ohio Department of Medicaid. As a key member of our team, you will be responsible for providing technical support and analysis for Medicaid data systems.Key ResponsibilitiesProvide technical support for Medicaid data systems, including troubleshooting and...

  • Senior Data Engineer

    3 days ago

    Columbus, Ohio, United States Saxon Global Full time

    Job SummaryThe Senior Data Engineer will play a key role in designing, developing, and implementing data transformation solutions to support business needs. This individual will work closely with cross-functional teams to identify data requirements, design and implement data pipelines, and ensure data quality and integrity.Key ResponsibilitiesData Design and...

  • Pharmacy Data Entry Specialist

    6 days ago

    Columbus, Ohio, United States Specialty RX Full time

    **Job Summary**Specialty RX is seeking an experienced Pharmacy Data Entry Specialist to join our team. As a Pharmacy Data Entry Specialist, you will play a critical role in ensuring the accuracy and efficiency of our pharmacy operations.**Key Responsibilities:**Enter new orders into the pharmacy computer system for review by a licensed pharmacist.Maintain...

  • Transformative Care Opportunity in Underserved Area

    7 days ago

    Columbus, Ohio, United States ChenMed Family of Companies Full time

    About ChenMed Family of CompaniesWe are a privately held, physician-led organization serving our communities through 120+ centers in over 15 states. At ChenMed, we deliver transformative care to seniors, focusing on better patient outcomes. Our value-based care model prioritizes both patients and providers.Our Physicians Enjoy:Guaranteed base salary with a...

  • Digital Transformation Specialist

    2 weeks ago

    Columbus, Ohio, United States Cloudinity Inc Full time

    Job DescriptionCloudinity Inc is seeking an experienced Business Solutions Analyst to join our team. As a Business Solutions Analyst, you will play a key role in facilitating communication between business and IT teams, ensuring that software objectives align with stated and unstated business needs.Key ResponsibilitiesAnalyze and Define Business...

  • Senior Data Engineer

    2 weeks ago

    Columbus, Ohio, United States VMC Soft Technologies, Inc Full time

    About the Role:VMC Soft Technologies, Inc is seeking a highly skilled Senior Data Analyst to join our team. As a Senior Data Analyst, you will be responsible for developing and maintaining data platforms using Python, Spark, and PySpark.Key Responsibilities:Design and implement data pipelines to handle migration to PySpark on AWS.Develop and maintain data...

  • Cloud Data Architect

    2 weeks ago

    Columbus, Ohio, United States VMC Soft Technologies, Inc Full time

    About the Role:VMC Soft Technologies, Inc is seeking a highly skilled Senior Data Analyst to join our team. As a Senior Data Analyst, you will be responsible for developing and maintaining data platforms using Python, Spark, and PySpark.Key Responsibilities:Design and implement data pipelines to extract, transform, and load data from various sources.Develop...