Data Architect - SSIS, SSAS, SSRS

Full Time
$110,000 - $130,000
Work from home not available Travel not required

Job Description

Data Architect

Looking for a candidate with 5 plus years as a SQL data architect/data engineer. 10 years Microsoft SQL SSIS and SSAS multidimensional model ability to write complex SQL queries for ETL reporting data visualization tools like Tableau XLCubed ESRI SSRS complex database designs and data warehouse system resolve data and performance issues.


  • Facilitate collaboration for development of long-term strategic plans of production databases in conjunction with data owners, business units, IT product owners, and Enterprise Architecture
  • Assist business units and project management in developing the budget projections based on short- and long-term goals and objectives
  • Develop and maintain data models and data flows that represent essential data consumed and produced
  • Develop and maintain documentation that maps data models to information systems and business applications
  • Be resourceful in the use of enterprise data, including guidance in understanding and exploitation of the underlying data and business models, and identifying optimal data sourcing and mapping
  • Analyze the logical and physical database models to ensure models are in accordance with standards
  • Assist in building of enterprise architecture information blueprints that illustrate how information is stored, processed, and accessed.
  • Participate in enterprise information architecture discussions around needs and alignment to business goals
  • Collaborate with Database Administrators and other staff to resolve data issues, performance issues and to ensure the highest possible degree of data integrity
  • Validate and fix information management issues related to data quality framework (completeness, accuracy, availability, timeliness, consistency, etc.)
  • Enforce enterprise information standards, guidelines, and principles


  • 5+ years of experience as a Data Architect/Data Engineer
  • 10 years of strong working knowledge of Microsoft SQL server, SSIS and SSAS (multidimensional model)
  • In-depth understanding of database structure principles
  • Ability to write complex SQL queries for ETL or reporting
  • Must be project oriented with an ability to meet deadlines.
  • Excellent written and oral communications
  • Familiarity with data visualization tools (e.g. Tableau, XLCubed, ESRI, SSRS etc.)
  • Familiarity with Python for data analysis is a plus
  • Experience with Yardi or any other Real Estate Property/Accounting/Asset Management system is a plus
  • Bachelor's degree in Computer Science, preferred

Posted By

Robyn Honquest

Dice Id : napil006
Position Id : 6154943
Originally Posted : 3 months ago
Have a Job? Post it

Similar Positions

ETL Architect - SSIS
  • Trianz
  • Rosemont, IL
Data Integration SSIS SSAS
  • Encore Consulting Services
  • Rolling Meadows, IL
ETL Developer / SSIS/SSRS
  • MARRS Professional Services Inc
  • Chicago, IL
SQL BI Developer
  • Sysintelli, Inc.
  • Chicago, IL
SSIS Azure Developer
  • Connect Search LLC
  • Chicago, IL
SQL Data Architect
  • Request Technology, LLC
  • Chicago, IL
Sr. Data Warehouse Developer (SSIS)
  • Resource 1
  • Chicago, IL
Microsoft Power BI Developer
  • 3Ci
  • Naperville, IL
SQL Developer
  • Net2Source Inc.
  • Alsip, IL
SQL Developer
  • Adept Scripts
  • Elk Grove Village, Illinois
BI SQL Developer
  • Myticas LLC
  • Elmhurst, Illinois
BI Developer
  • Kelly IT
  • Chicago, IL
SQL Server Developer
  • Xceltrait Inc.
  • Westchester, IL
CLOUD Database engineer
  • Whiztek Corp
  • Chicago, IL
ETL SSIS Developer
  • Instant Technology
  • Chicago, IL