CincinnatiOHRecruiter Since 2001
the smart solution for Cincinnati jobs

Data Transformation Analyst

Company: Centric Consulting
Location: Cincinnati
Posted on: September 14, 2020

Job Description:



Data Transformation Analyst



Work Location



National



Job Code

2205




Apply Now

Data Transformation Analyst

Job Location: Boston, Charlotte, Chicago, Cincinnati, Cleveland, Columbus, Indianapolis, Louisville, Miami, Seattle, St. Louis

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.

Summary:

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.

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

        What makes Centric different?


        • Special Culture - Our people make us different. We have highly talented, intelligent individuals across a broad variety of disciplines - who are eager to learn from you and share their own expertise. We embrace fresh perspectives and each other. Don't take our word for it - check us out on Glassdoor, Facebook, Twitter or Instagram to get a glimpse inside what makes us different.

        • Growth opportunities - As a mid-size firm, there is more flexibility when it comes to career paths. Figure out what you want to do and we'll help you figure out how to get there.

        • Impact - We think of ourselves as a big company with a small company feel - a local player with global reach that combines business, technology and industry expertise.

        • Unmatched Experiences - We are allowed to be ourselves here. We are encouraged to be human. It's at the root of who we are as a firm and why we're here.

        • Innovation - We value passion, determination, perseverance, and innovation. We are inspired because we believe in what we are doing and where we are going.

        • Passion for the greater good - We are steadfast in our devotion to the communities we serve and in actively promoting employee involvement in community improvement projects.

          Centric believes the best solutions come from diverse teams. We strive to have an environment where everyone has an opportunity to be successful regardless of their race, color, religion, gender, national origin, ancestry, age, disability, military or veteran status, sexual orientation or gender identity.

Keywords: Centric Consulting, Cincinnati , Data Transformation Analyst, Professions , Cincinnati, Ohio

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Professions Jobs


CDL-A Owner Operator Truck Driver
Description: CDL-A SPECIALIZED OWNER OPERATOR TRUCK DRIVER JOBSCDL-A Owner Operators Average 156k/Year With The Support You Want Can you really love hard work hauling unique, high valued specialized freight YES, (more...)
Company: CRST
Location: Middletown
Posted on: 09/20/2020

CDL A Drivers - Car Haul - Excellent HOURLY Pay
Description: br br Now Hiring CDL-A Drivers for Dedicated Runs Car Haul br Call 877 791-2341 or Apply Online Below br br Car Haulers Quit guessing what your percentage pay is going to be Get paid hourly, (more...)
Company: Hogan Transports, Inc.
Location: Fairfield
Posted on: 09/20/2020

Amazon Workforce Staffing Amazon Warehouse Worker Fulltime
Description: Amazon Workforce Staffing
Company: Cylcon Jobs
Location: Middletown
Posted on: 09/20/2020


Cylcon Jobs: Fulltime Amazon Warehouse Operator 500 Signon Bonus
Description: Fulltime Amazon
Company: Cylcon Jobs
Location: Middletown
Posted on: 09/20/2020

Click To See Company Name: Seasonal Parttime Amazon Warehouse Operator 500 Signon Bonus
Description: Seasonal Parttime
Company: Click To See Company Name
Location: Middletown
Posted on: 09/20/2020

TransAm Trucking Company Truck Driver Jobs
Description: New drivers are now eligible for 2,500 in sign-on incentives br br TransAm Trucking is now hiring company CDL-A truck drivers for long-haul career opportunities Apply today and enjoy life on the (more...)
Company: Trans Am
Location: Middletown
Posted on: 09/20/2020

Production Employee
Description: Job Description br br Start time can be between the hours of 4:00 am- 6:30 am. Working 8-12hr shifts 5-6days a week. br br Pay: 11.00/hr br br Position: Production Employee br br br (more...)
Company: Staffanation
Location: Fairfield
Posted on: 09/20/2020

Amazon Workforce Staffing Amazon Warehouse Worker Immediate Hire Fulltime
Description: Amazon Workforce Staffing
Company: Cylcon Jobs
Location: Middletown
Posted on: 09/20/2020

CDL-A Regional Truck Driver - LEX
Description: Job DescriptionRegional driver opportunities with a real career path, weekly home time more advantages than anyone else can offer When you apply to be part of the Averitt team, you''ll be blown away (more...)
Company: AVERITT
Location: Fairfield
Posted on: 09/20/2020

Receiving Material Handler
Description: Job DescriptionReceiving Material Handler - Havertys Cincinnati Distribution CenterHavertys Furniture Distribution is the backbone of our company. Our Distribution Centers serve as vital connections between (more...)
Company: Havertys
Location: Fairfield
Posted on: 09/20/2020

Log In or Create An Account

Get the latest Ohio jobs by following @recnetOH on Twitter!

Cincinnati RSS job feeds