Data Engineer

Company: Covenant Living Communities
Location: Skokie
Posted on: November 25, 2022

Job Description:

We Are Inspired to Serve. Join us!The Central Office (Skokie, IL) of a nation wide family of Continuing Care Retirement Communities is seeking a Data Engineer. The Data Engineer role is responsible for the performance, integrity and security of the database(s). This includes being involved in the planning and development of the database, as well as troubleshooting any issues on behalf of the users. This position also performs a key function in the business with developing, maintaining and enhancing our Business Intelligence Dashboards and reporting.In this role, the Data Engineer will:

• Install, configure and monitor SQL enterprise servers
• Work with Business stakeholders to generate insights and present these findings in visually rich dashboards
• Translate business requests and KPIs into relevant data sources to be able to adequately build and design reports.
• Maintain regular touchpoints with business stakeholders to ensure existing reports and dashboards are functioning and meeting the business needs
• Manage database clusters and failover scenarios
• SQL server performance analysis and tuning using diagnostic tools
• SQL server job automation using SQL agents
• Backup and recovery of large databases
• Disaster recovery and business continuity planning
• Database administration in virtual environments like VMWare
• SQL Data warehouse performance tuning
• SQL index design and tuning
• PowerShell scripting experience
• Maintain and customize dashboards in Power BI
• Review and implement application API integrations to add additional sources to the datasetThe ideal candidate will have:4 to 5 years of Database Administration experience
  • Expertise in Microsoft SQL Server.
  • Excellent communication skills - ability to understand the requirements and implement or present the story in a meaningful way
  • Good program management and change management skills - ability to work in very agile environment with quick turnaround
  • Experience with scripting in Python is a plus
  • Experience with Varigance BimlFlex data vaulting is a plus
  • Experience with data visualization in excel and PowerPivot a plusFor full time employees, we offer a generous benefits package that includes:
    • Medical, dental and vision insurance
    • Employer paid group term life and disability
    • Paid Time Off (PTO) & six paid holidays
    • 403(b) with a 3% employer match
    • Fitness center use at most facilities.
    • Various voluntary benefits:
      • Life, AD&D
      • Tuition assistance and scholarships
      • Employee assistance program
      • Legal services, home/auto insurance, discount purchasing program
      • Pet InsuranceFor more information about Covenant Living and CovenantCare at Home, please visit www.covliving.org or www.covenantcareathome.org.Covenant Living and CovenantCare at Homeare equal opportunity employers. All qualified applicants will receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity or expression, religion, national origin or ancestry, age, disability, marital status, pregnancy, protected veteran status, protected genetic information, or any other characteristics protected by local laws, regulations, or ordinances.

Keywords: Covenant Living Communities, Skokie , Data Engineer, Engineering , Skokie, Illinois