Hello
Hope you are doing well
Position – BI / SQL / PowerBI Developer/Engineer
Location – Rosemont, IL (Onsite)
Clients – Hexaware / Wintrust
Visa: Only H1B or H4EAD with Passport Number
Experience: 12+ Years
Job Description,
- 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.
