BI Analytics Technical Lead

Integrated Resources Inc.; Hickory (NC); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading company in strategic workforce solutions seeks an Information and Analytics Technical Lead in Hickory, NC. The role demands extensive expertise in the Microsoft BI Stack, SAP BW, and the ability to manage data modeling, implementation methodologies, and stakeholder communication to deliver exceptional BI solutions.

Qualifications

• 8+ years of experience in architecting, designing, developing BI solutions.
• Expert in Microsoft BI stack (SQL Server, SSAS, SSRS, Power BI).
• Experience with SAP BW for information and analytics a must.

Responsibilities

• Manage BI implementation methodologies and technical leadership.
• Translate business requirements into optimal technical solutions.
• Design and support SSRS reporting platform with advanced data modeling.

Skills

Business intelligence

Data warehousing

MDX

DAX

SQL Server

SAP BW

Power BI

Tableau

Education

BA/BS degree in computer science, information technology, engineering or related field

Tools

Microsoft BI Stack (SSIS, SSRS, SSAS)

Google Analytics

Informatica

Dell Boomi ETL

Job description

Integrated Resources, Inc., is led by a seasoned team with combined decades in the industry. We deliver strategic workforce solutions that help you manage your talent and business more efficiently and effectively. Since launching in 1996, IRI has attracted, assembled and retained key employees who are experts in their fields. This has helped us expand into new sectors and steadily grow.

Job Description

Role Description

The Information and Analytics Technical Lead must have a firm grasp of industry standard BI implementation methodologies, as well as in-depth experience with the Microsoft BI Stack (SSIS, SSRS and SSAS) version 2008 and above. They must have experience working in a technical leadership and support role as well as the following:

Technical Skills:

· Expert in multidimensional data modeling concepts and design

· Business intelligence/data warehousing technology skills with proven expertise in Microsoft BI stack (SQL Server, SSAS, SSRS, Power BI, and TFS)

· In-depth knowledge of building complex multidimensional/tabular cubes and querying them using MDX/DAX (Microsoft SSAS)

· Experience in fine tuning the performance of SSAS cubes (tabular or multidimensional)

· Expert in design, development, and support of SSRS reporting platform

· Advanced experience with ETL/data integration methodologies and patterns (Microsoft SSIS)

· Experience with SAP BW development and maintenance

· Proficiency in Google Analytics; Google Analytics Certification preferred

· Proficiency in Successfactors reporting / Work Force Analytics

· Experience with Tableau reporting platform

· Good knowledge of Oracle and SQL database technologies

· Knowledge of Informatica and Dell Boomi ETL platform a plus

Analysis and Communication Skills:

· Ability to translate business requirements into technical specifications to design and deliver optimum solutions for business needs.

· Strong communication skills and a strong self-starter attitude.

· Strong business analyst skills, able to work with many different stakeholders to elicit and document requirements.

· Strong estimation skills and strong track record of accurate estimations for BI solutions.

· Analytical thinker; Strong problem solving ability

· Team player; Ability to multi task

· Data gathering, research and analytical abilities so as to develop insightful conclusions and generate solutions to address user needs

Other Requirements:

· BA/BS degree in computer science, information technology, engineering or related field

· 8+ years of experience in architecting, designing, developing, supporting, and implementing BI solutions

· Excellent understanding of developer and support processes including SDLC, project management, change management, and architecture process.

· Knowledge of ITIL is desired

Manager Must Haves

· Proven experience with SAP BW data sources in Business Intelligence delivery

· Previous experience in Business Intelligence/Data Warehousing technology using Microsoft BI stack (SQL Server, SSAS, SSRS, Power BI, and TFS).

· Prior experience with SAP BW (especially SAP data sources) for information and analytics is REQUIRED

Qualifications

Manager Must Haves

· Proven experience withSAP BW data sources in Business Intelligence delivery

· Previous experience inBusiness Intelligence/Data Warehousing technology using Microsoft BI stack (SQL Server, SSAS, SSRS, Power BI, and TFS).

· Prior experience withSAP BW (especially SAP data sources)for information and analytics is REQUIRED

· 8+ years of experience in architecting, designing, developing, supporting, and implementing BI solutions