job summary: As a BI Analyst, you will gather/create technical requirements, identify opportunities for process improvements and enhancements, and provide production support to ensure data is consistent and accurate. The ideal candidate will have experience utilizing ETL, BI, and data modeling tools as well as have experience with relational databases. location: Niles, Illinois job type: Permanent salary: $85,000 - 110,000 per year work hours: 8am to 5pm education: Bachelors responsibilities: We're seeking a Senior Business Intelligence Analyst who will be responsible for all technical aspects related to the full life cycle of implementing BI solutions. This includes business requirement analysis, functional design, technical design, development and on-going activities related to support of the legacy data warehouse systems. This role will provide customers with timely and accurate information required to make informed decisions using Business Intelligence and Operational reporting tools. The Senior BI Developer/Analyst will also play a key role in guiding the evolution of our systems and the data warehouse, participating in various tasks in architecture design and planning. Responsibilities: BI Operational Design and Development Configure and implement BI solutions by applying information and data presentation architectures using Business Intelligence and Operation Reporting related tools.Perform analysis, development and data mining in a data warehouse environment that includes data design, database architecture, metadata, and repository creation.Create technical documentation, including requirements specifications, gap/fit analysis, design specifications, unit test plans, and deployment instructions.Maintain documentation of the BI solutions deployed across the enterprise.Work with business users to understand their needs and offer guidance and recommendations to achieve intended results.Provide ad hoc and standard reports, dashboards, data extracts and analyses to drive business value and efficiency. ETL Batch Design and Development Automate the flow and aggregation of data into and between repositories utilizing ETL tools and data loading patterns for standardization of technical design.Identify areas of process improvement and automating manual processes reducing impact on business systems. Production Support Provide production support of nightly batch job streams ensuring data consistency and accuracy of loaded information.Participated in overnight and weekend on call support rotation resolving business outages or impacts as needed.Closely monitors batch stream performance meeting or exceeding load service levels for business systems data availability.Provides support for business systems identifying opportunities for enhancements to features and processes. Requirements: Bachelor's degree in IS or related field or equivalent combination of education and experience.5+ years of experience in MicroStrategy or similar BI tools (modeling, report and dashboard authoring, ad-hoc analytics, visualizations, architecture, and administration).5+ years of experience in design and build of data management solutions.5+ years of experience with relational databases (SQL, PL/SQL or T-SQL).Experience with ETL and tools such as SSIS, Informatica, Talend, Data Stage etc.Experience with Data Modeling and tools such as Erwin or Visio.Highly analytical with first-rate conceptual and reporting skills.Extensive knowledge of business intelligence best practices, visualization, processes, and methodologies.Demonstrated ability to effectively perform all phases of projects. Preferred Qualifications: Knowledge of Microsoft BI stack (SSRS, Power BI, SSAS, and SQL Server).Experience using Agile BI development principles and processes.Knowledge of data, master data and metadata related standards, processes, and technology. qualifications: Experience level: ExperiencedMinimum 4 years of experienceEducation: Bachelors skills: Business IntelligenceSQLSSIS Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status. At Randstad, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com. For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information