Diverse Lynx
BI Engineer/Analyst
Diverse Lynx, Iselin, New Jersey, us, 08830
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 server Job 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 team Profiling data and formulating data flows/business logic Documenting/establishing business measures with corresponding criteria. Reconciliation of data across systems and sources Knowledge 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 Model Dax MDX
Power Query M language
Power BI SQL Server Database SQL Excel Pivot tables and power pivot Power Apps Experience developing power apps to augment ingestion of data to SSAS Cubes.
Dot NET Ability to develop C# and Dot NET applications to maintain SSAS metadata and processing plans.
SISS Packages Ability 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 server Job 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 team Profiling data and formulating data flows/business logic Documenting/establishing business measures with corresponding criteria. Reconciliation of data across systems and sources Knowledge 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 Model Dax MDX
Power Query M language
Power BI SQL Server Database SQL Excel Pivot tables and power pivot Power Apps Experience developing power apps to augment ingestion of data to SSAS Cubes.
Dot NET Ability to develop C# and Dot NET applications to maintain SSAS metadata and processing plans.
SISS Packages Ability 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.