SQL Data Architect

SQL, SSRS, SSIS, SSAS, ETL, DW, Tableau
Full Time
$100,000 - $130,000
Work from home not available Travel not required

Job Description

SQL Data Architect


***We are unable to sponsor as this is a permanent full time role***

Responsibilities

  • 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
  • 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.)
  • 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.

Qualifications

  • Bachelor s degree in a technical field or equivalent work experience
  • 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
  • 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

If this is an opportunity that you're interested in please email your resume to:

Khonn@requesttechnology.com

To view other job opportunities please visit our website at Requesttechnology.com

Posted By

Kyle Honn

200 East 5th Ave., Suite 116 Naperville, IL, 60563

Contact
Dice Id : napil006
Position Id : KH374
Originally Posted : 4 months ago
Have a Job? Post it

Similar Positions

Data Architect - SSIS, SSAS, SSRS
  • Request Technology, LLC
  • Chicago, Illinois
Data Architect
  • Connect Search LLC
  • Chicago, IL
Sr Data Integration Developer - MS BI
  • Trianz
  • Rolling Meadows, IL
Data Engineer
  • Merchants Fleet
  • Rosemont, IL
Report Developer
  • MetaSense, Inc.
  • Naperville, IL
Senior BI Developer
  • RSM US LLP
  • Chicago, IL
BI Developer
  • Infinity Consulting Solutions
  • Rolling Meadows, IL
Data Engineer
  • Waystar Health
  • Chicago, IL
Data Integration SSIS SSAS
  • Encore Consulting Services
  • Rolling Meadows, IL
BI Developer (Direct full time hire)
  • DivIHN Integration Inc.
  • Glenview, IL
Business Intelligence Developer
  • Rush Health
  • Oakbrook Terrace, IL
SQL Server Senior Data Engineer
  • Paul May & Associates
  • Chicago, IL
Microsoft BI Developer (SSIS, SSAS) - Contract to hire
  • Excel Consultants, LLC
  • Chicago, IL
SQL Developer
  • Interactive Business Systems
  • Elk Grove Village, IL
SQL BI Developer (Power BI, SSAS)
  • Key Business Solutions, Inc.
  • Chicago, IL