ETL Analyst

2 weeks ago

Pittsburgh, United States Visvero (a SBA 8a certified company) Full time

Translates data requirements into applications that employ appropriate data models and ETL solutions. Analyzes, defines, develops, and maintains complex database structures and ETL architectures and applications. Creates data flows and ETL models defining the data transformation needs of projects. Ensures effective and efficient utilization of ETL processes when accessing, integrating, and delivering data between systems. Develops and implements data validation, auditing, reconciliation, testing methodologies, and integration processes. Coordinates with business/data analysts on data cleansing and data profiling activities to improve quality of data. Works closely with DBA Team and Operations to establish ETL job workflow with reliable error/exception handling and rollback framework, including scheduling, error management, restart ability, email notifications, and information publishing. Develops and maintains accurate system documentation including information about attributes, lineage, and business rules. Assists in the gathering of metadata and maintenance of repositories and data dictionaries. Helps set standards and comply with Bank and data governance policies, procedures, and regulations to ensure safe and sound business operations. Recognizes and identifies potential areas where existing policies and procedures require change, or where new ones need to be developed, especially regarding the security of financial data. Works with IT groups to implement a disaster recovery and business continuance solutions for ETL processes, including the installation, configuration, and testing of software. Participates in the development and maintenance of strategic, architectural, and tactical plans for the Bank's data integration technologies. Conversant with and cognizant of the future direction of systems, how that direction impacts the Bank, and how future and current systems can be exploited for the benefit of the Bank. Maintains understanding of data modeling and data integration technology trends and best practices and uses this knowledge to bring solutions to business units and IT; makes recommendations on buy vs. build decisions. Mentors Team members and is a technical resource on data integration and ETL technologies. Maintains understanding of information flows and the data integration technology to support the documentation of all of the banks' structured data flows. Provide production support for the banks integrated batch processing. Provides periodic reports on activities, accomplishments, issues and their solutions, as well as assisting in forecasts of future utilization, tools, and resource requirements. Ensures compliance with applicable policies, procedures and regulations to ensure safe and sound business operations. Prefer to be knowledgeable in Data Warehousing and Change Data Capture lifecycle and methodologies. Performs modeling of data sources and flows and works with Data Services staff to identify, design, and implement data warehouse objects – star schemas, multidimensional tables, and BI Universes – using best practices. Designs and develops prototypes, data classifications, and database tables and views to aggregate data as required for reporting optimization.

Requirements

Bachelor’s or master’s degree in computer science, Information Systems, or related field. Or equivalent work experience that includes knowledge of Data Warehousing, Data Integration, Data Transfer methodologies, and Database Management Five or more years of experience using Informatics tools such as Power Center, Data Quality and Metadata management in a bank or financial institution working with IT staff and business units to complete complex system design, development, and implementation of ETL solutions. Prefer at least three years of experience in Data Modeling, or Data Integration, including experience using relational, star-schema, and multidimensional data models. Knowledge of current practices, theories, and approaches to performance tuning and optimization, collection of metadata, table partitioning, materialized views, and parallel processing. Proficiency in PL/SQL, SQL, and UNIX scripting Prefer three or more years of experience as ETL Architect/Designer, including experience installing and configuring database and ETL software. Advanced-level experience in designing, developing, and maintaining data transfer maps and processes and database structures, including measure, dimension, and hierarchy objects. Ability to analyze and interpret financial information and data to implement business/transformation rules, data profiling, data cleansing, and reconciliation processes to ensure data quality. Knowledge of operating systems hardware and software, relational databases, and software development tools including but not limited to Linux, Windows, Oracle, SQL-Server, Erwin, MS-Access, and MS-Excel Strong interpersonal, communication, and writing skills; able to work independently or in a team environment. Experience with Agile methodologies to effectively participate in cross functional teams.

Benefits

Medical Insurance Prescription drug coverage with Home Delivery option Dental Insurance with child orthodontia feature Voluntary Vision Insurance Company matched 401K retirement plan Employee Assistance Plan Life Insurance with AD&D Coverage Long Term Disability Coverage Optional Short Term Disability Coverage Paid Time Off for Holidays, Vacation, Illness Employee Referral Bonuses

#J-18808-Ljbffr

  • ETL Tester

    2 weeks ago

    Pittsburgh, United States Synechron Full time

    Role: QA ETL tester /Quality Assurance ConsultantLocation: Pittsburg PA Job Description:Responsible for implementing quality assurance programs. Education/Experience: High School Degree and Bachelors degree in Information Technology, Computer Science, Computer Engineering, Relevant field is desirable or equivalent work experience required. 10 years...

  • ETL Tester

    2 weeks ago

    Pittsburgh, United States Synechron Full time

    Role: QA ETL tester /Quality Assurance ConsultantLocation: Pittsburg PA Job Description:Responsible for implementing quality assurance programs. Education/Experience: High School Degree and Bachelors degree in Information Technology, Computer Science, Computer Engineering, Relevant field is desirable or equivalent work experience required. 10 years...

  • Application Analyst

    3 weeks ago

    Pittsburgh, United States Robert Half Full time

    This role is on-site 3 days per week in the Pittsburgh office. Candidates must be in the Pittsburgh area. We are seeking an Application Support Analysts based in Pittsburgh, Pennsylvania. In this role, you will be involved in various aspects of application support, including troubleshooting complex bank enterprise applications, database management, and...

  • Application Analyst

    3 weeks ago

    Pittsburgh, United States Robert Half Full time

    This role is on-site 3 days per week in the Pittsburgh office. Candidates must be in the Pittsburgh area. We are seeking an Application Support Analysts based in Pittsburgh, Pennsylvania. In this role, you will be involved in various aspects of application support, including troubleshooting complex bank enterprise applications, database management, and...

  • Applications Analyst

    2 weeks ago

    Pittsburgh, United States All Lines Technology Full time

    Overview: All Lines Technology is seeking an experienced Applications Analyst to join our team. As an Applications Analyst, you will play a crucial role in designing, developing, and maintaining critical applications and integrations. Your expertise will contribute to the success of our projects, ensuring high-quality code and efficient system...

  • Application Analyst

    2 weeks ago

    Pittsburgh, United States All Lines Technology Full time

    Overview: All Lines Technology is seeking an experienced Applications Analyst to join our team. As an Applications Analyst, you will play a crucial role in designing, developing, and maintaining critical applications and integrations. Your expertise will contribute to the success of our projects, ensuring high-quality code and efficient system performance....

  • Applications Analyst

    2 weeks ago

    Pittsburgh, United States All Lines Technology Full time

    Job DescriptionJob DescriptionOverview: All Lines Technology is seeking an experienced Applications Analyst to join our team. As an Applications Analyst, you will play a crucial role in designing, developing, and maintaining critical applications and integrations. Your expertise will contribute to the success of our projects, ensuring high-quality code and...

  • Applications Analyst

    2 weeks ago

    Pittsburgh, United States All Lines Technology Full time

    Job DescriptionJob DescriptionOverview: All Lines Technology is seeking an experienced Applications Analyst to join our team. As an Applications Analyst, you will play a crucial role in designing, developing, and maintaining critical applications and integrations. Your expertise will contribute to the success of our projects, ensuring high-quality code and...

  • Application Analyst

    2 weeks ago

    Pittsburgh, United States All Lines Technology Full time

    Overview: All Lines Technology is seeking an experienced Applications Analyst to join our team. As an Applications Analyst, you will play a crucial role in designing, developing, and maintaining critical applications and integrations. Your expertise will contribute to the success of our projects, ensuring high-quality code and efficient system performance....

  • Applications Analyst

    2 days ago

    Pittsburgh, United States All Lines Technology Full time

    Job DescriptionJob DescriptionOverview: All Lines Technology is seeking an experienced Applications Analyst to join our team. As an Applications Analyst, you will play a crucial role in designing, developing, and maintaining critical applications and integrations. Your expertise will contribute to the success of our projects, ensuring high-quality code and...

  • Data Analyst

    1 day ago

    Pittsburgh, United States TEK Connexion Full time

    W2 Only - no C2C or C2HOnly reviewing resumes of those currently residing in Pittsburgh, PA. We aren't looking to relocate anyone at this time. Mandatory Skills: Foundational SQL & Tableau Flex Skill: Automation w/Python Role and the key responsibilities:Automate visualization or change sourcing Work with senior management, technical and client teams in...

  • IT Security Analyst

    3 weeks ago

    Pittsburgh, United States New York Technology Partners Full time

    IT Security Analyst Location: Pittsburgh, PA or Lake Mary, FL (need nearby candidate within 50 to 60 miles from client location) Work Arrangement: Hybrid 3 days office 2 days remote Experience : 8+ years Job Description: These are very data driven roles Where its mapped, where does the data sit, what is available, etc They are fighting fraud with data...

  • IT Security Analyst

    3 weeks ago

    Pittsburgh, United States New York Technology Partners Full time

    IT Security Analyst Location: Pittsburgh, PA or Lake Mary, FL (need nearby candidate within 50 to 60 miles from client location) Work Arrangement: Hybrid 3 days office 2 days remote Experience : 8+ years Job Description: These are very data driven roles – Where it’s mapped, where does the data sit, what is available, etc They are fighting fraud with data...

  • IT Security Analyst

    3 weeks ago

    Pittsburgh, United States New York Technology Partners Full time

    IT Security Analyst Location: Pittsburgh, PA or Lake Mary, FL (need nearby candidate within 50 to 60 miles from client location) Work Arrangement: Hybrid 3 days office 2 days remote Experience : 8+ years Job Description: These are very data driven roles – Where it’s mapped, where does the data sit, what is available, etc They are fighting fraud with data...

  • Financial Systems Analyst

    3 weeks ago

    Pittsburgh, United States American Trust & Savings Bank Full time

    Financial Systems Analyst (PA, Pittsburgh) March 12, 2024 Job Summary: The Financial Systems Analyst will be a member of the corporate Shared Technology Finance team. The Financial Systems Analyst will be responsible for leading technology integration of all financial management and accounting software to ensure efficient operations and minimal disruption in...

  • Senior Business Intelligence Analyst

    6 days ago

    Pittsburgh, PA, United States Food Management Search Full time

    Senior Business Intelligence Analyst   SENIOR BUSINESS INTELIGENCE ANALYST This position provides expertise in data delivery and administration using provided tools such as IBM Cognos and Power BI Reports. Provide expertise in data warehousing using relational database (e.g. Oracles, MS SQL, Server BI Studio) and ETL Technologies (e.g. Keeps abreast of...

  • Data Architect

    5 days ago

    Pittsburgh, United States Saxon Global Full time

    This is a 12 month contract with Inovalon. 100% remote. This is an arch level role. Visa-USC/GC. Must have very strong Mongo DB exp. Description: Reason: Unique Expertise Department: iPORT Engineering Job Category: IT/Technology Job Title: Mongo DB Data Architect Duties: Overview: The Data Architect will be responsible for working with business...

  • Identity System Analyst

    3 weeks ago

    Pittsburgh, United States Visvero, Inc. Full time

    Job DescriptionAbility to use Excel and other Microsoft Office tools to generate reports and conduct data analysis.Familiarity with different tools for managing work, ITSM Tools (Cherwell, ServiceNow, etc), SharePoint, etc.Ability to review reports and determine actions required for follow up based on defined processes.Ability to work independently with...

  • Senior Business Intelligence Analyst

    6 days ago

    Pittsburgh, United States Frank Calandra Jennmar Services Full time

    Job DescriptionJob DescriptionPOSITION DESCRIPTION:This position provides expertise in data delivery and administration using provided tools such as IBM Cognos and Power BI Reports. Provide expertise in data warehousing using relational database (e.g. Oracles, MS SQL, Server BI Studio) and ETL Technologies (e.g. WhereScape, TimeXtender). Keeps abreast of...

  • Remote Lead Data Engineer

    3 days ago

    Pittsburgh, United States Insight Global Full time

    Position: Lead Data Engineer (Databricks/AWS)Duration: 6 Month Contract – w/extensions or conversionLocation: Remote ; East Coast!!!Must Haves:2-3 years exp. as a data engineer3 years of RECENT experience with Data Bricks Must be their most relevant experience!!Experience with Cloud ( Azure, GCP, or AWS)Experience with SQL – they will be writing...