Data Transformation Specialist

4 weeks ago


Columbus, Ohio, United States Western Alliance Bank Full time
Job Title:
Data Transformation Specialist - Corporate Trust

Location:
Remote Opportunity

Job Summary:
Western Alliance Bank is seeking a skilled Data Transformation Specialist to design, develop, and deploy data extracts, transformations, or loads, supporting the ingestion and transformation of data as needed using Azure Data Factory and SSIS packages.

Key Responsibilities:
• Responsible for the design, development, and deployment of data extracts, transformations, or loads.
• Support the ingestion and transformation of data as needed using Azure Data Factory and SSIS packages.
• Provide database administration support for on-prem and cloud databases.
• Work with different teams to understand complex business logic and design ETL processes.
• Design and develop data warehouse ETL processes in SSIS & SQL stored procedures.
• Analyze business user requirements, assess different source data of banking applications, and design data flow to implement ETL processes using Microsoft SSIS tools.
• 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.
• Efficiently work in an Agile environment.

Requirements:
• Must have 7+ years of solid experience in SQL development.
• Must have 7+ years of hands-on experience in ETL design and development using any Microsoft SQL server ETL tools or Informatica.
• Must have 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 with development life cycle, data architect, and related methodologies.

Benefits:
Western Alliance Bank offers competitive salaries, an ownership stake in the company, medical and dental insurance, time off, a great 401k matching program, tuition assistance program, employee volunteer program, and a wellness program. You'll also have the opportunity to bolster your business knowledge, learning the ins and outs of how successful companies operate and manage their finances, giving you invaluable hands-on experience to help grow your career.

About the Company:
Western Alliance Bank is a wholly owned subsidiary of Western Alliance Bancorporation. Alliance Bank of Arizona, Alliance Association Bank, Bank of Nevada, Bridge Bank, First Independent Bank, and Torrey Pines Bank are divisions of Western Alliance Bank; Member FDIC. AmeriHome Mortgage is a Western Alliance Bank company. Western Alliance Bancorporation is 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.

  • Columbus, Ohio, United States Western Alliance Bank Full time

    Job Title:Data Transformation Specialist - Corporate TrustLocation:Block 23Job Summary:Western Alliance Bank is seeking a skilled SQL ETL developer to deliver innovative, industry-leading solutions. We want a creative, highly-motivated developer who can take initiative, have good sense of urgency and is comfortable working in a fast-paced, agile...


  • Columbus, Ohio, United States Cynet Systems Full time

    Job Title: Data Integration SpecialistAt Cynet Systems, we are seeking a highly skilled Data Integration Specialist to join our team. As a Data Integration Specialist, you will be responsible for designing and building data provisioning workflows/pipelines, physical data schemas, extracts, data transformations, and data integrations using ETL tools like...


  • Columbus, Ohio, United States The Christ Hospital Cardiovascular Associates Full time

    The Christ Hospital Cardiovascular Associates is seeking a skilled Data Integration Specialist to join our Data & Analytics team. This role will focus on the day-to-day maintenance and support of our Epic Cogito related systems, including Clarity, Caboodle, and other SQL databases. The ideal candidate will have experience with ETL processes, data mappings,...


  • Columbus, Ohio, United States Beacon Hill Staffing Group Full time

    Job SummaryAs a Data Quality Specialist at Beacon Hill Technologies, you will play a critical role in ensuring the accuracy, completeness, and reliability of our data. Your primary responsibility will be to analyze data from various sources, identify and correct errors and inconsistencies, and develop and implement processes to improve data quality.Key...


  • Columbus, Ohio, United States emids Full time

    At emids, we're dedicated to bridging critical gaps in providing accessible, affordable, and high-quality healthcare through our digital transformation services, custom application development, data engineering, business intelligence solutions, and specialized consulting services.Our team of experts leverages strong domain expertise in healthcare-specific...


  • Columbus, Ohio, United States Diverse Lynx Full time

    Job Title: Senior Oracle Data Integrator SpecialistJob Summary:We are seeking a highly skilled Senior Oracle Data Integrator Specialist to join our team at Diverse Lynx LLC. As an ODI expert with 10+ years of experience, you will be responsible for designing, developing, and implementing ETL mappings, workflows, and packages using Oracle Data Integrator...


  • Columbus, Ohio, United States Epiq Global Business Transformation Solutions, LLC Full time

    Job Summary:A Service Specialist at Epiq Global Business Transformation Solutions, LLC provides administrative support to clients, including scanning, copy, print, mail, hospitality, and supplies services. The primary role is to support a law firm with scanning documents, bates labeling, and OCR.Key Responsibilities:Scan Services: Work with clients to gauge...


  • Columbus, Ohio, United States Align Communications Full time

    Job DescriptionWe are seeking a highly skilled and experienced Data Center Cabling Specialist to join our team at Align Communications. As a key member of our Data Center Design and Build team, you will be responsible for planning and executing the cabling design and installation tasks for large data center design and build projects.Key...


  • Columbus, Ohio, United States Nationwide Full time

    Data Engineer Specialist Job DescriptionNationwide is seeking a highly skilled Data Engineer Specialist to join our team. As a Data Engineer Specialist, you will be responsible for acquiring, curating, and publishing data for analytical or operational uses. You will work with various technologies from big data, relational and SQL databases, unstructured data...

  • Data Entry Specialist

    4 weeks ago


    Columbus, Ohio, United States Workoo Technologies Full time

    About the Role:Data Entry Specialist - Workoo TechnologiesWe are seeking a detail-oriented Data Entry Specialist to manage and maintain our database systems. As a key member of our team, you will be responsible for accurately entering data into our systems, ensuring data integrity and consistency.Key Responsibilities: Enter new information into database...


  • Columbus, Ohio, United States Onward Technologies Inc. Full time

    Job Title: Digital Transformation Product OwnerJob Summary:We are seeking a highly skilled Digital Transformation Product Owner to join our team at Onward Technologies Inc. The successful candidate will be responsible for leading the development and implementation of digital transformation initiatives, ensuring alignment with business objectives and...


  • Columbus, Ohio, United States United Software Group Full time

    Data Engineering Solutions SpecialistAt United Software Group, we are seeking a highly skilled Data Engineering Solutions Specialist to join our team. The successful candidate will play a crucial role in designing and implementing data engineering solutions for the Agency, focusing on data platform selection, data modeling, and enterprise data architecture...


  • Columbus, Ohio, United States North Central Mental Health Services, Inc. Full time

    Job Title: Data Quality SpecialistWe are seeking a highly skilled Data Quality Specialist to join our team at North Central Mental Health Services, Inc. This is a unique opportunity to work in a dynamic and supportive environment where you can make a real difference in the lives of our patients and staff.Job Summary:The Data Quality Specialist plays a...


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

    ChenMed is inviting BC/BE Primary Care Physicians to Columbus, OH.About ChenMedWe are a privately held, physician-led organization serving communities through 120+ centers in over 15 states. At ChenMed, primary care is transformed into transformative care. Every day, seniors receive better patient outcomes and we achieve our vision. Our value-based care...


  • Columbus, Ohio, United States McKesson Full time

    About UsMckesson is a leading healthcare company that touches virtually every aspect of healthcare. We deliver insights, products, and services that make quality care more accessible and affordable. Our shared purpose is to help people get the medicine they need to live healthier lives.CoverMyMeds is a unified brand that encompasses RelayHealth, RxCrossroads...


  • Columbus, Ohio, United States Align Communications Full time

    Job Title: Data Center Cabling SpecialistAlign Communications is seeking a highly skilled Data Center Cabling Specialist to join our team. As a key member of our Data Center Design and Build team, you will be responsible for planning and executing the cabling design and installation tasks for large data center design and build projects.Key...


  • Columbus, Ohio, United States FST Logistics Full time

    About the Role:FST Logistics is seeking a skilled ETL Developer/Report Writer to join our team. As a key member of our data analytics team, you will be responsible for designing, developing, and maintaining ETL processes using Pentaho. You will also create insightful reports to support business operations and decision-making.Responsibilities:Design, develop,...


  • Columbus, Ohio, United States Gifthealth Full time

    Job OverviewGifthealth is seeking a highly skilled Data Insights Specialist to join our team. This role will be responsible for enhancing reporting for our current business model by owning end-to-end development, design, and maintenance of analyses and dashboards.Key Responsibilities:Partner with engineers, product stakeholders, and leadership to translate...


  • Columbus, Ohio, United States Align Communications Full time

    Job OverviewAlign Communications is seeking a highly skilled Data Center White Space Fit Out Specialist to join our team in Columbus, Ohio. As a key member of our data center solutions team, you will be responsible for managing data center fit out projects from inception to final handover.Key ResponsibilitiesProject manage data center fit out projects,...


  • Columbus, Ohio, United States Compunnel Full time

    Job Summary: We are seeking an experienced professional to join our team at Compunnel as a Data Governance Specialist. The ideal candidate will have a minimum of 4 years of experience in implementing ASG Rochade data catalog, governance, and lineage capabilities. The role involves collaborating with stakeholders to assess metadata management needs,...