DATA QUALITY ANALYST SKILLS, EXPERIENCE, AND JOB REQUIREMENTS
Published: October 3, 2024 - The Data Quality Analyst demonstrates strong expertise in data analytics and SQL data modeling, ensuring precise data reporting and analysis. Known for problem-solving and adaptability, this role focuses on improving processes and driving results in fast-paced environments. With experience across various enterprise analytics functions, the analyst collaborates effectively with teams to enhance data integrity and implement efficient data solutions.
Essential Hard and Soft Skills for a Standout Data Quality Analyst Resume
- SQL Expertise
- Data Modeling
- Data Profiling
- Quality Assessment
- Data Governance
- Visualization Tools
- ETL Processes
- Data Reporting
- Programming Skills
- Excel Analysis
- Analytical Thinking
- Problem Solving
- Attention to Detail
- Adaptability
- Communication Skills
- Teamwork
- Time Management
- Self-Motivation
- Critical Thinking
- Quick Learning
Summary of Data Quality Analyst Knowledge and Qualifications on Resume
1. BS in Data Science with 2 years of Experience
- Experience performing data analysis including SQL
- Exposure to asset management including Bloomberg or other master data providers
- Experience with one or more automated data quality tools e.g. OwlDQ, DQ measurement, Informatica, IBM, Oracle, Talend and Microsoft.
- Previous experience working in a Data Quality function
- Good communication skills and self-motivated
- Ability to work without supervision
- Experience working in a globally based team.
- Must display a good aptitude for learning and strong work ethic
2. BS in Computer Science with 3 years of Experience
- Professional experience in a Quality Assurance role in an Agile environment
- Professional experience in BI Reporting Quality Assurance role
- Experience participating in scrum ceremonies including Standup, Sprint Planning, Refinement, Sprint Review, and Retrospectives
- Experience with Source Data formats, Data Mapping documents, Data transformation rules, and Data quality Requirements
- Ability to work on multiple projects in parallel and adapt to changes in priority as needed.
- Must possess excellent written/oral communication and organizational skills with the ability to work within a fast-paced company with increasing needs.
- Strong desire for continuous learning and personal growth
- Experience in Power BI Report testing
- Experience with creating and executing SQL test scripts
- Experience with managing test data in an automation environment
- Experience with performance testing
3. BS in Information Technology with 4 years of Experience
- Good knowledge of Data Management and Data Quality industry best practice.
- A clear understanding of all general and industry specific legislation and regulation pertaining to data including GDPR, Competition Law, REMIT, Business Separation
- Ability to support the implementation of industry best practice into an organisation and use this to drive measurable improvements at an enterprise level.
- Understanding of challenges and opportunities facing the Energy sector in a data driven knowledge economy.
- Good breadth and depth of knowledge and experience in the delivery of IT services ideally from a similar role in a large organisation.
- Skilled in Data Quality Management disciplines.
- A good understanding of and experience of the application of Data Quality dimensions to Data Quality management
- Ability to work with business users and IT peers to investigate, discuss, document, and remediate data quality issues
- A good understanding of organisational data flows, lineage and hierarchies.
- Knowledge of market leading Data Quality tools such as Informatica, Collibra, IBM IGC, Power BI etc.
- Ability to work with and collaborate with a high-performing team across remote locations.
- Good stakeholder management skills, using persuasion and understanding of business goals to influence strategic direction on data.
- Strong written, verbal and presentation skills, able to influence effectively at all levels of the organisation.
4. BS in Statistics with 2 years of Experience
- Experience with using SQL and DAX with the ability to create, update, and maintain queries to pull and transform data
- Experience with connecting data through visualization tools such as Microsoft Power BI
- Understanding of big data table structures/schemas
- Attention to detail and ability to identify minor data discrepancies
- Strong time management and prioritization skills with an ability to hit multiple concurrent deadlines
- Motivated and energized in a start-up environment where every day may not be the same and data sets are evolving
- Eagerness and ability to apply learning quickly
- Driven to do well while doing good at a mission driven company
- Skilled problem solver with ability to innovate on solutions
- Demonstrated data quality and analysis skills
- Experience with metadata tools (Collibra, Informatica) and data modeling tools (ER Studio)
- Experience with data quality tools (Informatica Data Quality)
- Experience in insurance and financial services
5. BA in Business Analytics with 3 years of Experience
- Experience in data analytics, data analytics and reporting environment
- A data geek with enviable SQL data modeling skills and a passionate sense of ownership
- A self-starter who enjoys working in a small, rapidly changing, fast-paced environment
- Confident enough to course correct a process or team when required
- Methodical, executing through several approaches to determine the best fit
- Energized by learning even if outside the scope of day-to-day responsibilities
- Comfortable working on several different tasks throughout the workday
- Proficient in programming against significant data assets with a working knowledge of SQL
- Ability to gather requirements, test strategies, design deliverables
- Subject matter expertise in a wide variety of Salesforce data assets
- Knowledge of enterprise analytics across Ops, Sales, HR, Marketing, Finance, Accounting
- Proven analytical, evaluative, and problem-solving abilities
- Skilled teaching and instruction capability
- Extensive experience working in a team-oriented, collaborative environment
6. BS in Information Systems with 5 years of Experience
- Strong communicator and are able to present analyses in a clear manner
- Excellent English written and verbal communication skills
- Knowledge of and experience in Data Analysis in the financial services industry
- Expert with strong analytical skills, using state-of-the-art methods and techniques
- Experienced in relevant tooling such as PowerBI, Tableau, R, SQL, Python
- Actively keep up professional knowledge and translate external trends into applicable knowledge
- Actively ask for help and feedback and are not afraid to give feedback
- Easily adapt to a new environment
- Experience in database testing
- Ability to understand, write, and execute very complex SQL queries
- An understanding of stored procedures
- Experience working with T-SQL
- Experience in a Software QA capacity
7. BS in Mathematics with 3 years of Experience
- Comprehensive knowledge of data governance, data quality, and metadata management practices and processes
- Ability to quickly assimilate into a new team and understand the developing methods, capabilities and tools
- Ability to organize and manage multiple priorities and achieve results
- Good analytical skills with high attention to detail and accuracy
- Operational knowledge of Informatica’s Governance platform (Axon, EDC, IDQ) or other DG platforms
- Experienced in working in scheduling tools and finding the reason for errors in the daily batch.
- Experienced in searching data to ensure that fx.
- Experienced with ETL Process and ETL tools like MS SSIS/SSAS
- Experience with bringing data into a data warehouse and data cube
- Quality-oriented and likes working with details