Senior Data Analyst

Amatriot Group, LLC; Dallas (TX); Hybrid; USD 75,000 - 110,000; Full time

Job summary

A dynamic data solutions company based in Dallas, TX is seeking a Senior Data Analyst to investigate and analyze data anomalies across various environments. The role involves working closely with teams to document data transformations and assist in data governance initiatives. The ideal candidate will have extensive SQL experience and a strong background in data movements. This position offers a hybrid working environment, requiring in-office attendance 2-3 days a week.

Qualifications

• 4+ years of SQL experience with OLTP, Data Warehouse, and Big Data databases.
• Experience in a Data Analyst role for 4+ years.
• Ability to write medium to complex stored procedures preferred.
• Strong attention to detail.
• 2+ years writing medium to complex stored procedures.
• Ability to collaborate and work as part of a team.
• Extensive background in writing complex queries.
• Extensive knowledge of Data Movement and Processing, including ETL, API, OLAP and best practices for data tracking.
• Self-Motivated; Works well in a team environment.
• Big Data experience (Hadoop, MongoDB) a plus.

Responsibilities

• Investigate and analyze data anomalies reported by the business.
• Collaborate with teams to document data transformations.
• Assist in configuring Data Virtualization and Master Data Management tools.
• 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

Skills

SQL

Data analysis

Communication

Attention to detail

Teamwork

Tools

Exadata

SQL Server

Hadoop

MongoDB

Job description

Career Opportunities with Amatriot Group, LLC

A great place to work.

Share with friends or Subscribe!

Are you ready for new challenges and new opportunities?

Join our team!

Current job opportunities are posted here as they become available.

Subscribe to our RSS feeds to receive instant updates as new positions become available.

Location: Dallas, TX – Hybrid, 2 or 3 days a week (Thursday in-office)

*This represents the potential salary range for this position depending on education level, years of experience and/or certifications in addition to other position specific requirements which may impact salary

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. The right 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
• Self-Motivated
• Works well in a team environment
• Big Data Experience a plus (Hadoop, MongoDB)