Job Opportunities API

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, SharePo