Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Data Transformation Analyst

Expired Job

Centric Consulting Chicago , IL 60602

Posted 2 months ago

Data Transformation Analyst

Location: Remote/Travel

Do you have a passion for Data and Business Processes?

Want to work at someplace special?

Do you love crafting unique solutions?

Centric Consulting is hiring Data Transformation Analysts for our National team. Data Analysts are the important link on projects, helping bridge the gap between different teams while also making sure the clients' business problems and needs are understood.

Centric offers both a local model with minimal travel as well as a National travel model. This role would involve regular travel (typically within the US).

This is a mid-level full-time/contract opportunity.

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.

What You Will Do

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

Desired Skills

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 mentioned above

Why Centric?

Supportive environment We expect a lot from our Data Transformation Analysts. But you won't be asked to do it alone.

You will have the full support of the National Data and Analytics office leadership and everyone at Centric. We love to help people succeed.

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 figure out how to get you there.

Special culture Hands down, the people are the best part of Centric. But you shouldn't take our word on it check us out on Glassdoor , Facebook or Twitter to get a glimpse inside what makes us different.

Network of technology champions There's no fun in being the only geek in the room. Centric celebrates all things tech.

For example, we hold a yearly gathering called Camp I/O. In the vein of TEDx talks, Camp I/O is an opportunity for technology-minded people across Centric to get together and show off what they can do when not constrained by client requirements and platforms. Check out some of the innovative presentations from last year.

Flexibility This is a full-time work-from-home position which means you are welcome to work wherever you wish be it Starbucks or your home office.

All-company (paid!) vacation trip Who doesn't want to go someplace warm in the winter?

Prefer to contract?

  • Contractor friendly environment Contractors are an important part of our Centric family and we treat them as such. You will find that our policies and practices make it easy for you to contract with us.

  • Benefits eligibility As a W2T temporary employee, you are eligible for Centric's W2T benefits package which includes medical and dental coverage. We are also open to Corp to Corp arrangements (no benefits in that case, however).

  • Full-time potential Many of our full-time employees originally started as contractors. If that's something you are interested in, we can explore those options.

    That said, if you want to remain a contractor that's fine too. We are flexible!

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.



See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Business Operations And Transformation Analyst

Motorola Solutions

Posted 1 week ago

VIEW JOBS 11/2/2018 12:00:00 AM 2019-01-31T00:00 In this role, you'll build upon your experiences to help define and drive the transformation of our our Global Managed and Support Services organization. This role involves shaping and implementing quote-to-cash strategies across the service portfolio. This role will give opportunities to collaborate across the organization and work with the necessary IT teams to configure, test, and implement new processes. Specific tasks include: * Develop repeatable process to support quoting and orderability processes. Detailed documentation is critical. * High proficiency in using Excel, Google Sheets, Tableau, and other business tools used to generate reports. * Provide business requirements and process support for IT projects including Configure/Price/Quote creation and new product introduction automation. * Provide part number set-up and orderability in all required systems. * Manage product lifecycle (revision changes, pricing validity, etc.). * Meeting project time schedules and financial commitments requiring successful coordination with all the stakeholders. * Follow established processes and directions with high degree of accuracy and quality and develop approach to solutions with limited direction and latitude in determining objectives of assignment. * Provide resolutions to a diverse range of complex problems where analysis of data requires evaluation of a variety of factors. * Support issues involving work partners, including order management. * Have a full understanding of area of specialization and resolve a wide range of issues in creative ways. Preferred Skills: * Experience working with customers and/or 3rd party suppliers * Must be highly skilled in Excel/Google Sheets and other productivity software * Experience working with IT teams and being able to communicate requirements. * Strong interpersonal and written/oral communication skills * Proven ability to meet aggressive deliverables and timelines. * Strong influential and leadership skills to effectively interface and communicate with business teams and stakeholders. * Be a self-motivated person with high energy levels and ability to learn quickly. Have the capability of handling a large number of diverse tasks and able to lead in a teaming environment. * Good organizational skills and the ability to think creatively and objectively. * Experience working with customers and/or 3rd party suppliers * Must be highly skilled in Excel/Google Sheets and other productivity software * Experience working with IT teams and being able to communicate requirements. * Strong interpersonal and written/oral communication skills * Proven ability to meet aggressive deliverables and timelines. * Strong influential and leadership skills to effectively interface and communicate with business teams and stakeholders. * Be a self-motivated person with high energy levels and ability to learn quickly. Have the capability of handling a large number of diverse tasks and able to lead in a teaming environment. * Good organizational skills and the ability to think creatively and objectively. Motorola Solutions Chicago IL

Data Transformation Analyst

Expired Job

Centric Consulting