Data Engineer

We are seeking a proactive and detail-oriented Data Engineer to join our team. This role will primarily focus on validating data from various client and payor integration databases with a particular emphasis on correcting data validation errors/issues from the various data integration processes. The ideal candidate will have a strong background in data integration and testing within the healthcare industry, coupled with knowledge to effectively handle integration file formats.

Job Duties and Responsibilities:

• Develop and maintain ETL (Extract, Transform, Load) processes to ensure seamless data integration from various sources into our data warehouse
• Create and optimize complex SQL queries to extract, transform, and aggregate data for reporting and analytics purposes.
• Leverage Python and R for data cleaning, manipulation, and statistical analysis.
• Collaborate with cross-functional teams to understand data requirements and implement automated data pipelines.
• Ensure data quality and accuracy by implementing validation checks and error handling mechanisms.
• Utilize Google BigQuery for scalable data analysis and transformation.
• Implement forecasting models such as ARIMA and Prophet for predictive analytics.
• Automate and orchestrate ETL processes using PowerShell, scripts, and other technologies.
• Integrate Tableau with external data sources and APIs to create dynamic, real-time dashboards.
• Prioritize project tasks and handle scope changes while ensuring projects meet deadlines and business objectives.
• Collaborate closely with stakeholders, including data analysts, business leaders, and IT teams, to align project goals with business needs.
• Lead project teams, allocate resources, and track project progress using project management tools and methodologies.
• Maintain clear documentation of project plans, milestones, and outcomes to ensure effective communication and reporting.
• Other duties as assigned

Requirements

• Develop and maintain ETL (Extract, Transform, Load) processes to ensure seamless data integration from various sources into our data warehouse.
• Create and optimize complex SQL queries to extract, transform, and aggregate data for reporting and analytics purposes.
• Leverage Python and R for data cleaning, manipulation, and statistical analysis.
• Collaborate with cross-functional teams to understand data requirements and implement automated data pipelines.
• Ensure data quality and accuracy by implementing validation checks and error handling mechanisms.
• Utilize Google BigQuery for scalable data analysis and transformation.
• Implement forecasting models such as ARIMA and Prophet for predictive analytics.
• Automate and orchestrate ETL processes using PowerShell, scripts, and other technologies.
• Integrate Tableau with external data sources and APIs to create dynamic, real-time dashboards.
• Prioritize project tasks and handle scope changes while ensuring projects meet deadlines and business objectives.
• Collaborate closely with stakeholders, including data analysts, business leaders, and IT teams, to align project goals with business needs.
• Lead project teams, allocate resources, and track project progress using project management tools and methodologies.
• Maintain clear documentation of project plans, milestones, and outcomes to ensure effective communication and reporting.
• Knowledge of laws that regulates communication and privacy act. HIPAA laws and understanding of the application of all above
• Excellent communication and negotiation skills.

• Detail-oriented with strong organizational abilities.
• Ability to work independently and collaboratively within a team environment.
• Proficiency in Microsoft Office Suite and relevant software applications.