ETL Developer

• Analyze, design, and develop ETL packages on SSIS.  
• Design, develop, deploy and maintain reports on SSRS. 
• Some exposure to Designing and developing dashboard on Power BI and/or Tableau. 
• Design, develop, deploy and maintain dimensional models in SSAS cube and tabular model is a plus.  
• Evaluate, design, propose, and secure approval for all design and implementation. 
• Evaluate, design, and maintain multiple database environments; identify data sources, construct data decomposition diagrams, provide data flow diagrams and document the process; write codes for database access, modifications and constructions including stored procedures and database server configuration. 
• Develop and maintain procedures and scripts for recreating the database environment and databases for disaster recovery purposes and business continuity strategy. 
• Develop complex Script tasks (using C# or VB.NET) in SSIS to handle File System Objects.  
• Design, develop, and integrate reporting/dashboard solutions on MS SharePoint. 
• Administer database systems technical design, performance monitoring and tuning, backup and recovery, data and file distribution, reporting, database upgrades, integrations, migrations and conversions. 
• Design and implement OLTP and OLAP data models. 
• Develop and maintain database administration procedures and operations; cross train on, and provide operational support of, procedures. 
• Design, implement, and support data warehousing - implement business rules via stored procedures, middleware or other technologies; define user interfaces and functional specifications. 
• Responsible for verifying accuracy of data in dashboards, reports, data extracts and data warehouse. 
• Monitor system details within the data warehouse, including stored procedures and execution time, and implement efficiency improvements. 
• Troubleshoot and resolve data quality issues, database performance issues, database capacity issues, replication and other distributed data issues. 
• Resolve database performance issues by looking at query plans, create appropriate indexes, resolve dead locks and create table hints. 
• Troubleshoot and resolve issues in reports, dashboards and ETL packages. 
• Closely work with other IT teams including Analysts and Product Managers to troubleshoot, modify and enhance existing BI assets. 
• Develop, implement, and maintain change control and testing processes for modifications to databases. 
• Participate in assigned roles in project teams. 
• Follow the organization’s data protection and network securities and antivirus policies. 
• Stay abreast of industry trends, and attend training, conferences and seminars according to organization’s business requirements. 
• Participate in Credit Union training and development programs. 
• Perform additional responsibilities as assigned. 

What we''re seeking

• Bachelor’s degree in Engineering or Computer Science  
• 6 years of experience in reports and data warehouse development 
• 5 years software development experience on Microsoft BI Platform – SSAS, SSRS, MS SQL Server  
• 4 years of experience in DB Development using MS SQL 
• 2 years of experience using Oracle Business Intelligence tools 
• 2 years of experience in Data Migration from various systems to SQL Server Database 
• 2 years of experience in building Data Marts using dimensional models 
• 2 years of experience in building Dashboards and KPI visualization on Power BI and/or Tableau 
• 2 years of supporting a Data Warehouse environment   
• 1 year experience using Oracle PL/SQL  

PLUS TO HAVE

• Knowledge of Data encryption tools and standards 

• Experience in the following areas: 

• Maintaining code/scripts in TFS for multiple environments 

• Cloud technology like Microsoft Azure. 

• Data Technologies like MongoDB, NoSQL, SnowFlake, DataBricks.  

• DBA activities like database backup and restore. 

• Hands on working experience in Linux/Unix Environment. 

• XML 

• Web Services 

• Knowledge of financial/banking industry