Diverse Lynx
BI Engineer/Analyst
Diverse Lynx, Rosemont, Illinois, United States,
Role:
BI Engineer/Analyst
Location: Rosemont, IL(Onsite)
Duration: Contract/FTE
NOTE:Main emphasis is on SSAS Tabuler cube, candidate must have minimum of 2/3 real life SSAS cube implementation experience and he/she has to articulate those experience well. Candidate must be at 4/5 minimum.Next emphasis would be PowerBI in an advanced level like DAX, Power Query etc. Candidate must be at 3.4/5 minimum.Last but most important is SQL Server and TSQL experience with SQL performance tuning/troubleshooting skills for some slow performing reports and dashboards.Don't neeed profiles without SSAS Tabuler cube, PowerBI and SQL serverJob Description:
Responsibilities:
Gather, structure, and analyze data from multiple complex data sources into actionable business insights using industry standard analytical tools and technologies.Collaborate with a team of data architects, data engineers for gathering, structuring, and analyzing data to support organizational needs and support the development and automation of standard data analysis.Partner with the analytics reporting team to identify the appropriate data sources and analysis methodology to meet business needs with strong financial business acumen.Presenting the results of the data analysis, as well as recommendations, to management and analytic reporting teamProfiling data and formulating data flows/business logicDocumenting/establishing business measures with corresponding criteria.Reconciliation of data across systems and sourcesKnowledge of database management and file access methods and analytical processing. Highly experienced on working with SQL Server.Strong knowledge and understanding of normalized and star-schema (dimensional) physical models and logical modeling concepts.Skills & Technology:
MUST be highly skilled and experienced in:
SQL Server Analysis Services (SSAS) - Create Tabular ModelDaxMDX
Power QueryM language
Power BISQL Server DatabaseSQLExcelPivot tables and power pivotPower AppsExperience developing power apps to augment ingestion of data to SSAS Cubes.
Dot NETAbility to develop C# and Dot NET applications to maintain SSAS metadata and processing plans.
SISS PackagesAbility to develop SSIS packages to augment ingestion of data and automate processing of SSAS Cubes.
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
BI Engineer/Analyst
Location: Rosemont, IL(Onsite)
Duration: Contract/FTE
NOTE:Main emphasis is on SSAS Tabuler cube, candidate must have minimum of 2/3 real life SSAS cube implementation experience and he/she has to articulate those experience well. Candidate must be at 4/5 minimum.Next emphasis would be PowerBI in an advanced level like DAX, Power Query etc. Candidate must be at 3.4/5 minimum.Last but most important is SQL Server and TSQL experience with SQL performance tuning/troubleshooting skills for some slow performing reports and dashboards.Don't neeed profiles without SSAS Tabuler cube, PowerBI and SQL serverJob Description:
Responsibilities:
Gather, structure, and analyze data from multiple complex data sources into actionable business insights using industry standard analytical tools and technologies.Collaborate with a team of data architects, data engineers for gathering, structuring, and analyzing data to support organizational needs and support the development and automation of standard data analysis.Partner with the analytics reporting team to identify the appropriate data sources and analysis methodology to meet business needs with strong financial business acumen.Presenting the results of the data analysis, as well as recommendations, to management and analytic reporting teamProfiling data and formulating data flows/business logicDocumenting/establishing business measures with corresponding criteria.Reconciliation of data across systems and sourcesKnowledge of database management and file access methods and analytical processing. Highly experienced on working with SQL Server.Strong knowledge and understanding of normalized and star-schema (dimensional) physical models and logical modeling concepts.Skills & Technology:
MUST be highly skilled and experienced in:
SQL Server Analysis Services (SSAS) - Create Tabular ModelDaxMDX
Power QueryM language
Power BISQL Server DatabaseSQLExcelPivot tables and power pivotPower AppsExperience developing power apps to augment ingestion of data to SSAS Cubes.
Dot NETAbility to develop C# and Dot NET applications to maintain SSAS metadata and processing plans.
SISS PackagesAbility to develop SSIS packages to augment ingestion of data and automate processing of SSAS Cubes.
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.