Westchester Medical Center - Valhalla, NY
posted 3 months ago
As an Analytics Engineer within the Operational Excellence & Enterprise Analytics Department, you will play a crucial role in expanding and optimizing our network enterprise data warehouse. This position is designed to enable our organization to make informed, data-driven decisions and improvements across various domains. The ideal candidate will possess strong skills as a data pipeline developer and data wrangler, with a passion for optimizing data systems and building them from the ground up. You will be expected to be self-directed and comfortable supporting the data needs of multiple teams and systems, both in clinical and non-clinical domains. The right candidate will be excited by the prospect of optimizing or even redesigning our company's data architecture to facilitate data-driven decision-making for strategic, operational, and clinical purposes. In this role, you will be responsible for building the infrastructure required for optimal extraction, loading, and transformation (ELT) of data into our enterprise data warehouse (EDW) from a wide variety of data sources using SQL and cloud data warehousing technologies such as Azure, AWS, and Snowflake. You will create and maintain optimal data pipeline ingestion architecture for various unstructured and structured data sources. A strong business process acumen is essential, as you will need to understand how specific clinical or non-clinical business processes generate data. With a comprehensive understanding of our operational processes, you will develop the transformation logic necessary to establish structured and analytical data repositories across various domains. Utilizing data orchestration and scheduling techniques, you will combine and organize siloed data from multiple storage locations, making it available for data analysis tools and enabling automation. You will also develop and maintain front-end analytics tools and dashboards using Tableau or Power BI, providing actionable insights into operational performance and other key business performance metrics. Implementing sound data cataloging and analytics development best practices will be crucial in creating organized inventories and source control that aid in data governance. Ensuring data quality and governance at the enterprise level will involve utilizing data lineage techniques and adhering to standard data documentation practices. Collaboration with stakeholders, including executive leadership, operations management, and data and design teams, will be essential to assist with data-related technical issues and support their data infrastructure needs. You will ensure that internal and external data security standards are maintained to safeguard our enterprise and patient data. Additionally, you will provide recommendations to enhance our data engineering techniques and architecture design, creating data tools and collaborating with management engineering, analytics, and data scientist team members to assist them in building and optimizing various analytics solutions. Your agile skills will draw from other disciplines such as management consulting, business administration, organizational development, information technology, and computer science.