Data Transformation Analyst in Miami, FL

$80K - $100K(Ladders Estimates)

Centric Consulting   •  

Miami, FL 33299

Industry: Technical Services


5 - 7 years

Posted 37 days ago


The Data Transformation Analyst is responsible for developing data models and then specifying how raw source data is transformed into those models. The responsibility for data accuracy rests on your shoulders. You will partner with a Business Analytics Designer to ensure a high-quality data warehouse and visualization solutions.

Join our team

Centric Consulting is not the typical consulting company. We live our core values and bring them with us in all we do for our clients and community. Our core purpose is simple: every day we strive to provide unmatched customer and employee experiences and foster a culture of respect, diversity, and transparency. It's this culture, our people, and delivery that come together to make Centric a trusted advisor to local businesses.

Our Data & Analytics practice believes that data can drive business value and performance. But it takes the right people, skills and approach to deliver expected results. That's where you come in! For us, Data and Analytics is more than just a set of technologies. It's about skilled individuals who can align technical capabilities to bring value to a business. What we value the most: people who are dedicated to delivering high quality solutions. It's not enough for things to look good on the surface. They must be built on strong technical foundations. We're looking for a Data Transformation Analyst to join our growing team.

In this role, you will:

  • Review existing business requirements: UML information models, business and metric definitions, analytics use cases and visualization specs
  • Design data models to meet business requirements
  • Maintain data models in a data-modeling tool (e.g. Enterprise Architect, Erwin, etc.)
  • Physically implement data models in a database and then manage in source control
  • Analyze source data
  • Interact with business stakeholders to determine how to handle data quality and data governance concerns.
  • Develop and document SQL queries to extract data from the source system in a fully transformed state.
  • Communicate SQL specifications to ETL developers
  • Conduct code reviews and data reviews to ensure the transformations where implemented per your specification.
  • Participate in data validation and testing

A successful candidate will have the following characteristics:

  • Mandatory skills – these will be assessed

o Very strong SQL skills

o Forensic data analysis skills

o Experience writing sophisticated data transformations

  • Data steward or other data governance responsibilities
  • Strong written and verbal communication
  • Target Experience: 5+ years' experience around the skills above

Valid Through: 2019-10-11