Senior Data Analyst

Colaberry; Dallas (TX); On-site; USD 95,000 - 125,000; Full time

Job summary

Colaberry in Dallas, TX is seeking a Senior Data Analyst to support and analyze data anomalies across environments including Data Warehouse, ODS and Data Management initiatives. You will collaborate with Business, DBA, ETL and Governance teams to provide analysis and support for complex data projects.

Responsibilities include investigating data issues, documenting transformations, supporting data movements, and assisting in Data Governance and Master Data Management setup and documentation.

Qualifications

• 4+ years of SQL experience in OLTP, Data Warehouse and Big Data databases.
• 4+ years of experience with Oracle Exadata and SQL Server databases.
• 5+ years in data engineering or software development, with hands-on experience in MDM implementations.
• Strong attention to detail and ability to collaborate in a team.
• 2+ years writing medium to complex stored procedures is a plus.
• Extensive experience with data movement and processing including ETL, API, OLAP, and data lineage.
• Familiarity with data governance frameworks and REST API development.

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 consistent data movement methodologies and pro-active issue resolution.
• Assist in break fix and production validation related to data derivations and replication.
• Assist in configuration and setup of Data Virtualization and Master Data Management tools.
• Maintain documentation for Data Standardization definitions, Data Dictionary and Data Lineage.
• Gather information from various sources and interpret patterns and trends.
• Collaborate in a fast-paced agile environment across multiple projects.

Skills

SQL

Data governance

Communication

ETL

Data warehousing

Oracle Exadata

SQL Server

Ab Initio

REST API

Hadoop

MongoDB

Tools

Ab Initio

Job description

Primary responsibilities of the Senior Data Analyst includes 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

• Build and optimize data integration workflows connecting source systems to centralized MDM hub
• Configure and tune rules, deduplication routines, and survivorship criteria to ensure a single source of truth in data set.
• Partner with analysts, data governance teams, and business stakeholders to implement master data management at Oncor.

Qualifications

• 4+ years of SQL experience working in OLTP, Data Warehouse and Big Data databases
• 4+ years of experience working with Oracle Exadata and SQL Server databases
• 4+ years in a Data Analyst role
• 5 years in data engineering or software development, with focused hands-on experience in MDM implementations.
• 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
• Proficiency with Ab Initio enterprise tool.
• Deep familiarity with data governance frameworks, API development (REST)
• Self-Motivated
• Works well in a team environment
• Big Data Experience a plus (Hadoop, MongoDB)