We are seeking a seasoned SQL Server Data Architect with over 10 years of experience to design and implement comprehensive data solutions for our enterprise data platforms. The ideal candidate will have a proven track record in designing end-to-end data architectures, including Data Lakes and Data Warehouses, and will be proficient in SQL Server, ETL processes, and data migration.
Key Responsibilities
- Design and Architecture. Develop and oversee the end-to-end design of data solutions, including Data Lakes and Data Warehouses, leveraging SQL Server. Create data models, mappings, and perform data transformation as required.
- Migration Expertise. Lead and execute data migration projects from Oracle to SQL Server 2022, ensuring seamless transition and minimal disruption.
- Database Management. Build and optimize databases for performance tuning. Model databases effectively to support business needs and enhance data accessibility.
- ETL and Data Integration. Utilize ETL tools such as DataStage to build and manage data ingestion pipelines. Manage large-scale data integration projects involving multiple data sources and a multitenant architecture.
- Complex Data Solutions. Demonstrate hands-on experience with complex data warehouse solutions across various platforms, including SQL Server, DB2, Teradata, and Oracle.
- Technical Documentation. Develop comprehensive design documents and architecture diagrams. Create and manage scripts for data loading, extraction, and transformation using procedures, Unix, and other relevant tools.
- Requirements Analysis. Analyze and translate functional specifications and change requests into detailed technical specifications. Gather and track requirements, ensuring data accuracy and integrity through meticulous analysis and coding.
- Project Management. Estimate efforts, timelines, and risks associated with implementing solutions. Work closely with offshore delivery teams to provide technical guidance, track solution component status, conduct reviews, and mentor team members.
Required Skills and Qualifications
- Experience. Over 10 years of experience in SQL Server data architecture and design.
- Migration. Proven experience with data migration projects, particularly from Oracle to SQL Server 2022.
- ETL Tools. Extensive experience with ETL tools like DataStage and data ingestion pipelines.
- Data Integration. Strong background in managing large-scale data integration projects with multiple data sources and multitenant architectures.
- Database Expertise. In-depth knowledge of SQL Server, DB2, Teradata, and Oracle. Experience in performance tuning and database optimization.
- Technical Skills. Proficient in SQL, scripting (Procedures, Unix), and creating technical documentation.
- Project Coordination. Skilled in requirement gathering, tracking, and risk estimation. Ability to work with offshore teams and manage project deliverables effectively.
Education and Certifications
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- Relevant certifications in SQL Server, Data Architecture, or ETL tools are advantageous.
Why Join Us
- Innovative Environment. Work with cutting-edge technologies and participate in impactful data projects.
- Growth Opportunities. Access to professional development and career advancement opportunities.
- Collaborative Culture. Join a team that values collaboration, mentorship, and continuous learning.
If you are a driven and experienced SQL Server Data Architect with a passion for designing robust data solutions, we invite you to apply and be a part of our dynamic team.