Data Analyst - MDM

ETL, Data Analyst, MDM, Data Extraction, Data Integration
Full Time
$0 - $0
Work from home available Travel required to 50%.

Job Description

Title: Data Analyst - MDM

Location: Dallas, TX/Remote

Terms: Full Time

So, who are we? What s our story?

Excers is a company of professionals who believe in excellent customer service and achieving the highest level of technology competencies. Our mission is to help companies gain real, measurable business value from their implementation of leading technology solutions in the areas of Customer Experience Management (CX), Project Portfolio Management, Business to Business Integration, Workforce Management, and Enterprise Architecture.

Excers set sail with a mission to rescue companies stranded when justifying tech ROI. We at Excers improve the business value our customers receive from solutions and help them reduce costs of implementing and using industry leading products like Medallia. We make working with web applications and enterprise solutions a cakewalk.

Job description

As an MDM Analyst you will be responsible for maintaining data warehouse solutions that deliver diverse reporting and analytic capabilities to our clients and their organization. The candidate must demonstrate an understanding of data warehouse concepts, practices, and procedures, has technical hands on experience supporting data warehouse solutions, has strong communication skills and the ability to provide support to customers and collaborate internally on projects as a contributor/specialist.

This candidate should also be able to find creative solutions to complex and diverse business requirements. This individual works with data integration programmers, data architects, and business stakeholders to ensure enterprise DW solutions are reliable, scalable, flexible and low maintenance.

Responsible for defining data quality rules such as completeness, standardization, validation, integrity, uniqueness, and reference data rules.

Position

  • Assists in the development and maintenance of complex data storage structures needed to support data warehouse functions. Assures data is maintained in consistent formats.
  • Troubleshoots data warehouse issues, tracing ETL packages back to source systems. Works cross functionally with Data Warehouse Developer to overcome complex issues.
  • Provides initial business analysis for Data Warehouse requests, working with end users to understand and document business requirements.
  • Analyzes user data to determine business rules and creates suggested data organization requirements for approval. Become the subject matter expert on data within the Data Warehouse
  • Leads project management affecting the data warehouse while working with cross functional teams
  • Tracks the life cycle of Data Warehouse activities from development/testing to production and keeps stakeholders apprised
  • Performs testing on changes to the data warehouse ensuring new development matches the business need. Performs regression testing to ensure no changes adversely impact the Data Warehouse
  • Maintains relationships with users to identify and develop additional data sources for the data warehouse consistent with business rules and customer needs
  • Works with business users to define requirements for outbound data feeds and works with Data Warehouse developer to implement solution which could include flat files or staging tables in the Data Warehouse
  • Trains and assists users, managers and technical staff regarding access, use and storage of data in the Data Warehouse
  • Develops various methods of communicating with Data Warehouse users regarding changes in source applications and source databases that supply information to the data warehouse
  • Recommends strategies and updates to the data warehouse systems in response to changes requirements.

Education and Experience

  • 3+ Years' experience with Data Management in an analyst role
  • Technical Bachelor's degree preferred or equivalent plus 3 or more years technical experience
  • Excellent communication skills and ability to write clear technical requirements for EDW & MDM initiatives.
  • Ability to analyze structured and unstructured data comprehensively using SQL, Excel, and other tools
  • Extensive data modeling & data architecture exposure
  • Strong SQL skills: querying using advanced functions like windowing; optimizing queries to run efficiently; debugging queries to find logical errors.
  • Basic understanding of data schema, dimensional data warehousing

Core Values - At the Heart of Excers

Lasting Relationships

We are absolutely dedicated to building outstanding relationships - both within our team, and with our clients. We know that people are at the heart of every successful business. That s why, when you work with Excers, you get a stellar experience that s all about you.

Motivated and Passionate Experts

We are dedicated to consistent, honest communication, where all members share and grow professionally. This means you work with happy, motivated, and passionate experts - each at the height of their profession.

Purpose Driven Leadership

Energy, passion, and a sense of purpose propel our team to deliver outstanding results to each of our clients. We believe in your business, and each of our professionals work their very hardest to launch your company to the next level.

Creativity

Our team members are empowered to work creatively, to bring their own ideas to the table, and to build confidence through experience. The result? A motivated team that loves showing up every day.

Posted By

Vicky Sharma

185 RecklessTown Way Chesterfield, NJ, 08515

Dice Id : 10522605
Position Id : 6303191
Originally Posted : 3 weeks ago
Have a Job? Post it

Similar Positions

Data Analyst
  • STONE Resource Group
  • Addison, TX
Data Analyst/Steward
  • Compass Technology Group
  • Dallas, TX
Data Analyst
  • Collabera
  • Plano, TX
Data Analyst
  • Kforce Technology Staffing
  • Plano, TX
Data Analyst- No third parties please!!
  • Make Corporation
  • Dallas, TX
Data Analyst
  • ASAP Staffing
  • Irving, TX
Data Analyst
  • Software Guidance & Assistance
  • Plano, TX
Junior Data Modeler
  • ProCom Consulting, Inc.
  • Dallas, TX
Digital Data Analyst
  • Login Consulting Services, Inc
  • Plano, TX
Business Data Analyst
  • AKT, LLC
  • Dallas, TX
Data Analyst
  • Profile500 Corporation
  • Irving, TX
Data Governance Analyst
  • DIVERSANT, LLC.
  • Dallas, TX
Teradata Devloper/Data Analyst
  • VDart, Inc.
  • Grapevine, TX
Digital Data Analyst
  • Calance
  • Plano, TX