Data Engineer (Python & Sql)

The EDI (Enterprise Data Intelligence) team is a data warehousing team. We cater to various internal teams to provide analytics for key decision making in the organization. We use the following technologies to provide these benefits to our stakeholders - Python, YAML, Json, SQL, Git, Azure Data Factory, Databricks, HPCC, Essbase/OCI and Power BI. The EDI Data Operations Guild takes on the responsibility of managing and upkeeping the data infrastructure and processes within the EDI team. Our main objective revolves around ensuring that our data assets remain available, integral, and secure. The team supports the developers and stakeholders and is responsible for the operations and maintenance of all things in the EDI team.  Qualifications:
Bachelor's degree in computer science or related field or higher. Intermediate Office skills (Excel spreadsheets, PowerPoint presentations, Visio/Gliffy diagrams. At least 3 to 4 years of experience in database technologies including Microsoft SQL Server , to write medium complexity queries to understand logs. Strong primary expertise in  Python language , including yaml, Json and XML parsing and using pandas. Knowledge about Power BI and Essbase – to be able to add new users, data connections or debug any issues. Bonus: any knowledge on Fabric.  Good communication skills, to be able to convey errors in pipelines and resolutions to our developers and stakeholders Accountabilities:
Establish relationships with all internal groups, so that our developers are proactively aware of any data issues.  Make sure all data pipelines are run as expected every day.  Identify and implement solutions to improve the quality of all data pipelines.  Coordinate with stakeholders and developers in LNRS to define and prioritize work, so that our users and stakeholders are aware of all data issues, remediation and delays in services.  Respond with urgency to both internal and external inquiries.  Create requirement documents and markups for developers to code future automated pipelines and data tables.  Ensure assigned projects are completed within schedules while meeting business objectives.  Perform system administration for multiple windows machines – disk clean up, patches, installing new software, and remediating vulnerabilities.  To provide accurate administrative, data and operational support to our Insurance, Finance, Business Services and Core Systems stakeholders and developers.  To understand the entire life cycle of the data that is being processed in the team.  To improve processes within the team to reduce system down times, improve communication with all stakeholders, and to remediate any issues immediately.