Microsoft BI Architect

INENT INC; Chicago (IL); On-site; USD 120,000 - 150,000; Full time

Job summary

INENT INC is looking for a Microsoft BI Architect in Chicago, IL. The role involves architecting and enhancing Business Intelligence solutions, including data warehouse development and maintenance. Applicants should have 8+ years of experience in BI architecture, proficiency in SQL Server, and skills in ETL tools like SSIS and SSRS.

This is an opportunity to impact reporting and analytics, working closely with business teams to deliver solutions tailored to their needs. Candidates with strong analytical and communication skills are encouraged to apply.

Qualifications

• 8+ years of experience in BI architecture and development.
• Extensive knowledge of SQL Server and BI tools.
• Strong analytical and problem-solving skills.

Responsibilities

• Architect and enhance BI solutions including data warehouse.
• Conduct requirement gathering and functional analysis.
• Develop, maintain, and support BI reports and dashboards.

Skills

Business Intelligence solutions

SQL Server 2012

ETL tools (SSIS, SSRS, SSAS)

Data warehouse systems

Database management systems

Data quality resolution

Business requirements documentation

Job description

Position: Microsoft BI Architect
Job Location: Chicago, IL
Duration: 12+ months

Responsibilities

• 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

Qualifications

• 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