What are the responsibilities and job description for the Sr Data Warehouse Engineer position at Assurant?
The Senior Data Warehousing Engineer will leverage their ETL, SQL, and backend development expertise to extract and model data from various sources, including RDBMS, NoSQL databases, and from APIs within a complex and heterogeneous solution environment. They will create data warehouses for production, dashboard, and ad hoc reports, and will also help build and support these reporting assets.
This role will be onsite at our Irving, TX location (just north of DFW airport), 5 days per week. Not a remote or hybrid role.
What will be my duties and responsibilities in this job?
- Learn and remain current on all functional aspects of digital solutions that impact data for operational reporting, including but not limited to repositories containing data from : ERP, Warehouse Management System, automation systems, middleware components, HRIS, and associated transactional logging
- Develop hands-on familiarity with processes in a reverse logistics warehouse environment to inform the understanding of underlying data
- Develop, document, and socialize requirements for all data warehousing deliverables, including the data flow diagrams and data models
- Work with data analytics developers to ensure that all required data is available to satisfy client / internal reporting requirements
- Use ETL processes and tools to extract data from internal RDBMS resources (Oracle and SQL Server) and model them into high-performance SQL Server data warehouse resources
- Use ETL tools and / or backend coding (Python or .NET) to draw from NoSQL resources and integrate with RESTful APIs to retrieve data for same
- Develop logic to monitor for systemic anomalies and exceptions and real-time alerts for business and product owners
- Provide end-to-end visibility for individual assets across all integration layers in a single reporting context / interface
- Write complex SQL queries to satisfy client / internal reporting requirements
- Build reports in Excel and SSRS and dashboards in Power BI
- Perform ad hoc data analysis as required by client and internal management
- Perform quality analysis of all results to validate the accuracy of data
What are the requirements needed for this position?
Experience writing complex queries using subqueries, Common Table Expressions (CTEs), derived tables, and temporary table structures
Oracle eBusiness Suite as a WMS
AssurantProudJR
Pay Range :
101,500.00 - $169,400.00
Any posted pay range considers a wide range of compensation factors, including candidate background, experience and work location, while also allowing for salary growth within the position.
Expected application deadline is
02 / 01 / 2025
If date is blank then this is a pipeline requisition, and we will continue to collect applications on an ongoing basis.
Helping People Thrive in a Connected World
Connect with us. Bring us your best work and your brightest ideas. And we'll bring you a place where you can thrive. Learn more at jobs.assurant.com.
For U.S. benefit information, visit myassurantbenefits.com. For benefit information outside the U.S., please speak with your recruiter.
What's the culture like at Assurant?
Our unique culture is a big reason why talented people choose Assurant. Named a Best / Great Place to Work in 13 countries and awarded the Fortune America's Most Innovative Companies recognition in 2023, we bring together top talent around the world. Although we have a wide variety of skills and experiences, we share common characteristics that are uniquely Assurant. A passion for service. An ability to innovate in practical ways. And a willingness to take chances. We call our culture The Assurant Way.
Company Overview
Assurant is a leading global business services company that supports, protects, and connects major consumer purchases. A Fortune 500 company with a presence in 21 countries, Assurant supports the advancement of the connected world by partnering with the world's leading brands to develop innovative solutions and deliver an enhanced customer experience through mobile device solutions, extended service contracts, vehicle protection services, renters insurance, lender-placed insurance products, and other specialty products.
Equal Opportunity Statement
Assurant is an Equal Employment Opportunity employer and does not use or consider race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity, or any other characteristic protected by federal, state, or local law in employment decisions.
Salary : $101,500 - $169,400
