Sr. Data Analyst
- 1Point System
12 Hours Ago
NA
NA
Newark-NJ
8-15 Years
Required Skills: Data Analyst, Modeling, Informatica, ETL, SQL, oracle, DB2
Job Description
Title: Sr. Data Analyst
Location: Newark, NJ Hybrid
Duration: 12 months
Notes-
Based on the conversation, we are looking for a Sr Data Analyst for a long-term, hybrid role supporting a corporate data governance platform. The focus is on coordination, data analysis, and understanding data structures across various systems. Key skills required are Informatica (Profiling, Quality, Lineage) and strong SQL for simple queries. In resumes, look for experience with Informatica, SQL, Oracle, SQL Server, DB2, data analysis, and roles coordinating between technical teams. The position requires 2 days in-office until June, then 3 days a week.
Informatica
SQL- Developer with Data Analysis Experience
Data Quality
Data Governance
Data Modelling
SQL- Good
more of an integration-no development-max data analysis
Data Governance Platform
Will have to work on Oracle- SQL Server- AWS Redshift- Data Servers
Job Description
Responsibilities:
- Database design: Design and implement efficient database structures and schemas to support application functionality Code writing: Write and optimize complex SQL queries for data retrieval, manipulation, and reporting Database queries: Write SQL queries to extract and manipulate data Testing and troubleshooting: Test databases and identify and fix issues related to performance, security, or data integrity Software specifications: Research, design, document, and modify software specifications Business requirements: Analyze the company's data need and assist in data migration and transformation projects to support business needs
- Collaboration: Work across IT teams and with business users understand the business needs and translate it to implementation.
- Security processes: Develop security processes Best practices: Develop and maintain documentation for database schemas, procedures, and best practices
- Standards: Verify that all database programs adhere to the organization’s and performance standards.
- Database performance: Assess the effectiveness and performance of database systems and applications
Requirements and Skills:
- 5-7 years of experience working in Oracle and DB2 Databases.
- Proven work experience as a Database developer.
- In-depth understanding of data management (e.g. data discovery, data analysis, transformation, data quality, security and monitoring).
- SQL Tuning techniques to prevent performance degradation and understanding on how to use Explain Plan/Query Analyzer/Optimization Tool is required.
- Knowledge of software development and Agile delivery methodology.
- Proficiency in working with specific database like DB2, Oracle & SQL server.
- Working knowledge of ETL processes and tools (i.e., Informatica for data extraction, transformation, and loading from various sources into existing databases) Excellent analytical and organizational skills.
- Understanding the needs of front-end users and having a problem-solving mindset.
- Excellent verbal and written communication skills.
