Job description

FirstPro is now looking for a Data Warehouse Manager on behalf of our client. This is a hybrid role only requiring you to go on-site in Wilmington once per week or every other week.

• The technical leader will manage a team that is responsible for our data warehouse, complex reporting/data requests, and integrations
• Establish and enforce ETL standards for documentation, development, and deployment; Implement ETL best practices and standardization.
• Plan and direct the daily activities of a team focused on a particular system or technology
• Apply specific technical expertise in-depth to address technical and business issues
• Provide oversight of Data Design and Development, including data architecture, modeling and ETL development alongside with Data Architect
• Participates in build related activity discussions, environment setup implementation schedule/changes promoted in the test environment
• Work with IT infrastructure for on-prem SQL Server development and Azure data ingestion, migration
• Looks for continuous improvement opportunities through automation and simplification of all current activities
• Analyzing potential data quality issues to determine the root cause, and creating effective solutions
• Work with BRM and provide technical input during project discovery, initiation process before project is taken into EIM
• Work with internal PMO, managers in IT and other functions to apply standard solutions and processes
• Work with other dev managers, vendor pods to set expectations, and facilitating open communication channels
• Participate in daily scrums and various phases of the projects – initiate, discover, design, develop, deploy, and advise the EDW production support team
• Manage EDW department staff including hiring, performance management, and career development to ensure alignment with defined goals
• Work with EIM leader on budget and Jira Time tracking
• Proactively initiate, develop, and maintain effective working relationships with team members
• Continuingly assess and improve the team structure within Data Management while ensuring it aligns with immediate tactical and long-term strategic goals

Qualifications

Experience

• Overall 10+ years of technical data warehouse management experience
• 7+ years’ experience designing, developing, testing, and supporting of MSFT SQL Server ETL using Microsoft BI Stack, and OLAP cubes
• 5+ years of managing team sizes of 5 or more individuals and demonstrated skill in managing technical staff
• 3+ years of Azure synapse Analytics, Azure Data warehouse, Data Lake, Power BI
• Good exposure to various cloud platforms (Azure, AWS, OCI) to play a key role in Application Modernization

Education

• Bachelor's degree in Computer Science, MIS, related field, or equivalent experience

Additional Requirements

• Good exposure to various cloud platforms (Azure, AWS, OCI) to play a key role in Application Modernization
• Ability to understand the process involved to adapt, integrate, and modify existing programs or vendor-supplied products for use within the technical environment
• Previous experience as a lead in a functional area, managing cross-functional teams on large scale projects or supervisory experience including hiring, training, assigning work, and managing the performance of staff
• Azure/SQL Server experience is strongly preferred
• Experience in leading IT process improvement efforts and participating in team development activities

Job Type: Full-time

Pay: $150,000.00 - $170,000.00 per year

Benefits:

• 401(k)
• Dental insurance
• Health insurance
• Paid time off
• Retirement plan
• Tuition reimbursement
• Vision insurance

Schedule:

• Monday to Friday

Work Location: Hybrid remote in Boston, MA 02110

colinoncars.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, colinoncars.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, colinoncars.com is the ideal place to find your next job.