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.
•
Last updated on Aug 8, 2024