Data Quality Analyst II

OpenKrill; United States; Hybrid; USD 85,000 - 120,000; Full time

Benefits offered by this job

401(k) with employer contributions

Flexible paid time off

Health coverage (medical, dental, VDit

Professional development

Job summary

Sparksoft is seeking a senior data analyst to analyze structured and unstructured data from multiple sources, ensuring data accuracy and reliability across APS data. You will leverage SQL, Python, and Excel to cleanse, validate, and transform data, while presenting insights to business leaders.

The role requires collaboration with cross-functional teams, adherence to data governance standards, and experience with BI tools like Tableau, Power BI, and AWS QuickSight.

Qualifications

• Bachelor's degree in a data-focused or related field.
• 5+ years of data analytics experience.
• Experience with agile methodologies (SAFe, Scrum) and tools (Jira, Confluence).
• Excellent communication and collaborative team skills.
• Ability to thrive in a fast-paced, deadline-driven environment.
• Must be able to obtain and maintain Public Trust clearance.

Responsibilities

• Analyze structured and unstructured data to identify errors and improve data reliability.
• Ensure accuracy and completeness of APS data.
• Work with diverse data types using various analysis tools and techniques.
• Develop and implement data quality policies, procedures, and standards.
• Document processes, prepare reports, and suggest improvements.
• Develop scripts and dashboards to monitor data flow quality.

Skills

Advanced Excel

SQL

Python

R

Tableau

Power BI

AWS QuickSight

Data governance

Data cleansing

Jira

Confluence

GitHub

PostgreSQL

Oracle

Education

Bachelor's degree in Computer Science, Information Technology, Math, Data Analytics, or related field

Tools

Tableau

Power BI

Excel

Jira

Confluence

GitHub

SQL

Python

R

AWS QuickSight

Job description

Join us at Sparksoft, where we're not just another tech company—we're a catalyst for change. Our mission isn't just to offer IT solutions; it's to revolutionize the way you work. Here, passion isn't just a buzzword; it's the fuel behind groundbreaking ideas and transformative technologies. We serve a wide range of government clients, delivering impact that's felt across the nation.

Our true strength lies in our people. They're the problem-solvers and innovators consistently delivering extraordinary outcomes. With Sparksoft, you're not stepping into a routine job; you're joining a team committed to innovation and excellence. Our innovation extends beyond just delivering projects. Through our specialized Innovation Centers, we continuously refine our methods, ensuring we remain industry leaders.

We are Sparksoft!

ROLE & RESPONSIBILITIES:

• Analyze structured and unstructured data from multiple sources to identify errors and inconsistencies, correct data issues, and implement processes that improve data accuracy, completeness, and reliability.
• Ensure the accuracy, completeness, and reliability of APS data.
• Work with a range of data types, including structured and unstructured data, and use a variety of tools and techniques to analyze and improve data quality.
• Use tools and techniques such as statistical analysis, data cleansing and transformation tools, and data governance frameworks.
• Develop and implement data quality policies, procedures, and standards.
• Document processes, prepare reports, and make recommendations for process improvements.
• Develop new processes and procedures to enhance operations.
• Collaborate with other teams to implement changes or updates in the existing reports.
• Advanced Excel expertise required including use of pivot tables, formulas, conditional formatting, etc.
• Present responses and findings to business owners, customers, leadership.
• Provide support in ad-hoc analysis to meet customer needs.
• Perform statistical tests on large datasets to assess data quality and integrity.
• Collaborate with internal team to improve data collection and storage processes.
• Analyze and identify data quality issues, develop methods to address data quality problems.
• Advanced Excel expertise required including use of pivot tables, formulas, conditional formatting, etc.
• Review and understand artifacts related to data ingestion and transformation as it applies to data validation and analysis.
• Provide quality assurance reports using tools like Excel, SharePoint, Power BI, and Tableau.
• Streamline internal processes and strengthen organizational support using Excel, SharePoint, Power BI, and Tableau.
• Performs ad hoc data analysis to support programmatic questions and stakeholder requests.
• Works as part of a project team to determine project requirements, goals, implementation, and schedules.
• Develop scripts and dashboards to monitor the accuracy and quality of data flow.
• Maintain data accuracy and quality checks by monitoring/reviewing the dashboards and reports regularly.
• Provide training for internal users and customer stakeholders.
• Provide technical leadership within the data analytics team and mentor junior team members.
• Peer review of team members’ work outputs for quality assurance.
• Experience with data analytics tools (SQL, R, Python) and data visualization tools (like Tableau, PowerBI, AWS Quicksight).
• Knowledge of databases (PostgreSQL, Oracle) and data modeling.
• Assess/evaluate to deliver timely data reporting, and data solutions against client requirements.
• Ensure customer satisfaction through follow-up, client responsiveness, and thorough communication.
• Ability to manage multiple clients and projects/tasks simultaneously.
• Participate in Agile ceremonies, such as sprint planning, daily stand-ups, and retrospectives, to provide input on testing progress and challenges.
• Technical Competencies: Advanced Excel skills, including pivot tables, formulas, and conditional formatting; proficiency with SQL, R, or Python; experience with Tab.

REQUIRED EXPEREINCE:

• Bachelor’s degree or higher in Computer Science, Information Technology, Math, Data Analytics, or related field.
• 5+ years of experience in a data analytics role.
• Experience with agile methodologies (SAFe, Scrum) and tools (Jira, Confluence).
• Excellent communication skills and ability to work collaboratively in a team
• environment.
• Strong problem-solving skills and a proactive approach to identifying and
• addressing issues.
• Ability to work effectively in a fast-paced, agile environment and deadline-driven
• environment.
• Must be able to obtain and maintain a Public Trust clearance.
• Must have lived in the United States 3 out of the past 5 year

PREFERRED EXPEREINCE:

• SAFe Agile Certification
• Experience with the version control systems (GitHub)
• Experience in healthcare IT and understanding of regulatory requirements such asHIPAA.
• Experience and/or knowledge of CMS processes and standards

EDUCATION & CERTIFICATIONS:

• Bachelor's or Master's degree in a data-focused or mathematics-related field

WHAT WE OFFER:

• Competitive compensation and a 401(k) with employer contributions to help you plan for the future
• Flexible paid time off and hybrid ways of working that support true work-life balance
• Comprehensive health coverage—including medical, dental, vision, life, and disability insurance
• A curated in-office experience designed to foster community, team connections, and innovation
• Opportunities to give back through Sparksoft Cares, including annual company-wide fundraising events
• Training and development programs that build new skills and prepare you for leadership roles
• A collaborative, transparent, and fun culture—recognized as a Great Place to Work

Accessibility and Accommodations: Sparksoft Corporation is committed to providing equal employment opportunities to all individuals. If you require accommodations during the application or interview process, please contact us at [e-mail] or call 410-424-7700. Requests are reviewed and fulfilled on a case-by-case basis.

Security Notice: Your privacy and data security are important to us. Sparksoft Corporation will never request sensitive personal information via email. If you receive any suspicious communication claiming to be from Sparksoft, please report it immediately to our security team at [e-mail].

Artificial Intelligence (AI) Policy: While Sparksoft values the appropriate use of artificial intelligence in the workplace, candidates must complete interviews and independent assessments using their own knowledge and abilities. Unless expressly permitted by Sparksoft, the use of AI during interviews and assessments is strictly prohibited. Violations