JOB DESCRIPTION SQL Data Architect Chicago, IL Qualified candidate’s responsibilities will include: determining the design and implementation of database structure requirements and analytical capabilities by analyzing operations, applications, and programming, reviewing objectives with clients, evaluating current systems and developing/installing solutions. In addition, this person would be responsible for generating and compiling reports based on findings. JOB REQUIREMENTS Apply today if your background includes:
8+ years of experience with technical requirements analysis, business process modeling & mapping, methodology development, report writing and data modeling techniques
8+ years of experience with architecture, design and implementation of high traffic, highly available and scalable data system
8+ years of experience with SQL Server, SSAS, SSIS and SSRS
Experience in designing prototypes and working closely with implementation teams in engineering and operations
Experience working and collaborating with global teams
Project management skills and project management software skills
Ability to work independently and collaborative with other staff members
3+ years of experience working with technologies/platforms such as Google Big Query, MongoDB, Hadoop, OBIEE, Tableau, Informatica and/or Talend (Preferred)
3+ years of experience working with SaaS solutions such as Workday, Salesforce, SAP and Great Plains (Preferred)
Collaborate in setting the strategy for data warehousing and business analytics; set standards and best practices for programming and data security
Develops HA and reliable database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications.
Maintain performance of database by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.
Collaborate and develop models, procedures, and protocols for reporting in concert with company goals.
Develops ETL processes to acquire and load data spanning across various on-premise and cloud based applications
Collaborate with business leaders, application teams, and subject-matter experts to a establish technical vision and analytics strategies for global business functions