ETL Analyst - Pittsburgh, United States - Visvero

Visvero Pittsburgh, United States

3 weeks ago

Description

Job Description

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

ETL Analyst

3 weeks ago

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

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 transformat ...
ETL Analyst

4 weeks ago

Visvero, Inc. Pittsburgh, United States

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 transforma ...
Data Analyst

1 week ago

TEK Connexion Pittsburgh, United States

W2 Only - no C2C or C2H · Only 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: · Auto ...
Senior Business Analyst

1 week ago

ICF Pittsburgh, United States Full time

ICF is a mission-driven company filled with people who care deeply about improving the lives of others and making the world a better place. Our core values include Embracing Difference; we seek candidates who are passionate about building a culture that encourages, embraces, and ...
Manager HCS Utilization and Product Technology

3 days ago

Highmark Health Pittsburgh, United States Full time

Description · : JOB SUMMARY · Lead a high-performing data team in building and automating ETL processes for efficient data pipelines. Leverage your expertise in data warehousing, scripting, and cloud platforms to streamline data ingestion and transformation. Foster a collabor ...
ETL Quality Engineer

3 weeks ago

Mastech Digital Pittsburgh, United States

Mastech Digital Inc. is a (certified) Minority owned business certified by NMSDC. Public traded firm under MHH at NYSE, Established in 1986. Headquartered in Pittsburgh, PA our operations are spread across 11 Global Recruiting & Sales offices across US. · Role: Data Quality Engi ...
Business Systems Analyst

3 weeks ago

Tristate Capital Holdings, Inc. Pittsburgh, United States

Business Systems Analyst (Data Integrations) · Department: Information Technology · Location: Pittsburgh, PA · Job Title: Business Systems Analyst (Data Integrations) · Department: Information Technology · Location: Pittsburgh, PA · Summary of the Position: · The Business Syst ...
Application Analyst

3 weeks ago

All Lines Technology Pittsburgh, United States

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 ...
Data Architect

3 weeks ago

Saxon Global Pittsburgh, United States

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 ...
Data Modeler

3 weeks ago

TEKsystems Pittsburgh, United States

Job Description · Job Description3209460 · 12 Month Contract (extendable) · Top Three Skills: · 1. At least 2 years as a data modeler · 2. Experience using Erwin as a data modeling tool · 3. At least 3 years of overall IT experience · Job Description: · We are supporting a larg ...
Senior Business Intelligence Analyst

2 weeks ago

Knowhirematch Pittsburgh, United States

Job Description · Job DescriptionSenior Business Intelligence Analyst · Location: Pittsburgh, pA · Salary: $90,000 - $120,000 + Quarterly Bonus + 12% 401K Match · Benefits: Comprehensive Benefits Package · Role Overview: · We are seeking a Senior Business Intelligence Analyst to ...
Senior Business Analyst

1 day ago

ICF Pittsburgh, United States

ICF is a mission-driven company filled with people who care deeply about improving the lives of others and making the world a better place. Our core values include Embracing Difference; we seek candidates who are passionate about building a culture that encourages, embraces, and ...
Senior Business Analyst

1 day ago

ICF Pittsburgh, United States

ICF is a mission-driven company filled with people who care deeply about improving the lives of others and making the world a better place. Our core values include Embracing Difference; we seek candidates who are passionate about building a culture that encourages, embraces, and ...
Data Architect, Source to Pay and Order to Cash

2 weeks ago

Xylem Pittsburgh, United States

We're Hiring for a · Data Architect, Source to Pay and Order to Cash · If you are excited and passionate about helping LetsSolveWater, consider joining our team today · Xylem, Inc. · is a leading global water technology company servicing more than 150 countries and is dedicate ...
ETL Quality Engineer

4 weeks ago

Mastech Digital Pittsburgh, United States

Mastech Digital Inc. is a (certified) Minority owned business certified by NMSDC. Public traded firm under MHH at NYSE, Established in 1986. Headquartered in Pittsburgh, PA our operations are spread across 11 Global Recruiting & Sales offices across US. · Role: Data Quality Engi ...
Applications Analyst

3 weeks ago

All Lines Technology Pittsburgh, United States

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 ...
Applications Analyst

1 week ago

All Lines Technology Pittsburgh, United States

Job Description · Job 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 experti ...
Security Analyst

3 weeks ago

Oloop Technology Solutions Pittsburgh, United States

Job Title : Security Analyst III · Work Location: Pittsburgh, PA, Lake Mary, FL (Hybrid-3 days/ Week) · Duration : 6 Months · Job Description · Experience writing complex SQL queries, creating DB views, stored procedures on MS SQL servers. · Ability to come up with business use ...
IT Security Analyst

3 weeks ago

New York Technology Partners Pittsburgh, United States

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 m ...
Application Analyst

6 days ago

All Lines Technology Pittsburgh, United States

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