Senior Data Analyst #2470

Genius Road, LLC; Dallas (TX); On-site; USD 80,000 - 110,000; Full time

Benefits offered by this job

Collaborative team environment

Impact on key data initiatives

Opportunities for growth and skill development

Job summary

A leading consulting firm in Dallas is seeking a Senior Data Analyst for a 6-12 month contract. The role involves investigating data anomalies, collaborating with cross-functional teams, and working with SQL in both Data Warehouse and Big Data environments. The ideal candidate will have 5+ years of experience and strong communication skills, with the opportunity for professional growth in a dynamic setting.

Qualifications

• 5+ years as a data analyst with strong SQL experience.
• 2+ years of experience writing medium to complex SQL stored procedures.
• Experience with Data Virtualization (Denodo) is a plus.

Responsibilities

• Investigate and resolve data anomalies reported by business users.
• Collaborate with ETL, DBA, and Data Management teams.
• Identify patterns and trends from various data sources.

Skills

SQL experience in OLTP, Data Warehouse, and Big Data environments

Troubleshooting abilities

Attention to detail

Excellent communication skills

Tools

Oracle databases

Denodo

Hadoop

MongoDB

Exadata

Job description

Overview

Senior Data Analyst — Contract Length: 6-12 months plus potential extension. Location: Dallas, Texas – Hybrid – 3 days onsite.

Our client requires a Senior Data Analyst to investigate data anomalies, support data management initiatives, and collaborate with cross-functional teams (Business, DBA, ETL, and Data Management). This role involves analyzing data across various environments (Data Warehouse, ODS, ETL), supporting data transformations, and contributing to Data Governance and Master Data Management solutions. A strong SQL background, attention to detail, and good communication skills are essential.

This is a long-term opportunity that offers the chance to work with cutting-edge technologies and provides significant potential for career growth and advancement.

Key Qualifications

• 5+ years as a data analyst with SQL experience in OLTP, Data Warehouse, and Big Data environments
• 2+ years of experience writing medium to complex SQL stored procedures
• Strong SQL querying and troubleshooting abilities
• Experience with Oracle databases is required, including SQL and PL/SQL development
• Familiarity with data movement (ETL, Replication) and Big Data technologies (Hadoop, MongoDB, Exadata)
• Experience with Data Virtualization (Denodo) is a plus
• Strong attention to detail and analytical skills is a must
• Excellent communication and collaboration skills
• Self-motivated, with the ability to work in a fast-paced team environment

Key Responsibilities

• Investigate and resolve data anomalies reported by business users
• Collaborate with ETL, DBA, and Data Management teams on data transformations, movement, and derivations
• Assist with break-fix and production validation for data replication and transformations
• Maintain up-to-date documentation on data governance, standards, and lineage
• Identify patterns and trends from various data sources to provide actionable insights

What’s in it for you?

• Work with a collaborative and innovative team
• Make an impact on key data initiatives
• Excellent opportunities for growth and skill development in a dynamic environment

Genius Road, LLC is proud to be a Certified Women’s Business Enterprise, an Equal Opportunity Employer and values diversity. All employment is decided on the basis of qualifications, merit and business need.