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 Charlotte , NC 28201

Posted 4 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.


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.

upload resume icon
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.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

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
Data Analytics Business Analyst


Posted 4 days ago

VIEW JOBS 1/13/2019 12:00:00 AM 2019-04-13T00:00 Where good people build rewarding careers. Think that working in the insurance field can't be exciting, rewarding and challenging? Think again. You'll help us reinvent protection and retirement to improve customers' lives. We'll help you make an impact with our training and mentoring offerings. Here, you'll have the opportunity to expand and apply your skills in ways you never thought possible. And you'll have fun doing it. Join a company of individuals with hopes, plans and passions, all using and developing our talents for good, at work and in life. Job Description The Business Analyst applies knowledge and facilitative expertise to gather and define requirements, in order to achieve business objectives and provide innovative solutions to business problems. The Business Analyst (BA) Sr Consultant I leads the analysis of business requirements and requests from the business, operations, and other users of IT services. Acts as a lead and contact for the business divisions and technology solution providers for all aspects of solution identification. The BA Sr Consultant I supports projects of moderate to high complexity. Key Responsibilities * Provides expertise for one or more areas of the business through analysis and understanding of business needs; applies a broad knowledge of programs, policies, and procedures in a business area or technical field gained through experience and training * Provides business knowledge and support for resolving technology issues across one or more areas of the business and across multiple projects * Uses appropriate tools and techniques to elicit and define requirements that address more complex business processes or projects of moderate to high complexity * Analyzes requirements and creates or contribute to functional designs, leveraging more advanced technical skills; may help design application prototypes * May assist with project initiation for projects with moderate to high complexity * Follows change control process to manage changes to base lined deliverables and scope for projects of moderate to high complexity * Leads information gathering sessions * Learns to understand current and potential customer needs * Uses customer feedback and other data gathering and analysis techniques to provide recommendation and guide decision-making. * Works with the business owner to help define and manage metrics * Assists with managing the product backlog Job Qualifications * College degree preferred * 3-5 years working experience in insurance, project management, or technology preferred * Experienced in writing technical requirements * Ability to use data analysis techniques to allow informed decision making * Understanding of and experience working in an Agile environment * Working knowledge of JIRA, SQL, Visio, and Excel * Ability to work effectively with offsite business or technology partners The candidate(s) offered this position will be required to submit to a background investigation, which includes a drug screen. Good Work. Good Life. Good Hands®. As a Fortune 100 company and industry leader, we provide a competitive salary – but that's just the beginning. Our Total Rewards package also offers benefits like tuition assistance, medical and dental insurance, as well as a robust pension and 401(k). Plus, you'll have access to a wide variety of programs to help you balance your work and personal life -- including a generous paid time off policy. Learn more about life at Allstate. Connect with us on Twitter, Facebook, Instagram and LinkedIn or watch a video. Allstate Charlotte NC

Data Transformation Analyst

Expired Job

Centric Consulting