Sr Data Analyst

Nava Software Solutions LLC; Dallas (TX); On-site; USD 85,000 - 110,000; Full time

Job summary

NAVA Software Solutions LLC is seeking a Senior Data Analyst to support data anomalies across environments including Data Warehouse, ODS, and ETL initiatives. The role collaborates with Business, DBA, ETL and Data Management teams to analyze data, document transformations, and contribute to Data Governance and Master Data Management setup.

The ideal candidate has 4+ years of SQL experience in OLTP and Data Warehouse contexts, strong communication, and hands-on experience with ETL, data movement,

Qualifications

• 4+ years of SQL experience in OLTP, Data Warehouse and Big Data databases.
• 4+ years in a Data Analyst role.
• Experience with Exadata and SQL Server.
• Familiarity with Data Movement (ETL, API, OLAP).
• Denodo and Master Data Management a plus.
• Postgres and Cloud experience a plus.

Responsibilities

• Investigate and analyze data anomalies and data issues reported by Business.
• Work with ETL, Replication and DBA teams to document data transformations and movements.
• Support data movements and transformations with proactive methodologies.
• Assist in break fixes and production validation related to data derivations and replication.
• Assist in setup of Data Virtualization and Master Data Management tools.
• Keep Data Standardization definitions and Data Lineage documentation up to date.
• Gather information and interpret data patterns and trends.
• Collaborate in a fast-paced, team-based agile environment.

Skills

SQL

Data Analysis

ETL

Data Governance

Data Management

Denodo

Big Data

Postgres

Cloud

Tools

Exadata

SQL Server

Data Virtualization

MongoDB

Job description

NAVA Software is looking for a Sr Data Analyst

Details:

Sr Data Analyst

Location: TX - 4 days/week onsite

Duration: 6-12 months

Description:

• Primary responsibilities of the Senior Data Analyst include supporting and analyzing data anomalies for multiple environments including but not limited to Data Warehouse, ODS, Data Replication/ETL Data Management initiatives.
• The candidate will be in a supporting role and will work closely with Business, DBA, ETL and Data Management team providing analysis and support for complex Data related initiatives. This individual will also be responsible for assisting in initial setup and on-going documentation/configuration related to Data Governance and Master Data Management solutions.
• This candidate must have a passion for data, along with good SQL, analytical and communication skills.

Responsibilities

• Investigate and Analyze data anomalies and data issues reported by Business
• Work with ETL, Replication and DBA teams to determine data transformations, data movement and derivations and document accordingly
• Work with support teams to ensure consistent and pro-active support methodologies are adhered to for all aspects of data movements and data transformations
• Assist in break fix and production validation as it relates to data derivations, replication and structures
• Assist in configuration and on-going setup of Data Virtualization and Master Data Management tools
• Assist in keeping documentation up to date as it relates to Data Standardization definitions, Data Dictionary and Data Lineage
• Gather information from various Sources and interpret Patterns and Trends
• Ability to work in a team-oriented, fast-paced agile environment managing multiple priorities

Qualifications

• 4+ years of SQL experience working in OLTP, Data Warehouse and Big Data databases
• 4+ years of experience working with Exadata and SQL Server databases
• 4+ years in a Data Analyst role
• Strong attention to Detail
• 2+ years writing medium to complex stored procedures a plus
• Ability to collaborate effectively and work as part of a team
• Extensive background in writing complex queries
• Extensive working knowledge of all aspects of Data Movement and Processing, including ETL, API, OLAP and best practices for data tracking
• Good Communication skills
• Self-Motivated
• Works well in a team environment
• Denodo Experience a plus
• Master Data Management a plus
• Big Data Experience a plus (Hadoop, MongoDB)
• Postgres and Cloud Experience a plus