Senior Data Engineer/Analyst

Brief Description Improve and maintain the infrastructure for analytics and reporting -- i.e. data warehouses, data lakes, and data pipelines. Lead the design and development of real-time data ingestion projects, collaborating with engineers to deploy API functionality in Snowflake. Create and manage data pipelines using Python and Airflow, automating repetitive tasks to free bandwidth for strategic initiatives. Establish and maintain data governance practices, including version control and separate test and production environments, to ensure data accuracy, security, and compliance. Design and implement comprehensive roadmaps for infrastructure and analytics development to support organizational goals. Collaborate with internal partners and organizations to design and develop reporting solutions and analytic studies that support business needs. Develop, validate, and execute complex queries, and create detailed reports and analyses to answer business questions; interpret results and make recommendations based on findings. Manage data engineering project plans and timelines, ensure project commitments to quality and on-time deliverables. Evaluate data needs for assigned projects, ensure data integrity and suitability, and determine data collection methods, metrics definitions, and evaluation methods. Turn data into actionable information through reporting solutions, present analyses and reports to internal customers and stakeholders. Define and categorize metrics in collaboration with business partners and industry experts to facilitate efficient and accurate reporting. Troubleshoot technical details and issues, ensure seamless operations and data accuracy. Mentor junior analysts by providing guidance on best practices, resolve complex issues, and delegate challenging projects to support their professional growth. Develop productive relationships with vendor partners to identify opportunities to improve and optimize systems and overcome obstacles. Apply statistical methods to data, establish meaningful metrics, and analyze geospatial data to derive location-based business insights. Lead advanced analytics initiatives, incorporate external data sources and develop AI and ML use cases to enhance data-driven decision‑making. Develop AI and ML use cases for NJHIN, exploring innovative solutions to improve healthcare analytics. Build and maintain data pipelines with Astro Airflow. Technical Requirements Perform the foregoing using: SQL, Microsoft T‑SQL, PostgreSQL PL/pgSQL and Snowflake Agile development methods (Scrum, Kanban) and tools (e.g., Atlassian JIRA) HL7 messages Scripting Power BI, Tableau, or a similar BI technology Education and Experience Requirement Requires a Bachelor's degree in Financial Actuarial Mathematics or Related Field and 3 years of experience in the job offered or 3 years of experience in the Related Occupation. Related Occupation Data Analyst or any other job title performing the following job duties: Collaborate with internal partners and organizations to design and develop reporting solutions and analytic studies that support business needs. Develop, validate, and execute complex queries, and create detailed reports and analyses to answer business questions; interpret results and make recommendations based on findings. Evaluate data needs for assigned projects, ensure data integrity and suitability, and determine data collection methods, metrics definitions, and evaluation methods. Turn data into actionable information through reporting solutions, present analyses and reports to internal customers and stakeholders. Define and categorize metrics in collaboration with business partners and industry experts to facilitate efficient and accurate reporting. Troubleshoot technical details and issues, ensure seamless operations and data accuracy. Apply statistical methods to data, establish meaningful metrics, and analyze geospatial data to derive location-based business insights. Perform the foregoing using BI technology. Salary and Benefits In compliance with the NJ Pay Transparency law, the annual salary range for this position is $77,272.00 to $105,000.00 (USD). NJII considers factors like, but not limited to, job scope, experience, education, skills, internal equity, and market conditions when making offers. This pay range covers base pay only and excludes bonuses or other incentives. NJII provides a comprehensive package of benefits to their full‑time employees which includes Medical, Dental, Vision, 401(k) with Employer Match, FSA and HSA. We also provide Company Paid Group Term Life Insurance, AD&D and LTD. In addition, we offer a hybrid work model with an expectation for this role to work a minimum of 2 days weekly onsite at our Newark, NJ office. Final candidates will be subject to a background screening. Employment or continued employment is contingent upon NJII's acceptance of the results of the background screening. #J-18808-Ljbffr