Business Intelligence Architect


Chicago, IL

Industry: Technology


8 - 10 years

Posted 174 days ago

  by    Teresa Hanson

This job is no longer available.



Works with the development teams in the data modelling and product database design

Identify new database technologies and architecture to utilize as part of overall application

Perform code reviews of database development artifacts (scripts, stored procs, triggers, etc.)

Develop and test complex SQL stored procedures, scripts, triggers

Performs performance optimization of SQL and stored procs and other database artifacts

Develops and tests SQL scripts and stored procedures to perform data maintenance in development, test and production environments

Participate in agile development processes including estimation, sprint planning, development, daily standups, retrospectives

Creates and maintains appropriate documentation (database schema, architecture, etc.)

Act as final escalation point for database related issues as part of multi-tier support process

Perform deployment of database objects (tables, stored procs, triggers, etc.) to development, test and production environments

Effectively supports Sales and Professional Services as part of new client implementations

Installs and configures database system software plus third-party system tools, applications and products in development and test environments

Implements, periodically tests and reviews appropriate data access and security measures, including access control, audit, backup/restore and system rebuild & recovery processes

Implements and continuously improves the databaseinfrastructure environment

Provides fast and value-added services to the development organization

Pro-actively seeks and acquires technical training, vocational training and market and product awareness such that skills remain current, relevant and valued within Allscripts

Trains, coaches, and mentors junior team members

Helps build the team with the right talent via recruiting and interviewing activities


Academic and professional qualifications:

Bachelor's Degree with a major in Computer Science, Mathematics, MIS or any related courses



7 plus years of technical experience in Data Warehouse software development

In-depth knowledge of SQL Server Integration Services version 2008 R2 through 2016

Experience with SQL Server Reporting Services version 2008 R2 through 2016

Strong data warehouse dimensional modeling skills

Strong ETL design and development utilizing SQL Server Integration Services

Strong SQL design and development skills; experience in designing for performance

Experience with Agile development

Experience with multi-tenant SaaS based solutions a plus

Healthcareexperience a plus: Population Health, Care Coordination, HL7, HIE, IHE, CCD, etc

Excellent analytical, troubleshooting and debugging skills

Excellent research and analysis skills

Excellent communication and interpersonal skills

Self-motivated and tenacious when tackling tough technical issues

Ability to work closely within a team and collaborate with other

Ability to handle conflict, difficult situations, and urgent issues in a professional manner

Experience in working with offshore/distributed teams

Production DBA mindset with concern for performance, availability and managed change.

$120K - $150K