Database Engineer

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