Data Engineer

• Build and maintain ETL pipelines to support the generation of the DAP/PMAS report.
• Ensure accurate integration of Medicaid Personal Care Services data within the data hub.
• Collaborate with stakeholders to define report specifications and validate report outputs.
• Set up and configure infrastructure components required for data integration, including servers, databases, and middleware.
• Ensure the scalability, security, and reliability of the data integration hub infrastructure.
• Maintain alignment with enterprise architecture standards and security protocols.
• Design, Development, and Implementation (DD&I) of Data Integration Hub.
• Participate actively in planning, development, testing, and deployment phases of the project lifecycle while adhering to agile practices.
• Interpret business goals into actionable performance metrics and ensure design alignment with performance targets.
• Conduct rigorous testing to confirm system capacity meets end-user needs.
• Work collaboratively with agile teams to deconstruct project requirements into detailed user stories and tasks.
• Ensure epics and user stories are prioritized and deliver value incrementally throughout sprints.
• Develop robust automated pipelines to acquire data from diverse sources, ensuring accuracy, timeliness, and completeness.
• Leverage tools such as Informatica PowerCenter/IICS to streamline and automate ETL processes.
• Write advanced SQL scripts to implement data transformations and ensure compatibility with dimensional data models.
• Optimize SQL queries for performance and functionality in Oracle environments.
• Conduct integration testing to ensure the seamless functionality of varied components.
• Perform load and stress testing to validate system performance under high-volume and peak-load conditions.
• Oversee the deployment of data pipelines, infrastructure, and reporting services for both internal and external audiences.
• Ensure the publishing of data and reports complies with organizational standards and accessibility requirements.
• Serve as a technical leader within the agile team, guiding and mentoring team members through development cycles.
• Actively participate in sprint planning, daily stand-ups, sprint reviews, and sprint retrospectives.
• Provide input on backlog grooming and sprint goal alignment with organizational objectives.
• Acquire data from a variety of sources and apply advanced transformations to structure data for analytical use cases.
• Collaborate on strategies for large-scale data acquisition and integration into the dimensional data model.
• Partner with the Data Engineering and Architecture teams to implement optimal data designs, ensuring scalability and flexibility.
• Design automated verification and validation processes for SQL scripts, ETL pipelines, and database views.
• Ensure data integrity through operational checks and quality assurance practices.
• Collaborate closely with team members and stakeholders to tackle technical challenges and deliver timely solutions.
• Escalate critical issues to leadership with actionable recommendations for resolution.
• Collaborate with operations teams to ensure smooth functioning and uptime of the infrastructure.
• Recommend improvements and enhancements to the data integration hub based on trending requirements, metrics, and user feedback.
• Innovate by staying up-to-date on new technologies, proposing their adoption where they align with organizational goals.
• Create comprehensive technical documentation, including specifications, diagrams, and design artifacts, to support implementation and maintenance.
• Participate in sessions to derive detailed requirements and contribute to system design decisions, ensuring alignment between business needs and technical capabilities.
• Interpret new or evolving business requirements, assess their impact, and design corresponding enhancements or changes to current systems.

Data Engineer

Data Engineer

Senior Data Engineer