Sql Reporting Manager Jobs (NOW HIRING)

The Reporting Manager is responsible for the scoping, construction, consolidation, and maintenance of Management Information Dashboards and Static Reporting for Internal and External Clients, which are aligned with business strategy, company objectives and commitments.
The Manager will work in partnership with Key Stakeholders to understand the reporting requirements through: Facilitating scope meetings; Produce scope documentation which outlines the build criteria, data definitions and design capabilities.
Reporting is delivered by working in collaboration with internal IT Departments to source complex data connections, and access relevant data tables from various back-office systems.
New requests are assessed against existing reports to prevent duplication and alignment with existing data sources to reduce the construction time to ensure a more efficient build. Existing static reports are reviewed on a periodic basis in conjunction with new requests, with a view to 1) Incorporate within Dashboards, 2) Removal due to replacement of live interactive MI or 3) Enhanced manual reporting.
The team has a responsibility to deliver high standard, valuable and accurate reporting; through stringent validation and attention to detail; utilizing key technical skills and ability, with adherence to strict deadlines, ensuring reports are distributed in a timely manner.
The role of Reporting Manager is to take responsibility for the day-to-day management of the Reporting Analysts. Accountable for quality control and the performance and deliverables of the team; Decision making on behalf of the department and giving direction to other team members. Organization of the team and their workload and aligning them with our company values: Trust, Respect, Urgency and Excellence and Accountability.
The Reporting Manager position should provide support and guidance to all team members to enable them to deliver accurate and timed reporting to the highest possible standards. The daily duties will involve taking ownership of certain areas and being able to provide cover for others.
This is an onsite role reporting into our Lewisville, TX office.
What will be my duties and responsibilities in this job?

• Constantly reviews internal processes and procedures to improve existing reporting
• Undertake ongoing analysis of reporting in the team and wider business to identify reporting efficiencies and the removal of duplicated reporting
• Arrange, agenda and lead monthly meeting with key stakeholders to share the progress and project plan, proactively re-organize/reschedule team priorities and resource to ensure it is aligned with business strategy, produces reporting statistics as and when required
• Plans and oversee prioritization of assigned projects and priority tasks in line with project plan, team priorities and internal and external reporting deadlines
• Ensure reporting deadlines and Client SLA agreements are adhered to and where delays or threats to service levels are incurred or at risk, provide regular and informative updates to manage customer expectation
• Responsible for data integrity in relation to the accuracy and consistency of data used for reporting purposes and maintenance; checking reconciliation, content and validation and raising questions or concerns in relation to possible errors or content prior to delivery to ensure reporting of the highest standard
• Maintain a Quality Assurance score of audited reports in the month of 90% or above
• Arrange and hold scope meetings, conduct investigation and deliver scope outline documentation in line with reporting request
• Accountability for evidencing data definitions and justification for data sources and calculations, to ensure that all reports provided are appropriate to the user and in line with the agreed scope
• Collaborate with internal IT Departments in relation to data sources/connections and relevant data tables from controlled IT environments and various back-office systems
• Use SQL Server Management Studio to write statements to design data views, for promotion to the internal Operational Data Store, to create live data connections for reporting tools
• Build and develop interactive and accessible MI dashboards in Microsoft Power BI. Connecting and writing SQL statements to retrieve accurate data from the Operational Data Store, ensure reports are valid and in line with the appropriate scope document
• Develop an all-round understanding of all reportable business areas through interactions with these departments to ensure reporting requirements are fully understood and fulfilled, with an awareness of the insightful impact MI has on decision making within these areas
• Sharing knowledge through creating and maintaining effective work level instructions, performing on the job training of peers and maintaining open communication in line with development plans
• Provide ad hoc requests for data and reporting, which may be required by immediate or senior management
• Ensure reports and task statuses are kept updated in a timely and efficient manner on relevant reporting tools demonstrating current position and completeness
• Provide technical support for other areas of the business that use Power BI as a reporting tool, being a point of contact for creating data measures and connection to tables

What are the requirements needed for this position?

• Bachelor's degree in Computer Science, Analytics, Business, Economics, Accounting or a related field.
• Minimum of 4+ years of experience in the fields of insurance, analytics and reporting
• Expert in visualization techniques, Broad in visual story telling with data, designing highly automated descriptive analytics/reporting solutions, building, integrating and managing databases, creating data models, especially within the Power BI stack, understanding of business needs and processes.
• Experienced in PowerB, Excel, SSRS and Tableau, Broad in SharePoint, PowerApps, MSFlow, SQL and/or SAS.
• Broad in effective and compelling communication to technical and non-technical departments.

What other skills/experience would be helpful to have?

• Displays a clear understanding of our TRUE values (Trust, Respect & Integrity, Urgency and Excellence and Accountability).
• Performance Management and Team Management skills.
• Good understanding of organizational structure and goals.
• Highly organized.
• Excellent attention to detail.
• Developing and maintaining effective working relationships with both internal and external contacts.
• Ability to communicate effectively with Key Stakeholders and Clients, both face to face and in writing, accurate and realistic timeframes for reporting delivery.
• Accountable for allocated projects and priority tasks and delivery to agreed timelines.
• Ability to prioritize own time/workload in line with Project Planning and Key Stakeholder requests.
• Flexible approach to reporting, realigning priorities with business where necessary, adaptable to change.
• Ability to work well under pressure, using own initiative.
• Awareness of the effect insightful MI has on decision making.
• Technical skills and knowledge of all team reporting tools, data sources/connections and data tables to enable investigation and delivery of report request.
• SQL/Query building knowledge.
• Inquisitive mind and keenness to learn new systems and processes.
• Acts with urgency, without compromising on quality, with thorough validation and attention to detail.
• Competent at working with Microsoft Office products, specifically Excel
• Awareness of Microsoft Access and Power BI is advantageous.
• Ability to navigate and develop interactive workflows and forms in SharePoint.
• Problem solving skills, solutions orientated, ability to explore alternative data methods/sources.

ENT2768 - Mgr, Reporting
Job Grade
11
Pay Range:
$74,600.00 - $124,700.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.
If there is no posting end date 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. Continue your career at Assurant. Learn how to apply.
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 15 countries and awarded the Fortune America's Most Innovative Companies recognition, 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.
For information regarding the collection, use, and protection of your personal information, please review our Privacy Notice available at Assurant Careers Privacy Notice.