Database Engineer

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: 

 

The Date Engineer plays a critical role in ensuring continuous improvement of the program’s data quality through solutions and strategies to address business challenges and in designing, building and maintaining ETL pipelines to extract data from various sources supporting data integrity and best practices. The Data Engineer will work collaboratively with the product manager, product owners, business owners, and the data and reporting services teams to deliver business value in support of the Centers for Medicare & Medicaid Services (CMS) in detecting and preventing fraud, waste, and abuse within government-sponsored health programs.

Analyze data from a variety of sources, identifying and correcting errors and inconsistencies, and developing and implementing processes to improve data quality.

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.

Design, develop, test and release ETL solutions including data quality validations and metrics that follow data governance and standardization best practices.

Design, build, and maintain ETL pipelines to extract data from various sources, transform it into the desired format, and load it into target systems.

Define and implement data transformation logic to clean, aggregate, and structure data to meet business and analytical requirements. Ensure the quality and consistency of data in the ETL process by implementing data validation checks and handling exceptions.

Analyze and recommend optimal approach for obtaining data from diverse source systems.

Work closely with Database Administrator(s) and assist in supporting the data models, including data dictionaries/metadata registry.

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.

Performing statistical tests on large datasets to determine 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.

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.

Streamlines internal processes focusing on organization support using tools like 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.

Assess/evaluate to deliver timely data reporting, and data solutions against client requirements.

Ensure customer satisfaction through follow-up, client responsiveness, and thorough communication.

Participate in Agile ceremonies, such as sprint planning, daily stand-ups, and retrospectives, to provide input on testing progress and challenges.

 

REQUIRED EXPERIENCE: 

 

4+ years of relevant experience

Possess knowledge of Agile methodology (such as Scrum) and/or Scaled Agile Framework (SAFe).

Relevant experience in developing and maintaining scalable data pipelines and support.

Knowledge of databases (PostgreSQL, Oracle) and data modeling.

2-4 years of experience of data analytics tools (like SQL, R, Python) and data visualization tools (like Tableau, PowerBI, AWS QuickSight).

Able to lead designing and implementation of data pipelines.

Excellent understanding of machine learning techniques and algorithms.

Experience with cloud computing tools such as AWS, Azure, and GCP.

Advanced Excel expertise required including use of pivot tables, formulas, conditional formatting, etc.

Strong analytical mind with problem-solving aptitude.

Experience in automation and scripting.

Ability to communicate complex data in a simple, actionable way.

Excellent organizational and multitasking skills.

Ability to effectively transfer knowledge to other team members.

Ability to work in a fast-paced, deadline-driven environment.

Ability to manage multiple clients and projects/tasks simultaneously.

Must be able to obtain and maintain a Public Trust clearance.

Must have lived in the United States 3 out of the past 5 years.

Candidates must be able to obtain and maintain a Public Trust clearance

Candidates must have lived in the United States 3 out of the past 5 years

PREFERRED EXPERIENCE: 

 

SAFe Agile Certification (preferred)

 CMS experience or knowledge and experience with healthcare IT

 

EDUCATION & CERTIFICATIONS:

Bachelor’s degree

  WHAT WE OFFER: 

At Sparksoft, we know that people do their best work when they feel supported, inspired, and connected. That’s why we’ve built a workplace that balances comprehensive benefits with a culture of collaboration and innovation. From flexible time off to professional growth opportunities, we’re committed to helping you thrive both inside and outside of work. When you join Sparksoft, you’ll enjoy:

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 Sparksoft.Accommodations@sparksoftcorp.com 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 abuse@sparksoftcorp.com.

Artificial Intelligence (AI) Policy: While Sparksoft recognizes the value of artificial intelligence in the workplace, our hiring process is designed to assess each candidate’s individual skills, judgment, and problem-solving abilities. To maintain the integrity of this process, the use of AI tools at any stage of the application or interview is strictly prohibited. Violations of this policy may result in disqualification from consideration.