Skip to main content
Technology Mast

Senior Data Warehouse Engineer

EPG Insurance, an Assurant company stands out in the Equipment and Truck Industries as an Industry Leader and premier partner. EPG’s mission is simple: Keep equipment and trucking companies healthy and profitable while protecting their assets. We do this every day by providing advanced solutions in the simplest, most convenient way possible with the best customer service in the industry.

The Senior Data Warehouse Engineer is responsible building data architecture for consumption of data, flow of data from multiple applications to one data warehouse, set security and end points for pieces of data, oversight of SQL management on the reporting node running Microsoft SQL Server to manage all data for reporting, oversight of Power BI reporting tools used by both EPG and Carriers, SSRS for maintaining traditional Paginated Reports used for legacy applications. This is a primarily remote position, but the ideal candidate will be local to Memphis TN.

Responsibilities:

  • Translating business requirements into technical specifications, including data streams, integrations, transformations, databases, and data warehouses
  • Define Data architecture with regards to
    • Vendors
    • Clients
    • Employees
  • Evaluate and manipulate data as required to Build and Design innovative company visualizations
  • Manage the whole Power BI Stack for EPG’s Customers/Employees
    • Develop Complex reports as requirements arise
    • Power BI Tool Security and Administration
    • Set User Access
    • BI tool Upgrades and Patches
    • Audit Reports and Usage
    • Troubleshoot report/access issues
    • Identify and share value add reporting techniques
    • Maintain, support, and enhance the BI data backend, including data warehouses
  • Collaborate with team members working to improve the user experience with existing reports
  • Design, code, test, and aggregate results from SQL queries to provide information to users

Basic Qualifications:

  • 5+ Years’ experience with:
    • SQL Server
      • Data Modeling
      • Database design
      • Database tuning/performance management
    • Data Cubes
    • Data Warehousing
    • Report Server (SSRS)
    • Integration Services (SSIS)
  • 5+ Years’ experience with the following:
    • Power BI
      • Dashboards
      • Reports
      • Visualizations/Data Charts/Graphs
      • Data Models
      • Data Permissions
      • Data Governance
      • Data Quality
      • 1 source of truth
    • DTS
      • Data transformation tools to create quality data feeds to our customers and colleagues

Preferred Qualifications:

  • TSQL
  • DAX
  • Power Query
  • 5+ Years’ experience with ESPP and PD in the Heavy-Duty Equipment ESPP/PD Insurance Industry:
    • Production
    • Claims
    • Earnings
    • Loss Ratio
  • Bachelor of Science in Computer Science

Join our talent community

Get discovered. Introduce yourself, and we'll get in touch if there's a role that seems like a good match.

Join Now