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 Miami , FL 33196

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.


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

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
Cardiovascular Data Abstractor & Analyst

University Of Miami Miller School Of Medicine

Posted 3 days ago

VIEW JOBS 11/11/2018 12:00:00 AM 2019-02-09T00:00 Position Number: P100044187Department / Hospital: UHealth Patient Safety & Quality Office The University of Miami is considered among the top tier institutions of higher education in the U.S. for its academic excellence, superior medical care, and cutting-edge research. At the U, we are committed to attracting a talented workforce to support our common purpose of transforming lives through teaching, research, and service. Through our values of Diversity, Integrity, Responsibility, Excellence, Compassion, Creativity and Teamwork (DIRECCT) we strive to create an environment where everyone contributes in making UM a great place to work. We are one of the largest private employers in Miami-Dade County; home to more than 13,400 faculty and staff from all over the world. The UHealth Patient Safety & Quality department has an exciting opportunity for a Quality Management Analyst 3 for the Cardiothoracic specialty. The incumbent is responsible for managing clinical quality data registry analytics to support established Quality Registry Data Processes and strategic patient safety and clinical quality initiatives for UHealth. Perform data abstraction, validation, and analysis. Create, maintain, and enhance dashboards to visualize outcomes. Ensure an effective feedback loops for continuous performance improvement focused on cardiovascular service line performance improvement. Serve as a data and analytic subject matter expert for the American College of Cardiologys National Cardiovascular Data Registry and the Society of Thoracic Surgeons National Database. The incumbent will lead the design, planning, and production of dashboards and analysis to support cardiothoracic clinical excellence, and quality improvement initiatives. Establish and maintain collaborative working relationships with cardiothoracic service line teams, hospital leadership, and quality leadership to effectively facilitate appropriate data management, timely and accurate reporting of data and outcomes, accurate benchmarking of outcome initiatives, and ability to provide immediate feedback for assigned quality initiatives. Responsible to ensure all work products are compliant with national recognized patient care processes and clinical outcomes. Ability to function well under timeline commitments. Serve as auxiliary support for the Quality Data and Analytics Team. The ideal candidate is a seasoned data abstractor and quality analyst that has successfully worked with clinicians in a hospital or clinical setting on adult cardiac surgery measures and general thoracic surgery measures, participated in high performing teams to improve performance in a cardiothoracic service line. Excellent presentation skills, excellent attention to detail, clear articulate communication, ability to receive feedback constructively, and demonstrated ability to engage clinical decision makers on performance improvement opportunities. Job Functions: * Prepare comprehensive documentation to support all related activities. * Ensure the timely reporting to appropriate individuals through a systematic and defined multidisciplinary process. * Participate in professional development opportunities and required trainings. * Accountable to respect the rights and privacy of others at all times, including the confidentiality of patient information in accordance with established administrative policies and procedures, regulatory standards and guidelines, and governmental rules and regulations. * Work as a team member to meet departmental responsibilities, goals and state and national reporting goals. * Serve as a reliable resource to hospital staff, physicians, and patients on matters related data analysis. * Participate in professional development opportunities and required trainings, and assigned committees. * Assist with data analysis, reports and presentations for departmental committees, meetings, and projects as requested. * Keep manager briefed on all critical updates, and serve as a subject matter expert in support of manager. * Cross-train on all functions related to the development, update and maintenance of assigned decision support databases; inclusive of ongoing collaboration with the group's Database Technology Managers in all matters related to the documentation of database functions. * Prepare comprehensive documentation to support all related activities, inclusive of maintaining program documentation and files. * Maintain ability to perform all functions with a high level of competency and with minimal supervision, e.g., interpret and validate data; interpret quality reports; conduct analysis and recommends solutions; identify, coordinate, collect and ensure the availability of data; etc. Minimum Bachelor's degree in Industrial Engineering, Information Management, Nursing, Health Sciences, or related field. Preferred: Clinical licensure and/or CPHQ certification. Experience: * Minimum 3 years experience with core measure retrospective abstraction, abstracting data for clinical databases, data manipulation, data validation, analysis, creating dashboards to track performance. * Required experience working with Society of Thoracic Surgeons National Database (ACS, CABG, VALVE). * Required knowledge of the National Cardiovascular Data Registry and medical /disease registry data; * Required experience supporting clinical quality or process improvement initiatives in a hospital or clinical setting. * Advanced proficiency with creating complex and advanced formulas in Excel, such as v-look up, Excel Pivot tables, and conditional formatting. * Knowledge of healthcare quality and outcomes measurement and reporting. * Experience using electronic medical records. * Demonstrated ability to work independently with minimal supervision. * Demonstrated knowledge of medical terminology and understanding of cardiovascular related diseases. * Knowledge of EPIC as well as their respective report writer tools. * Proven knowledge of and abilities using software tools including but not limited to, Business Intelligence tools, MicroStrategy, Microsoft Power BI and Tableau as well as data modeling expertise and complex problem solving skills. * Experience with clinical database systems and decision support tools including and understanding of medical terminology and clinical coding protocols. Knowledge, Skills and Behaviors: * Commitment to University Values: Diversity, Integrity, Responsibility, Excellence, Compassion, Creativity, Teamwork. * Knowledge of data collection and analysis, general performance improvement, statistical tools, and process mapping. * Excellent technical skills: Demonstrated technical skills and aptitudes related to all computer related activities, inclusive of the ability to learn and apply new applications, platforms, etc. Proficiency in the use of PCs, spreadsheets, report generating, working with cloud-based and server-based application systems * Strong analytical skills: Experience in analyzing clinical performance data strongly. * Excellent interpersonal skills: Ability promote and sustain outstanding interpersonal and customer service skills (verbal and written) while accepting responsibility to ensure all working relationships are respectful and professional. * Excellent critical thinking skills: Ability to consistently apply independent and critical thinking skills to solve problems and escalate problems. * Excellent ability to be self-directed: Ability to apply effective prioritization, organization, analytical, and project management skills (simultaneous multiple projects). * Excellent attention to detail: Demonstrated ability to accurately review, screen and enter data. * Excellent communication and presentation skills: Ability to clearly, effectively, and respectfully communicate questions, ideas, and solutions verbally and in writing to a broad spectrum of specialized skill and clinical experience. * Ability to conform to shifting priorities, demands, and timelines through analytical and problem solving capabilities * Ability to ensure consistent and accurate adherence to established workflows and processes. * Required ability to sustain mature judgement and maintain strict confidential information and patient confidentiality as mandated by HIPAA, and University policies, respect the rights and privacy of others at all times. * Required to maintain current knowledge and practice in compliance with standards established by external regulatory agencies that impact job performance and deliverables, and maintain fluency in governmental quality program requirements and rules. Any appropriate combination of relevant education, experience and/or certifications may be considered. UHealth-University of Miami Health System, South Florida's only university-based health system, provides leading-edge patient care powered by the ground breaking research and medical education at the Miller School of Medicine. As an academic medical center, we are proud to serve South Florida, Latin America and the Caribbean. Our physicians represent more than 100 specialties and sub-specialties, and have more than one million patient encounters each year. Our tradition of excellence has earned worldwide recognition for outstanding teaching, research and patient care. We're the challenge you've been looking for. The University of Miami offers competitive salaries and a comprehensive benefits package including medical and dental benefits, tuition remission, vacation, paid holidays and much more. The University of Miami is an Equal Opportunity Employer - Females/Minorities/Protected Veterans/Individuals with Disabilities are encouraged to apply. Applicants and employees are protected from discrimination based on certain categories protected by Federal law. Click here for additional information- Patient safety is a top priority. As a result, during the Influenza ("the flu") season (September through April), the University of Miami School of Medicine requires all employees who provide ongoing services to patients, work in a location (all Hospitals and clinics) where patient care is provided, or work in patient care or clinical care areas, to have an annual influenza vaccination. Failure to meet this requirement will result in rescinding or termination of employment. The University of Miami is an Equal Opportunity Employer - Females/Minorities/Protected Veterans/Individuals with Disabilities are encouraged to apply. Applicants and employees are protected from discrimination based on certain categories protected by Federal law. University Of Miami Miller School Of Medicine Miami FL

Data Transformation Analyst

Expired Job

Centric Consulting