Informatica Cloud Developer (Snowflake) REMOTE

At MultiPlan, we pride ourselves on being a dynamic team of innovative professionals. Our purpose is simple - we strive to bend the cost curve in healthcare for all. Our dedication to service excellence extends to all of our stakeholders - internal and external - driving us to consistently exceed expectations. We are intentionally bold, we foster innovation, we nurture accountability, we champion diversity, and empower each other to illuminate our collective potential.

Be part of our amazing transformational journey as we optimize the opportunity towards becoming a leading technology, data, and innovation voice in healthcare. Onward and upward!!!

JOB DESCRIPTION

As part of Data Engineering team, Informatica Developer will be part of the Data Management team responsible for developing and deploying Engineering and Integration solutions. Primary responsibility will be to work closely with the Data Architects and Machine Learning Team to implement data solutions for the organization using big data and cloud technologies, creating technical specification documents and test plans. Also provide support for the data solutions across the enterprise.

JOB ROLES AND RESPONSIBILITIES:

• Understand business processes and how they are modeled in various systems
• Work with business users, technology teams to understand their data needs to create innovative solutions to fulfil them
• Design, organize, and implement data structures, workflows, and integrations between enterprise platforms to ensure the accurate and timely execution of business processes.
• Develop and maintain scalable data pipelines and build out new API integrations to support continuing increases in data volume and complexity.
• Guiding decisions and establishing best practices on data integration/engineering, as well as the future of our data infrastructure
• Managing and improving the performance of our database, queries, tools, and solutions
• Creating and maintaining data warehouse, databases, tables, SQL queries, and ingestion pipelines to power reports(Tableau), dashboards, predictive models, and downstream analysis
• Writing complex and efficient queries to transform raw data sources into easily accessible models for our teams and reporting platforms
• Prepare data for predictive and prescriptive modeling
• Identify and analyze data patterns
• Identify ways to improve data reliability, efficiency and quality
• Work with analytics, data science, and wider engineering teams to help with automating data analysis and visualization needs, advise on transformation processes to populate data models, and explore ways to design and develop data infrastructure

JOB REQUIREMENTS (Education, Experience, and Training):

• 3+ years of data engineering experience. 2 years of it MUST be with Informatica (IICS/IDMC, Power Center) experience.
• Must have experience with Snowflake warehouse and developing on Snowflake, SnowSQL, Snowpipe, & Stored procedures.
• Database development experience using SQL, PL/SQL and SnowSQL and experience with a variety of relational, NoSQL oriented databases like Hadoop, MongoDB is highly preferred!
• Exposed to advanced analytics tools, Spark, and Python. Other big data technologies preferred.
• Strong experience in data curation/aggregation/preparation using Azure Data lake, Azure Data Factory, DBT and distilling data into meaningful insights with hands-on expertise on Azure and Snowflake/Databricks is highly preferred!
• Experience in triaging data issues, analyzing end-to-end data pipelines and working with business users in resolving issues.
• Experience in working with data governance/data quality and data security teams and specifically data stewards and security officers in moving data pipelines into production with appropriate data quality, governance and security standards and certification.
• Exposure to containerization using Docker, Kubernetes etc.
• Adept in agile methodologies and capable of applying DevOps and increasingly DataOps principles to data pipelines.
• Ability to work with both IT and business in integrating analytics and data science output into business processes and workflows.
• Minimum Bachelor's degree in computer science, information technology, or a similarly relevant field.

COMPENSATION

The salary range for this position is $120K to $125K. Specific offers take into account a candidate's education, experience and skills, as well as the candidate's work location and internal equity. This position is also eligible for health insurance, 401k and bonus opportunity.

BENEFITS

We realize that our employees are instrumental to our success, and we reward them accordingly with very competitive compensation and benefits packages, an incentive bonus program, as well as recognition and awards programs. Our work environment is friendly and supportive, and we offer flexible schedules whenever possible, as well as a wide range of live and web-based professional development and educational programs to prepare you for advancement opportunities.

Your benefits will include:

• Medical, dental and vision coverage with low deductible & copay
• Life insurance
• Short and long-term disability
• 401(k) + match
• Generous Paid Time Off
• Paid company holidays
• Paid parental leave
• Tuition reimbursement
• Flexible Spending Account
• Employee Assistance Program
• Summer Hours

EEO STATEMENT

MultiPlan is an Equal Opportunity Employer and complies with all applicable laws and regulations. Qualified applicants will receive consideration for employment without regard to age, race, color, religion, gender, sexual orientation, gender identity, national origin, disability or protected veteran status. If you would like more information on your EEO rights under the law, please [Link available when viewing the job].