Vacancy expired!
Azure Architect100% REMOTEThe Azure (Data Analytics) Architect will be responsible for designing, developing and administering data analytics and business intelligence architecture and solutions in Microsoft SQL Server and Azure platforms. This will include data integration, data lakes, data warehousing, data visualization and other related development and administrative tasks. In addition to strong technical and project management skills, this position requires excellent customer relationship management and multi-tasking efforts.The Azure (Data Analytics) Architect responsibilities are:
- Engage in detailed and advanced requirements gathering for Data Analytics and BI project statements of work
- Create and maintain technical writing and guidelines for Data Analytics and BI Solution development
- Design relational and analytical database schemas and architectures based on best practices and customer requirements/needs
- Administer production databases and processes including maintenance related tasks and activities
- Troubleshoot existing Data Analytics and BI solutions including processing, performance and failures related to ETL/ELT, data warehouse and reporting
- Provide recommendations on existing server and database level BI architecture using best practices and knowledge of business requirements
- Design, implement, deploy and maintain data integration solutions using data lake architectures, ETL/ELT and data flow processes, including data quality, governance, performance best practices and unit testing.
- Architect, design, deploy and maintain enterprise level data warehouses and data marts including various data modeling techniques
- Write complex T-SQL code and stored procedures to be utilized by applications, ETL/ELT and reports
- Review, recommend and implement changes to existing T-SQL code and stored procedures for performance improvements
- Design complex reports and dashboards to satisfy business needs using native tools as well as some third-party applications
- Microsoft SQL Server 2000 to 2019 and Azure IaaS/PaaS/SaaS technologies
- Experience with designing, developing, and supporting database environments
- Strong customer relationship management
- Technical writing and documentation experience
- Experience with project management methodologies including agile and scrum
- Expertise in Microsoft SQL Server Integration, Analysis and Reporting Services
- Hands on exposure in Microsoft Azure Data Lakes, Data Factory, Synapse, Analysis Services and Power BI
- Exceptional analytical, conceptual and problem-solving abilities
- Development of Multi-dimensional and/or tabular data warehouses
- Familiarity with metadata management concepts, change management/version control concepts
- Versatile and knowledgeable in T-SQL programming and SSIS design
- Some experience in database administration
- Experience with third party BI Tools and such as QlikView, Tableau, Cognos, etc. is a plus
- Experience in AWS Data Analytics Technologies is a plus
- Experience with other programming and machine learning languages is a plus
- Bachelor s degree in a technical or science related field of study.
- Minimum 8 years of experience in Microsoft SQL Server or equivalent work experience
Vacancy expired!