Be an early applicantLess than 25 applicants

Company

Original Job Post

Totes Isotoner · 2 days ago

Senior BI Data Warehouse Developer

Ohio, United States

Full-time

Onsite

Senior Level

5+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

E-CommerceFashion

Insider Connection @Totes Isotoner

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Review, learn and update existing documentation on BI and DW

Provide strategic and tactical solutions for business intelligence, data warehousing, and DBA

Collaborate with developers, business analysts, and cross-department teams

Provide end-to-end support through requirements gathering, design, development, testing, and implementation

Work on data projects to support application and reporting initiatives

Make improvements to existing data warehouse, reporting tools, and ETL processes

Design database schemas, tables, indexes, relationships, and ETL processes using MS SQL Server stack

Design, develop, test, and implement SSMS, SSRS, SSIS, and other ETL solutions

Support maintenance of production databases and new databases for desired performance

Mentor IT team members, provide documentation and learning experiences

Assist team members in day-to-day operations

Adhere to change management procedures and Agile development methodology

Adhere to and improve Data Governance and DW standards

Perform other assigned duties

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Database managementBusiness process improvementBusiness priorities understandingSQLMS SQL ServerSQL DevelopmentSQL Management StudioSSMSSSRSSSISSSASETLBIDatabase architectureDatabase designData modelingData flow diagramsNormalizationSecurityGovernanceProblem-solvingHard-working communicationTeachingMentoringMotivationalTeamworkTableauArchitectureAgile development

Required

Excellent understanding of, and vast experience with database structures, theories, principles, and practices

Ability to enhance business efficiencies through both system performance initiatives as well as business process improvement

Gather BI requirements from the business and translate into specifications, including tasks, timelines, and time estimates

Must be able to demonstrate a thorough understanding of business priorities

Ability to prioritize and work on several tasks simultaneously

Ability to maintain excellent work ethic, work independently, remotely, with minimal supervision

Excellent written and communication skills.

Must be able to teach and mentor peers

Motivational skills to create team cohesiveness and to foster a positive team environment

BS in Information Sciences, a related discipline or equivalent job experience

SQL experience with expert-level skills in the SQL language, creating views and stored procedures, MS SQL Server Stack

SQL DBA: 5-8 Years of SQL DBA

SQL Development: 5-8 Years of SQL; Stored Procedures, Views, Constraint Checks, and Indexes

SQL Management Studio, SSMS, SSRS, SSIS, SSAS, ETL: 3-5 Years

BI: 3-5 Years of Business Intelligence

Architecture, Design, and Governance: 3-6 Years of Database Design, Database Modeling, Data Flow Diagrams, Normalization, Security (Database and Web), and Governance

Preferred

Preferred Methodology and Architecture: 2-5 Years of and Agile Development Methodology

Preferred knowledge of Tableau visual analytics platform

Company

Totes Isotoner

Founded in 1923 and headquartered in Cincinnati, Ohio, totes»Isotoner is the world's leading designer, marketer and distributor of functional accessories in the rain, cold weather and footwear categories.

Founded in 1924

Cincinnati, Ohio, USA

201-500 employees