Microsoft BI Architect
Job in
Chicago, Cook County, Illinois, 60290, USA
Listed on 2026-06-27
Listing for:
INENT INC
Full Time
position Listed on 2026-06-27
Job specializations:
-
IT/Tech
Data Engineering, Data Warehousing, Data Analyst, Database Administrator
Job Description & How to Apply Below
Position:
Microsoft BI Architect
Job Location:
Chicago, IL
Duration: 12+ months
- Architect, design, and develop & enhance BI solutions including data warehouse
- Using SDLC methodology to perform requirement gathering, functional analysis, technical design, development, testing, and deployment
- Designing, developing, and testing data management matching, merging, consolidation, purging, and cleansing and extraction, transformation, and loading (ETL) functionality
- Apply Microsoft BI expertise in system architecture design and hands on development and maintenance of BI systems
- Designing, building and enhancing data marts, and analytic engines
- Installing, configuring, and, if necessary, customizing analytics management tools
- Designing, developing, maintains, and support all BI reports
- Designing, developing, maintains, and support interface ETL code
- Assist with hardware, software, and data communications architecture and sizing
- Contribute to the development and support of ongoing production services
- Partners with business departmental teams to define and document business requirements
- Create new reports and dashboards
- Queries, analyzes, and interprets complex data stored in the target systems
- Identify data quality issues and see through to resolution
- Test and validate data flow and reports
- 8+ years of working knowledge of architecture, design and development of scalable Business Intelligence solutions for a large data warehouse, using different architecture, design and modeling techniques
- Extensive knowledge of database management systems, replication concepts, data warehouse systems and business intelligence tools
- Understanding of SQL Server 2012, SSIS, SSRS, SSAS including dimensional Modelling, SharePoint BI Integration, Administration of Servers
- Advanced grasp of Relational database design and Multidimensional & Tabular design concepts
- 5+ years of experience in data movement/ETL concepts and tools like Microsoft SSIS, SSRS, and/or SSAS including programming languages like T‑SQL, PL/SQL etc. is desired
- 5+ years of experience of building impactful reports and dashboards using major BI toolsets.
- Experience in developing IT architecture plans and software development methodologies, collaboration and leadership
- Must be able to provide simplified and standardized solutions to achieve the business objectives
- Well versed with database administration tasks, SQL and MDX concepts
- Keep current with Business Intelligence best practices and operational requirements
- Strong analytical, multi-tasking and problem solving skills along with strong communication and teak work skills
- Mentor and train BI team resources in the Microsoft BI technology stack and best practices
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×