US Citizen or Green Card --- ONLY!!!
Onsite day 1
We need 3 Senior PowerBI / SQL Developers, for Denver based Fintech. You should excel in working with large-scale applications and frameworks and have outstanding communication and leadership skills...of course. LOL
Role and Responsibilities:
- Design and develop database objects, tables, stored procedures, views, triggers and SSIS packages
- Design and develop ETL Processes that will transform a variety of raw data, flat files, xl spreadsheets into SQL Databases
- Uses Multi-Dimensional Expression (MDX) query language to extract data from OLAP cubes for reporting and analytical purposes
- Experience coding complex stored procedures (using T-SQL)
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues etc.
- Design and develop enterprise and departmental business intelligence and data warehousing solutions
- Understands the concept of Data marts and Data lakes and experience with migrating legacy systems to data marts/lake
- Uses additional cloud technologies (e.g. understands concept of Cloud services like Azure SQL server)
- Uses SQL Server Analysis Services to enhance existing, or develop new, OLAP cubes used in the EDW system