Data Warehouse Developer

A financial firm is seeking a Data Warehouse Developer to join their team in New York, NY.

Pay: $800 – $1000/day (contract)

This role is onsite.

Responsibilities
Rollup sleeves to analyze and fix production issues
Analyze and assess existing platform for maintainability, reliability, scalability, security, and
performance.
Define standards for the design and analysis of load processes, data flows and data models.
Lead the design, build, and deployment of ETL (extract, transform, and load) processes for large
data sets.
Review the existing platform architecture and come up with recommendations to solve the
current performance issues which exists in cube processing, Data imports, Drill throughs.
Facilitate code reviews, software design sessions and architectural reviews.
Participate in technical advisory roles, as required
Interact with business users, as required.
Provide ad hoc support in troubleshooting highly complex production issues as they arise.
Conduct root cause analysis and performance tuning for data load processes.
Ability to problem solve, recommend, and develop technical solutions.

Qualifications
Bachelor’s degree in Computer Science, Information Systems, or another four-year degree with
IT OR equivalent experience. Master’s degree preferred.
Overall 15 years in Microsoft technology SQL Server, SSIS, SSAS
10 years of experience delivering Data Warehouse solutions
5 years serving as a Data Warehouse architect with a demonstrated track record of
implementing highly scalable and available solutions into a highly transactional production
setting
Data Warehousing & ETL
o Significant data warehouse experience from planning, to design, to implementation.
o Experience of designing strategies for ETL audit, load balance, exception handling and
high data volumes.
Hands on experience in all areas of SQL Server development including stored procedures,
functions, and triggers.
Proven expertise in Data warehouse methodologies as well as extensive knowledge of
OLTP/OLAP technologies.
Ability to design, organize, and implement module, perform system testing,
Plan and automate tasks to maintain existing system
Ability to research and trouble-shoot application problems
Highly motivated team player with strong communication and interpersonal skills
Business analysis, especially business requirements gathering

Proficient In:
Relational Database Concepts
Data Warehouse Concepts
Dimensional Data Modeling and Notation
Microsoft SSIS
ETL Processes
OLAP Cube Development experience
MDX experience is preferred
Microsoft Team Foundation Server / Git
Application Performance Tuning and Optimization
Data Warehouse Technologies: Azure Synapse Analytics, Data Lake, pipelines
Agile development methods and Dev/Ops CI/CD (Preferred)

Source ⇲