Report this job

---

What is the problem? *

Incorrect company
Incorrect location
Job is expired
Job may be a scam
Other

Title: Senior Data Warehouse Developer(SQL/SSIS) Location: Boston, MA (Hybrid-3 days office) Duration: 24 months BASIC FUNCTION The Senior Data wareho use developer provides management for the development of architecting, designing, building, and enhancing data warehousing, data mart, and extensive data services. DUTIES AND RESPONSIBILITIES 10+ years of experience developing MS SQL Server programming solutions. Proficiency with stored procedures and SSIS packages Bridge the gap between business and data by working cross-functionally with other teams. Monitor and maintain the health of data. Extract insights from data exploration tasks to inform business. = Design performant technical solutions Design reporting architecture and approach Analyze, design, and build dimensional and relational data models and logical data specifications. Work with businesses to provide support for tickets about all production issues. Document data mappings, data models, and ETL Continuously develop expertise in the data and data models within the data warehouse, understanding of support business domains Load and validate dimensions and measures via SSIS. Perform all application unit and system testing. Create a data dictionary and proper documentation on the data warehouse. Data Governance: Establish mechanisms and processes to ensure ongoing quality of the data across all critical organizational systems. Data Cleansing: Support ongoing data cleansing activities through analysis and automated scripts where possible Data Migration: Support migration of new data sources into existing applications through analysis and development of automated scripts Report/Dashboard Development: Support complex report and dashboard development that goes beyond the business user's ability to self-serve. Ad Hoc: Complete ad hoc projects and assignments as needed QUALIFICATIONS 10+ years of experience in data management and analytics Experience in SQL scripting, data manipulation, data analysis, data modeling, generating business insights, defining, and measuring performance metrics basis s tatistical modeling. Must be proficient in SQL and complex query development. Experience extracting insights from data; communicating and presenting key findings to product teams. Strong ex= perience with analytics and BI tools such as Tableau, Power BI, or other si milar tools Experience with Datawarehouse technologies Experience with ETL tools such as SSIS, Talend, Matillion, or other similar tools Integrate multiple and complex data sources , including transactional and non-transactional, structured, and unstructured. Proven success in informing strategy through data-driven recommendations and insights Excellent documentation, presentation, and overall interpersonal and communication skills Ability to work well under pressure with a high level of follow-through. Strong analytical, problem-solving, and conceptual skills Expertise in planning and managing resource workload across initiatives. Superior written and verbal communication skills. Mentor users and piers to improve analytical skillsets across the organization.