What are the responsibilities and job description for the MSBI Developer position at Symbioun Technologies, Inc?
Job Details
Seeking an experienced MSBI Developer to design and develop data systems using Microsoft BI tools. The role involves automating data collection, building ETL processes, and developing data warehouses and analytical cubes. Responsibilities include:
Creating database objects and schemas for fiscal data systems.
Automating data collection from FTP sources (CSV, Excel).
Developing ETL processes and SSIS packages with error handling.
Writing complex T-SQL queries for data transformations.
Building OLAP cubes and Data Marts for reporting.
Optimizing queries and troubleshooting data issues.
Qualifications:
5 years of experience with SQL Server, T-SQL, SSIS, SSAS, and BI reporting tools.
4 years of ETL development
Strong background in data warehousing and dimensional modeling.
Experience in the fiscal/finance industry
Skills: MSBI (SSIS, SSAS, SSRS, Power BI), Data Warehousing, ETL, Dimensional Modeling, Data Analysis, and Troubleshooting.