Description
Design and maintain large-scale data warehouse and lakehouse architectures. Own the full data lifecycle from ingestion to visualization.
Responsibilities
- Architect data solutions using MS SQL Server, including stored procedures, triggers, and performance tuning.
- Develop and optimize data integration pipelines using SQL Server Integration Services (SSIS).
- Implement cloud architecture patterns on Azure or AWS.
- Ensure data quality, standardization, and interoperability across systems.
- Create data visualizations using Tableau and other BI tools.
Required Skills
- 10+ years of experience in data administration and data warehouse architecture.
- Expert-level SQL programming, including DTS packages and linked servers.
- Deep experience with MS SQL Server, OLTP, and DSS environments.
- Proficiency in Azure DevOps for source control.
- Experience with IDEs such as Visual Studio and Business Intelligence Development Studio.
- Strong background in data modeling and data quality assurance.
- Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field (or equivalent experience).