Professional, Data Engineer

MVP Health Care • Schenectady, NY

12d • $93,667 - $124,577

About The Position

The Data Engineer plays a critical role in ensuring the quality, reliability, and security of data systems hosted in on premise and cloud environments. Your expertise will contribute to the success of data-driven initiatives by validating data pipelines, identifying defects, and ensuring compliance with business requirements implements, and maintains an automation framework around improving data quality and increasing delivery throughput. This role includes collaboration with both technical and business teams to evaluate requirements and provide guidance to solutions that are scalable and maintainable. This role requires the ability to share technical expertise and solutioning to users throughout the organization, mentor other members of the data engineering team, stay current with emerging trends, and to document processes and solutions to facilitate knowledge transfer and the building of team bench strength. Validate a variety of data movement and delivery artifacts within the Extract, Transform, and Load (ETL) and data streaming spaces, including collaboration on performance and stabilization of said processes. Create and maintain supporting documentation and guiderails around data quality in collaboration with enterprise data governance needs. Document data engineering workflows, data models, and ensure alignment with data engineering best practices. The Data Engineer interfaces with Senior Data Engineers. analysts, business customers (internal or external) to gather and define requirements for solutions. Learns data resources and knows when, how, and which to use and which not to use. Continually improves ongoing team processes, automating where needed, and providing self-service solutions when applicable. Documents mission critical enterprise ETL tasks. Presents complex information in an understandable manner. Develops, modifies, or proposes datasets necessary to meet reporting and analytics needs. Performs other duties as assigned.

Requirements

• Technical degree (Bachelor of Science, Computer Science, or equivalent level of experience) required
• Minimum 3 years’ experience with direct data analysis and data management, preferable in a health care environment.
• 3+ years’ relevant experience in data warehousing techniques and technology, or experience in data vaults (raw and business), medallion architecture, and /or comparable analytics solutions.
• 1-3 years’ experience using Azure Databricks
• 1-3 years’ experience with at least one programming language (preferably MS SQL, Python)
• Experience in data mining, ETL, etc. and using databases in business environment with medium scale, complex datasets.
• Advanced knowledge with OLAP.
• Superior analytical and problem-solving skills, with excellent attention to detail.
• Advanced ability to understand business drivers.
• Capacity to develop procedures that support task management, data structure, dependence and metadata.
• Advanced ability to recognize innovative solutions.
• Experienced in a variety of analysis techniques to define problem/ opportunity and to discover unstated requirements.
• Advanced ability to challenge status quo by looking for a better way to solve a problem with the ability to influence others in this regard.
• Dimensional, star schema modeling skills.
• Top notch communication (verbal and written) and interpersonal skills to convey key insights from complex analysis in summarized business terms and an ability to effectively communicate with business unit representation and analysts.
• Exceptional customer focus with advanced ability to build relationships with business and technical partners to improve customer service and continuously improve project delivery.
• Highly self-motivated and directed, can direct others.
• Experience working in team-oriented, collaborative environment.
• Advanced organization, planning and time management skills.

Nice To Haves

• Advanced degree (MS) a plus.
• Certification as Microsoft Product Specialist in SQL Server desired but not required.
• Additional experience using data engineering/reporting tools like (SSRS, SSAS, SSMS, SSIS, Tableau, Power BI, Informatica) preferred
• Experience in developing dashboards and scorecards.
• Knowledge of healthcare claims processing systems (Facets system knowledge preferred).
• Knowledge of health care and health care delivery systems.
• Medical Terminology knowledge, highly preferred.
• Understanding of automation and scripting frameworks
• Experience with Cloud Based Data Solutions such as Azure Data Lakes and Azure Data Bricks platform.

Responsibilities

• Validate a variety of data movement and delivery artifacts within the Extract, Transform, and Load (ETL) and data streaming spaces, including collaboration on performance and stabilization of said processes.
• Create and maintain supporting documentation and guiderails around data quality in collaboration with enterprise data governance needs.
• Document data engineering workflows, data models, and ensure alignment with data engineering best practices.
• Interface with Senior Data Engineers, analysts, business customers (internal or external) to gather and define requirements for solutions.
• Learn data resources and know when, how, and which to use and which not to use.
• Continually improve ongoing team processes, automating where needed, and providing self-service solutions when applicable.
• Document mission critical enterprise ETL tasks.
• Present complex information in an understandable manner.
• Develop, modify, or propose datasets necessary to meet reporting and analytics needs.
• Perform other duties as assigned.

Benefits

• Growth opportunities to uplevel your career
• A people-centric culture embracing and celebrating diverse perspectives, backgrounds, and experiences within our team
• Competitive compensation and comprehensive benefits focused on well-being
• An opportunity to shape the future of health care by joining a team recognized as a Best Place to Work For in the NY Capital District, one of the Best Companies to Work For in New York, and an Inclusive Workplace.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree