• Senior Developer - Business Intelligence

    Location US-NY-Long Island City
    Category
    Information Technology & Security
  • Overview

     

    Develops robust Business Intelligence and data warehouse solutions using SSAS, SSRS, MS SQL Server and other BI technologies. Supports reports development and maintenance. Participates in requirements gathering and research, proposes technology solutions, and develops solutions within agreed upon timelines.

     

     

    Responsibilities

    • Design, develop, deploy and maintain reports on SSRS.
    • Desing, develop, deploy and maintain dimensional models in SSAS cube and tabular model.
    • Analyze, design, and develop ETL packages on SSIS.
    • Design and develop dashboard on Power BI and/or Tableau.
    • 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.
    • Coordinate activities and maintain extensive communication with appropriate IT staff and UNFCU staff.
    • 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 other duties related to general employment and technical responsibilities, as requested by management. 

    Qualifications

     

     

    TYPE & AMOUNT OF EXPERIENCE:

    • Bachelor’s degree in Engineering or Computer Science and at least 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 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
    • 1 year of development experience in SharePoint
    • 1 year of working knowledge on MDX and DAX query language
    • 1 year of supporting a Data Warehouse environment
    • 1 year experience using Oracle PL/SQL
    • Exposure to maintaining code/scripts in TFS for multiple environments
    • Exposure to Cloud technology like Microsoft Azure
    • Exposure to Big Data Technologies like MangoDB, NoSQL
    • Exposure to DBA activities like database backup and restore
    • Hands on working experience in Linux/Unix Environment
    • Knowledge of financial/banking industry

     

    TECHNICAL COMPETENCIES:

    • Extensive software design and development knowledge
    • Strong reporting and data warehouse development skills on issues that are complex and evaluative in nature where troubleshooting may call for referencing an advanced knowledge base
    • Large data migration experience
    • Hands on experience using Oracle
    • Data cleansing and transformation for complex industry specific standards
    • Data encryption tools and standards
    • Exposure to XML
    • Exposure to Web Services 

    BEHAVIORAL COMPETENCIES:

    • Strong analytical ability/problem solving skills
    • Ability to work independently and within a team environment to complete assigned projects in a timely manner
    • Strong interpersonal, verbal and written communication skills
    • Able to multi-task, taking on several initiatives at once 

    WORK ENVIRONMENT/CONDITIONS:

    • Standard office conditions
    • May require work on weekends or other extended hours
    • Critical system outages and system upgrades may require 24/7 coverage on short notice

     

     

    In addition to any specific job requirements in connection with Bank Secrecy Act and/or OFAC (BSA), employee must (i) be aware of BSA matters commensurate with the position; (ii) report any suspicious activity to the manager or compliance department; and (iii) satisfactorily complete any required BSA training.

     

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed