Data Transformation Analyst
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
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
5+ years' experience around the skills mentioned above
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.