Data Warehouse Developer

Data Warehouse Developer

Job Ref: TE0105 Category: Information Technology Department: INFORMATION TECHNOLOGY Location: 50 Water Street, 7th Floor, New York, NY 10004 Job Type: Regular Employment Type: Full-Time Work Arrangement: Remote Salary Range: 133,550.00 - 144,550.00

The individual will be accountable for successful design, development, and delivery of SQL solutions within an on-prem SQL Server environment. An ideal candidate will be someone who leads, develops, maintains, and integrates processes for a data warehouse that will extract data from standardized or varied data sources and transforms data for storing in proper formats and structures for querying and analysis using SSIS. This would include loading data into an operational data store (ODS) and a dimensional model (EDM). Data exchange with Salesforce.

Scope of Role & Responsibilities

• Perform extensive data analysis of the source transaction processing systems.
• Develop new and modify existing data marts, organizing the data in Star Schemas.
• Develop and modify extraction, transformation, and loading procedures using SSIS packages.
• Develop new and modify existing SQL Server stored procedures to clean, consolidate, and reorganize the data in a format suitable for reporting.
• Perform thorough testing of all new and modified data marts to ensure the quality of the data.
• Performance tuning.
• Develop Full and Incremental Loads.
• Modify existing processes to ensure the data are loaded in a timely manner.
• Troubleshooting.
• Perform analysis and suggest solutions for resolving production problems.
• Provide maintenance and support for all the Data Warehouse loads.
• Provide Ad Hoc reports and data analysis when needed.
• Develop and modify Data submission processes to outside vendors and within the company.

Required Education, Training & Professional Experience

• Bachelors Degree in computer science, information systems, business administration, or related field.
• 10 years of relevant experience.
• Excellent MS SQL Server skills.
• Good understanding of data warehousing concepts.
• ETL tools experience.
• Health Insurance experience is a big plus.

Professional Competencies

• Integrity and Trust
• Customer Focus
• Functional/Technical skills
• Excellent analytical and problem-solving skills
• Ability to understand business needs
• Ability to learn new software tools
• Ability to work independently with little supervision
• Excellent verbal/written communication skills
• Ability to work in a team on assigned project
• Strong analytical skills

MHP50 LI-Remote