Your Role:
Design and develop SSIS Packages to import and export data from MS Excel/Access, SQL Server, Flat files, and various data sources.
Plan, coordinate, develop and support ETL processes including architecting table structure, building ETL packages and provide production support of existing ETL processes.
Create new ETL processes and analyze, enhance, and modify existing SSIS processes. Create application Schema (Database, Tables, Views, and Indexes) and implement various SQL, Transact- SQL statements, stored procedures and UDF (User Defined Functions).
Create dashboards and interactive visual reports using Power BI. Design, develop, test, and deploy Power BI reports and perform detailed analytics.
Perform DAX queries and functions in Power BI. Optimize Power BI Report distribution, execution, and the scalability of all reporting solutions so they are autonomous and dynamic.
Work independently, preparing project status reports & formal presentations as required.
Requires minimum of MS or equiv. in CS, CIS, Comp App, IT-related Engineering, or related.
Extended travel and/or relocation throughout U.S.
Bachelor's degree in Computer Science