IndianapolisINRecruiter Since 2001
the smart solution for Indianapolis jobs

Data Transformation Analyst

Company: Centric Consulting
Location: Indianapolis
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, Indianapolis , Data Transformation Analyst, Professions , Indianapolis, Indiana

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 Truck Driver - Paid Training
Description: Job Description: 10 10 Time for a Job Change Make more of yourself and for yourself. Roehl Transport will pay you to get your CDL 38 amp amp earn a great a living as a professional truck driver. (more...)
Company: Roehl - GYCDL
Location: Middletown
Posted on: 09/29/2020

Amazon Package Handler - Full-Time & Part-Time Available (Fairfield)
Description: Shifts: Overnight, Early Morning, Day, Evening, WeekendLocation:Monroe, Fairfield, Kettering, DaytonJob opportunities vary by location. We update postings daily with open positions.Hourly pay rate: Earn (more...)
Company: Amazon Workforce Staffing
Location: Middletown
Posted on: 09/29/2020

Amazon Full-Time Warehouse Order Fulfillment Associate (Fairfield)
Description: Shifts: Overnight, Early Morning, Day, Evening, WeekendLocation:Monroe, Fairfeild, West Chester, DaytonJob opportunities vary by location. We update postings daily with open positions.Hourly pay rate: (more...)
Company: Amazon Workforce Staffing
Location: Fairfield
Posted on: 09/29/2020


CDL A Company Drivers
Description: Truck Driver Benefits br br Medical/Dental, and 401K br Paid vacation br Paid orientation br No forced dispatch br No-touch freight br No hazmat br Cell phone reimbursement (more...)
Company: Poly Trucking
Location: Middletown
Posted on: 09/29/2020

Warehouse Team Members
Description: Job Description: 10 10 Shifts: Overnight, Early Morning, Day, Evening, Weekend Location: Monroe, Fairfield, Kettering, Dayton Job opportunities vary by location. We update postings daily with open (more...)
Company: Amazon Workforce Staffing
Location: Middletown
Posted on: 09/29/2020

Amazon Package Handler (Monroe)
Description: Shifts: Overnight, Early Morning, Day, Evening, WeekendLocation:Monroe, Fairfeild, West Chester, DaytonJob opportunities vary by location. We update postings daily with open positions.Hourly pay rate: (more...)
Company: Amazon Workforce Staffing
Location: Middletown
Posted on: 09/29/2020

CDL A TRUCK DRIVERS! $5K Sign On! Get Home Most Nights! $55,000 - $65,000 Annually!
Description: CDL A TRUCK DRIVERS Get Home Most Nights 55,000 - 65,000 Annually Wooster Motor Way is a family owned and operated company who has been a staple in the local community since 1963 is looking to (more...)
Company: Wooster Motor Ways
Location: Middletown
Posted on: 09/29/2020

High Demand For Quality HVAC Pros - Get New Clients In Your Area
Description: Over 25 million homeowners have trusted HomeAdvisor 1800Contractor to help them find quality professionals with the expertise to turn their home improvement
Company: HomeAdvisor
Location: Middletown
Posted on: 09/29/2020

Amazon Full-Time Warehouse Order Fulfillment Associate (Monroe)
Description: Shifts: Overnight, Early Morning, Day, Evening, WeekendLocation:Monroe, Fairfeild, West Chester, DaytonJob opportunities vary by location. We update postings daily with open positions.Hourly pay rate: (more...)
Company: Amazon Workforce Staffing
Location: Middletown
Posted on: 09/29/2020

CDL A OTR Drivers
Description: Looking for a forever home CLASS A CDL OVER THE ROAD TRUCK DRIVERSWith additional benefits and bonuses WE ARE NOW HIRING OTR TRUCK DRIVERS Magnum LTD pays
Company: Magnum
Location: Middletown
Posted on: 09/29/2020

Log In or Create An Account

Get the latest Indiana jobs by following @recnetIN on Twitter!

Indianapolis RSS job feeds