Position:: Data Analyst with ETL
Location: Pittsburgh, PA(Initially Remote)
Mandatory Skills:: Data Analyst, ETL,SAP BODS and AWS
Primary Responsibilities:
- Designs and develops ETL solutions using data warehouse design best practices for Next Generation Analytics platform
- Analyze data requirements, complex source data, data models, and determine the best methods in extracting, transforming and loading the data into the data staging, warehouse and other system integration projects.
- Analyze business requirements and outline solutions.
- Have deep working knowledge of on-prem & cloud ESB architecture to address the client's requirements for scalability, reliability, security, and performance
- Provide technical assistance in identifying, evaluating, and developing systems and procedures.
- Document all ETL and data warehouse processes and flows..
- Develop and deploy ETL job workflow with reliable error/exception handling and rollback.
- Manage foundational data administration tasks such as scheduling jobs, troubleshooting job errors, identifying issues with job windows, assisting with Database backups and performance tuning.
- Design, Develop, Test, Adapt ETL code & jobs to accommodate changes in source data and new business requirements.
- Create or update technical documentation for transition to support teams.
- Develop automated data audit and validation processes
- Provides senior technical leadership to design, architecture, integration and support of the entire data sourcing platform with a focus on high availability, performance, scalability and maintainability
- Manage automation of file processing as well as all ETL processes within a job workflow.
- Develop, Contribute and adhere to the development of standards and sound procedural practices.
- Proactively communicate innovative ideas, solutions, and capabilities over and above the specific task request
- Effectively communicate status, workloads, offers to assist other areas.
- Collaboratively work with a team and independently. Continuously strive for high performing business solutions
- Perform and coordinate unit and system integration testing.
- Participate in design review sessions and ensure all solutions are aligned to pre-defined architectural specifications.
- Ensure data quality throughout entire ETL process, including audits and feedback loops to sources of truth.
Competencies & Experience Required/Desired:
- 6+ years of Data Engineering experience in ETL design, development, optimization & testing using PL/SQL, SAP Data Services (BODS) or Talend etc
- 5+ PL/SQL, Complex SQL Tuning, Stored Procedures, Data Warehousing best practices etc.
- 3+ years of experience in relational and Cloud database design, optimization and performance; preferably with AWS (S3 and Redshift), SAP HANA, BW, Oracle, and Hadoop
- 3+ years of experience in developing flows using batch, Realtime and streaming process to personalize experiences for our customers.
- 2+ years of experience in designing service-oriented architecture (SOA), RESTful APIs and enterprise application integration (EAI) solutions utilizing MuleSoft Platform
- 2+ years of experience with CI/CD tools like Jenkins, GIT, Java and Shell scripting
- Strong problem-solving capabilities. Results oriented. Relies on fact-based logic for decision-making.
- Ability to work with multiple projects and work streams at one time. Must be able to deliver results based upon project deadlines.
- Willing to flex daily work schedule to allow for time-zone differences for global team communications
- Strong interpersonal and communication skills