• 5+ years of experience in administering, testing, and implementing enterprise data process automation and orchestration.
• Experience with Data processing platforms and technologies such as Microsoft SSIS, Informatica, ActiveBatch, Power Apps, Apache Airflow, Apache Nifi, Job Schedulers, File transfer tools, etc.
• Knowledge of or experience with data virtualization technology
• Responsible for providing full lifecycle administration of data platform tools (patches/updates, AD security, account management, capacity management, documenting processes)
• Primary platform support would revolve around PowerBI and supporting user security, but also serve as a backup for other department software platforms (Denodo, Informatica, ActiveBatch, etc.)
• Data management & modelling: Connect and manage data pipeline tools to various data sources, including on-premise and cloud-based data sources.
• Implement and maintain semantic models to ensure data integrity and performance optimization. Perform data cleansing and transformation tasks (ETL) to prepare data for analysis.
• Technical support: Provide technical guidance and support to consumers of data services, ensuring effective adoption and utilization of enterprise data and the fabric/virtual layer.
• Performance monitoring: Monitor and optimize Data Pipeline (ETL) performance, including capacity planning and server performance.
• User management: Manage user access and permissions to enterprise data platforms and resources, ensuring compliance with security policies.
• Troubleshooting: Conduct thorough testing, debugging, and troubleshooting of Data Pipleline (ETL) tools and solutions.
• Governance: Maintain governance policies, best practices, and security standards for the enterprise data platforms.
• Training and knowledge sharing: Provide training and share knowledge with colleagues to enable the delivery of data for enterprise needs.
• Roadmap building and prioritization: Support the data architecture team with data pipeline (ETL) roadmap, prioritizing initiatives based on business needs and strategic goals
• Skilled in analyzing and automating manual processes to reduce manual interaction
• Experience with data virtualization/fabric platforms such as Denodo, CData, Talend, Data Virtuality
• Experience with and utilizing development skills such as SQL, PL/SQL, T-SQL, Shell Scripting (Powershell, Unix Shell, etc.)
• Able to analyze, troubleshoot and tune SQL queries and recommend enhancements.
• Analyzing and monitoring server resources and implement proactive alerts and notifications based on SLAs.
• Performance tuning and analysis of SQL code and logic in data transformations and queries.
• Relevant certifications related to data platforms and relevant technologies.
• Experience in the healthcare claims processing industry and understanding of associated data security and privacy concerns.
Work schedule is normal working days ranging from 7am-5pm EST. The position will be required to assist existing staff for a rotating on-call of production support at least 1x/month
The candidate must be 50 miles or 1 commute from a Pulsepoint location
o Indianapolis, IN
o Denison, TX
o Baltimore, MD
o Harrisburg, PA
o Syracuse, NY
o Portland, ME
o Hingham, MA