Data Quality Analyst/Scrubbing Data/Cleaning Data with SQL - Philadelphia, PA
Apply NowCompany: Georgia IT, Inc.
Location: Philadelphia, PA 19120
Description:
Job Title: Data Quality Analyst/Scrubbing Data/Cleaning Data with SQL
Location: Philadelphia, PA
Position Type: Contract
Work Status: US Citizen/Green Card/GC-EAD
Interview Process: Phone, then Face to Face
Rate: DOE (W2 Only)
Main responsibilities will be:
Knowledge and Skills
Experience
Qualifications
Bachelor's degree required with related experience, or an equivalent combination of education and experience from which comparable knowledge and abilities can be acquired. Ability to analyze complex data, business processes, and information flow needs. Must have excellent communication skills with the ability to drive data quality concepts and solutions.
Location: Philadelphia, PA
Position Type: Contract
Work Status: US Citizen/Green Card/GC-EAD
Interview Process: Phone, then Face to Face
Rate: DOE (W2 Only)
Main responsibilities will be:
- Data Profiling Profile files and databases, identify business rules and requirements for ingestion and processing of data
- Analysis
- Identify and define validation and monitoring logic to ensure that data anomalies are detected and contained within thresholds
- Identify patterns, trends and inconsistencies; draw conclusions and provide recommendations in the form of remediation, corrective (CARs) and preventative (PAR) actions.
- Stakeholder Engagement capture business rules and filtering unique to data use and business decision making
- Technical Writing requirements, event summaries and recommendations (etc.)
- Process Modeling
Knowledge and Skills
- Profiling
- Ability to design and implement data quality metrics
- Scorecards
- Dashboards
- Thresholds
- Knowledge of tools to query and manipulate data in varying file formats
- Knowledge of referential and large data formats and file structures
- Ability to apply the principles of data quality standards
- Knowledge of databases, included big data technologies
- Knowledge of programming and software development lifecycle (SDLC)
- Convey complex technical issues/problems to programmers in a clear/concise manner
- Ability to convey complex concepts to business stakeholders in terms relevant to the business
- Excellent written and verbal communications skills
- Excellent data analysis skill
- Organized, structured, methodical
- Analytical with strong problem solving ability
- Strong prioritization and time management skills
- BPMN 2.0 experience is a plus
- FMEA (Failure Modes and Effects Analysis) experience is a plus
- Six Sigma Green Belt is a plus
Experience
- 6+ years of relevant employment experience
- 6+ years writing technical requirements and business logic
- 3+ years process documentation and depicting data lineage
- 3+ years experience interpreting data models, data dictionaries and queries
- Ability to write moderately complex SQL queries, PL/SQL a plus
- Knowledge of account, device, service, operations and marketing domains
- Exposure to the following a plus: Hortonworks, Hadoop, Teradata
- Exposure to the following a plus: SAS, Informatica, Tableau, Metric Insights
Qualifications
Bachelor's degree required with related experience, or an equivalent combination of education and experience from which comparable knowledge and abilities can be acquired. Ability to analyze complex data, business processes, and information flow needs. Must have excellent communication skills with the ability to drive data quality concepts and solutions.