Data Warehouse Developer
Location: Hingham, Massachusetts US
Notice
Job Number: 7013
Position Title: Data Warehouse Developer
External Description:
This position is responsible for the architect, development and maintenance of Talbots enterprise data warehouse. The BI/Data warehouse Developer must have a deep understanding of enterprise data warehouse and reporting solutions. The developer will participate in full-life cycle of design, develop, implement, enhance, maintain and support such solutions.
MAJOR DUTIES AND RESPONSIBILITIES
Participate in data strategy initiatives and cloud transformation priorities of enterprise data warehouse/BI team
Enhance and support enterprise data warehouse and datamart
Proficient in writing complex SQL queries in MSSQL and Azure SQL platform
Adhere to SLA standards set for data warehouse availability
Participate on-call/support activities
Provide data support to business users based on requirements
Architect and maintain virtual data warehouse layer to facilitate Microstrategy reporting
Assist BI team in migration of SSRS/SSAS based legacy solutions
Ensure quality and integrity of data within the EDW
Create SSIS packages and Autosys schedule
Enable scalable enterprise wide self-service reporting capability using modern data warehouse features (in memory/columnar store)
Work with administrator in performance tuning of SQL server
Understand the retail industry and business context of the data
Understand and execute good development practices through a SDLC process laid out
Perform other duties as requested from time-to-time
REQUIRED QUALIFICATIONS
Skills/Abilities and Knowledge
Expertise in using MSSQL 2017 features to design Enterprise Data Warehouse
Strong SQL and Azure Cloud skills
Self-motivated with an ability to confidently execute independently with little direction
Ability to analyze and apply critical thinking to resolve complex issues
Strong problem solving skills with ability to work well under pressure
Strong team and relationship building skills
Ability to prioritize requests and set expectations
Working Knowledge in data warehousing concepts
Expertise developing SSIS/SSAS/SSRS
Retail Industry experience strongly preferred
Motivation to stay up-to-speed on industry best practices and new technologies
Aptitude to manage delivery of reporting solutions, draft technical and training documents
Outstanding communication skills (written, verbal, and listening)
Exposure or working experience with Databricks (ELT/ETL), Azure datalake, Azure SQL server/data warehouse.
Education & Experience
Bachelor's degree in Information Technology or business related field
5+ years’ experience Data Warehouse design/development
5+ years’ experience SQL Query Design
2+ years’ experience Microsoft Azure Cloud Experience
City:
State:
Community / Marketing Title: Data Warehouse Developer
Company Profile:
Talbots is a leading omni-channel specialty retailer of women's clothing, shoes and accessories. Established in 1947, the company is known for modern classic style that's both timeless and timely, fine quality craftsmanship and gracious service. At Talbots relationships are the key to our business, we hire individuals who bring new ideas to the table, understand smart risk taking and can enhance an already thriving culture. With a commitment to offer modern classic style for every body type, through a full range of sizes, inclusive to every woman in your life.
EEO Employer Verbiage:
Talbots is an equal opportunity employer and welcomes applications from diverse candidates. Hiring decisions are based upon a candidate's qualifications as they relate to the requirements of the position under consideration and are made without regard to race, sex, national origin, color, age, disability, veteran status, pregnancy, sexual orientation, religion, or any other category protected by applicable law. Talbots is committed to providing reasonable accommodations for job applicants with disabilities. If you require an accommodation to perform the essential duties of the position you are seeking or to participate in the application process please contact recruiting@talbots.com. Talbots will make reasonable accommodations for otherwise qualified applicants or employees, unless such accommodations would impose an undue hardship on the operations of the Company’s business.
PositionType_Description: Full Time
Location_formattedLocationLong: Hingham, Massachusetts US