Senior Data Engineer (Remote)

Position Overview

The primary purpose of a Senior Data Engineer in Production Support is to maintain the seamless operation of data pipelines, databases, and analytics platforms in live environments. This role involves monitoring and troubleshooting data workflows, resolving incidents, and proactively addressing performance bottlenecks to minimize downtime and ensure data availability for end users and business stakeholders.

Key Responsibilities

• Incident Management: Quickly diagnose and resolve data-related issues in production, minimizing impact on business operations.
• Monitoring & Alerting: Implement and maintain monitoring solutions to detect anomalies, failures, or performance degradation in data systems.
• Root Cause Analysis: Investigate recurring problems, identify their root causes, and implement long-term solutions to prevent future incidents.
• Performance Optimization: Analyze data workflows and infrastructure for inefficiencies, tuning systems for optimal performance and scalability.
• Collaboration: Work closely with data engineers, analysts, software developers, and IT teams to ensure seamless integration and deployment of data solutions.
• Documentation & Best Practices: Maintain clear documentation of production environments, issue resolutions, and standard operating procedures.
• Change Management: Participate in planning and execution of system changes, including upgrades, patches, and configuration updates, while minimizing disruption.
• Security & Compliance: Ensure data systems adhere to organizational security policies and regulatory requirements, mitigating vulnerabilities.
• Capacity Planning: Forecast future data storage and processing needs and recommend infrastructure enhancements.
• User Support: Provide technical assistance to end users and business teams, addressing queries and facilitating effective data utilization.
• Automation: Develop and maintain scripts and tools to automate repetitive support tasks, reducing manual intervention.

Required Qualifications

• Bachelor's Degree in Computer Science, Information Technology, Engineering or a related field OR an equivalent combination of education and 4+ years of relevant work experience.
• 5 years of experience with database design, developing modeling tools, and hands-on experience with ETL/ELT script development.
• Experience with Informatica Intelligent Cloud Services (IICS) for cloud-based data integration.
• Knowledge of Apache Kafka and the ability to troubleshoot related issues.
• Hands-on experience with Master Data Management (MDM) SaaS solutions ensuring data consistency and quality.
• Proficiency in GitHub for version control, code collaboration, and managing development workflows.
• Advanced experience with SQL across Snowflake, Oracle, and SQL Server, including performance optimization.
• Expertise in Microsoft Azure services such as Data Factory, Databricks, Synapse Analytics, Blob Storage, and Fabrics.
• Proven experience in developing and maintaining data visualizations and dashboards using Power BI.
• Familiarity with Control-M workload automation for scheduling and monitoring data pipeline jobs.
• Strong proficiency in scripting languages (Python, PowerShell, etc.) to automate data workflows.
• Experience with version control tools such as Git and Azure DevOps for CI/CD pipelines.
• Solid understanding of ETL/ELT processes, data warehousing concepts, and data governance best practices.
• Flexibility to work long hours and on demand, including evenings and weekends as needed.

Benefits & Perks

• Salary Range: 96,048 - 190,762
• Salary Range Disclaimer: The disclosed range estimate has not been adjusted for geographic differentials and considers factors such as role scope, experience, education/training, internal peer equity, and market considerations.
• Comprehensive Benefits Package offered by CareFirst BlueCross BlueShield.
• Various incentive programs/plans.
• 401k Contribution Programs/Plans available (subject to eligibility requirements).