In-Demand IT Careers

Mulesoft Data Integrations Engineer

Pittsburgh, PA | Fully Remote

Posted: 03/20/2023 Job Category: Database Job Number: 6687

Job Description

As a MuleSoft Data Integration Engineer will be responsible for developing, managing, and maintaining our data architecture, including reporting and visualizations. The MuleSoft Data Integration Engineer will work with our IT team and stakeholders from other business functions to design, develop, and maintain our data architecture, as well as our data warehouse and data mart. The MuleSoft Data Integration Engineer will also be responsible for developing ETL processes to load data into our data warehouse and data mart. The ideal candidate will have experience with data modeling, data warehousing, and ETL development. 

ESSENTIAL DUTIES & RESPONSIBILITIES
  1. Work with Data Architect and Manager of Integration to establish and enforce good development team practices including peer and code reviews.
  2. Work with Data Architect to establish secure coding standards and guidelines for development team that will scale with changes in scope.
  3. Work with Business Analysts to translate requirements and user stories into functioning software.
  4. Troubleshoot and debug software.
  5. Participate in sprint planning, backlog grooming, sprint retrospectives, and sprint demos.
  6. Apply the appropriate standards, secure coding practices, processes, procedures, and tools throughout the software development lifecycle.
  7. Support the Authority to Operate (ATO) process
  8. Mentor developers in software development best practices
  9. Build and maintain efficient data pipelines to and from various applications and databases
  10. Work closely with product and engineering to develop strategy for data ingestion architecture, tools, and processes
  11. Design, implement, test and monitor automated system for ingesting healthcare member, claims and quality data
  12. Create data feeds leveraging healthcare standards such as HL7v2, C-CDA, and FHIR
  13. Construct ETL pipelines for data extracts from HIEs, EMRs, payor databases, and other structured and unstructured sources
  14. Develop and build custom software and integrations for EMR interoperability with hospitals and providers
  15. Automate read, extract, transform, stage and load data processes using state of the art cloud-based tools
  16. Develop, construct, test and maintain data management systems using appropriate tools to perform data ingestion, transformation, cleansing and loading
  17. Integrate up-and-coming data management and software engineering technologies into existing data structures
  18. Implement processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it
  19. Perform data analysis required to troubleshoot data related issues and assist in the resolution of data issues
  20. Filter and cleanse the data to remove errors and ensure consistency and completeness, employ ETL tools and programming skills to write scripts that correct errors through automation
  21. Ensure data is organized and properly stored in database structures to optimize performance and maintain history
  22. Work with the project team to define tasks, create work plans, identify issues affecting progress, and recommend solutions
  23. Communicate variances and potential scope changes in status reports, enumerate project-related expenses and resource constraints and recommend efficiencies

SKILLS & QUALIFICATIONS
  1. Experience supporting Data Warehouse & Data related environments
  2. Experience in working with Web services using Informatica for external vendor data integration
  3. Experience in working with number of XML data sources & API Calls
  4. Solid experience in performance tuning ETL Jobs & Database queries
  5. Advanced AWS & SQL Server database skills including PL/SQL, packages, procedures, indexing and query tuning (3+ years)
  6. Solid understanding of Data Warehouse design theory including dimensional data modeling
  7. Experience in working with Azure DevOps, Jira, TFS (Team Foundation Server) or other similar Agile Project Management tool
  8. Ability to thrive in change by having a fast, flexible, cooperative work style and ability to reprioritize at a moment’s notice

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

WORK WITH US

Get Connected
GET EXPERT INSIGHT
GET RESULTS
GET OUR TEAM WORKING FOR YOU

Whether you are looking to fill or looking to advance your career, I would strongly suggest speaking to Scott and his team at OpenArc. Scott and his team provided a consultative and hands on approach throughout the entire process in my recent transition. Their unique approach was unlike anything I've experienced either as a candidate or a hiring manager.

-Mark Quinn, Service Sales Executive at Siemens Medical Solutions, USA, Inc.

Working with OpenArc was a great experience. The position I accepted was accurately described and my questions on benefits, paid time-off, and holidays and more were promptly answered. The entire OpenArc team was a very professional and to the point. I highly recommended OpenArc to all of my peers.

- Lisa McLaughlin, Executive Director, ACAPT

Take the Next Step