DATA INTEGRITY ANALYST SKILLS, EXPERIENCE, AND JOB REQUIREMENTS
Published: MM DD, 2024 - The Data Integrity Analyst possesses extensive experience in developing, coding, testing, and supporting data and software applications, alongside proficiency in data warehousing with RDBMS such as SQL Server, Oracle, and SAP. Expert in constructing scalable ETL processes, utilizing integration platforms like SSIS, and engaging in data modeling; also skilled in leveraging front-end visualization tools like Tableau and PowerBI. Demonstrates strong capabilities in software development management tools including GitHub and Azure DevOps, with a solid understanding of big data technologies like Cloudera Hadoop, and adept in programming with Java, Python, and Scala.
Essential Hard and Soft Skills for a Standout Data Integrity Analyst Resume
- Data Analysis
- Data Quality Assurance
- SQL Programming
- Data Profiling
- Data Governance
- ETL Processes
- Data Validation Techniques
- Metadata Management
- Database Management
- Data Auditing.
- Attention to Detail
- Problem Solving
- Critical Thinking
- Communication
- Time Management
- Adaptability
- Team Collaboration
- Initiative
- Decision Making
- Analytical Thinking.
Summary of Data Integrity Analyst Knowledge and Qualifications on Resume
1. BS in Data Science with 5 years of Experience
- Excellent written and verbal communication and presentation skills.
- Ability to represent the firm to clients, beneficiaries, and outside advisors in a professional, effective and timely manner
- Good problem-solving skills and attention to detail.
- Problems are technically and operationally varied and require the collection, interpretation and analysis of data from diverse sources.
- Familiarity with SalesForce or other client relationship management software
- Familiarity with Orion or other portfolio management/client reporting systems
- Basic understanding of investments, the various markets and tools used in wealth management
- Ability to handle multiple tasks in a fast-paced environment, and to establish priorities and complete assignments within frequently limited timeframes
- Formulate and present a plan of action consistent with department guidelines to resolve issues within the scope of the job
- Expertise with software applications (i.e. Microsoft Office) in general and, in particular, computerized trust accounting systems, with an emphasis on Excel
- Advanced knowledge of Excel and above-average proficiency with technology
- Critical thinking skills to identify trends within the data and reports and/or suggestions for other potentially relevant operating metrics that can be compiled with the available data
2. BS in Data Analytics with 4 years of Experience
- Certified programming knowledge in machine language scripting, including but not limited to SQL, R, Python and MSFT Excel VBA from acceptable accredited institutions.
- Advanced analytical skills, including demonstrated proficiency with creating, analyzing and updating MSFT Excel (Power) Pivot tables, including Excel-based descriptive statistics, linear programming/optimization and scenario modeling and analysis
- Advanced scripting and visualization skills in operating MFST Word Developer and MSFT PowerPoint.
- Understanding and or working knowledge of FASB topics, including but not limited to ASC-450, 310, 805 and 326 and application to FFIEC call report data.
- Strong analytical skills with the ability to collect, organize, analyze and distribute large amounts of information with a strong attention to detail and accuracy
- Experience with commercial banking in regulated fiduciaries with quality analyzing ((QA)-ing) core instrument data using FFIEC call report schedules (RC-C, RC-E and RC-R).
- Experience with writing report scripts in SQL, IBM Cognos Analytics
- Experience with Microsoft Office power user, including Excel Pivot / Power Pivot and Word Developer
- Experience with either one of Abrigo, Q2 Software, Oracle Financial Services or nCino Analytics and Reporting, including writing advanced SQL report scripts.
- Ability to perform complex core processor database queries and report script generation to obtain relevant data necessary for financial and business analysis;
- Good communication skills and ability to professionally interact at any level of the company;
- Ability to evaluate and understand business processes in order to analyze and understand data flow;
- Experience with Data Visualization development and design preferably utilizing PowerPoint
3. BS in Information Systems with 3 years of Experience
- Experience working in child welfare and/or quality improvement
- Commitment to providing impactful services to participants
- Strong data management skills; understanding and love of data
- Comfort using Excel or other statistical programs to manipulate, analyze and visualize data.
- Enthusiasm for collaboration; friendly and responsive
- Experience managing multiple projects and precise attention to detail
- Ability to synthesize information from multiple sources
- Strong written, verbal, and visual communication skills
- Proficient knowledge of Data visualization and the ability to tell a story of large data sets.
- Experience investigating data issues and working with a cross-functional team for problem resolution.
- Excellent communication skills with a proven track record of communicating with internal and external stakeholders.
- Ability to document work, and issues and communicate standards and requirements.
4. BA in Business Analytics with 4 years of Experience
- Experience developing data or software applications including analysis, design, coding, testing, deploying and supporting of applications
- Experience in Data Warehousing and the use of traditional RDBMS like SQL Server, Oracle, SAP, etc.
- Experience in building an effective and scaleable ETL process
- Experience in integration platforms like SSIS
- Experience in Data Modelling
- Experience with front-end visualization tools like Tableau and/or PowerBI
- Experience with development using tools like GitHub, Azure DevOps, Jira, etc
- Experience with Cloudera Hadoop and/or other big data technologies
- Experience with the Agile mindset
- Experience with Java, Python and/or Scala
- Ability to create clear and detailed technical diagrams and documentation;
- Excellent command of the English language, both written as verbal;
- Experience working in a virtual, global environment
5. BS in Computer Science with 5 years of Experience
- Experience with big data cloud solutions like AWS, Google Cloud, Azure;
- Experience with the big-data eco-systems; Hadoop, Spark, Kafka, Apache Kudu, Shell Scripts, Impala, Hive, Oozie
- Experience in a shared services environment
- Experience in master data or analytics environment with CRM or ERP systems.
- Experience writing IT Business Requirement documentation.
- Expert knowledge of the MS Office Suite
- Knowledge of Excel, with additional data mining program knowledge.
- Routing Continuous Improvement process mapping experience
- Experience with Microsoft Dynamics preferred
- Understands basic Accounting & Finance concepts.
- Displays interpersonal skills with excellent “servant leader” and “can do” mentality.
- Strong written and communication skills
6. BS in Statistics with 4 years of Experience
- Proven data entry work experience
- Experience with MS Office and data programs
- Strong EXCEL skills (able to create formulas, pivot tables, vlookup, formulas, etc)
- Experience working with data in the past
- Computer validation/QA experience in a GMP environment
- Experience with change control as a Quality Assurance approver
- Experience with Trackwise change control software
- Strong experience in working with cross-functional teams
- Proficiency in Python, SQL, SAS, R and Tableau
- Advanced knowledge of Microsoft Excel
- Experience in managing large data sets is also an added advantage
- Strong communication skills, both written and verbal and an ability to speak confidently in front of large groups and/or clients