BI Analyst

About the Role

Deliver solutions to complex problems as a Data Analyst/BI Developer. Tailor solutions to the unique requirements of clients. Join a team in partnership with New York State of Health (NYSoH) to provide comprehensive health coverage.

Key Responsibilities

• Work on a small dynamic team that provides strategic know-how through Business Intelligence (BI) and Data Visualization platforms to deliver quality reports for State & Federal Agencies.
• Apply an understanding of business metrics and a commercial mindset to perform Data analysis, find patterns, data anomalies, and review.
• Collaborate with functional teams to understand requirements regarding solutions and ensure data quality.
• Develop models and create templates to ensure timely and accurate deliverables, data integrity, efficient workflow, reusability, and automation.
• Create dashboards using workspace advance to facilitate drill up/down and slicing/dicing of data.
• Produce Ad Hoc reports with a turnaround time based on business needs.
• Support continuous improvement and automation in BI solutions and processes.
• Support client data exchange and integration needs by leveraging technical expertise in database applications, ETL processes, and automation.
• Apply knowledge of upstream and downstream Enterprise applications to support dashboard development lifecycle discipline.

Requirements & Tech Stack

• SQL, PL/SQL, SQL-PL in DB2
• BI tool ( Cognos is preferred)
• Design/data modeling for Data Mart/Data Warehouse
• OLAP business intelligence applications
• Reporting and database environments, processes, and associated applications
• Data visualization tools
• RTC/ELM or similar tools
• Database architecture (relative, star and snowflake schemas)
• DB2 (or other RDBMS)
• Level 3 Procedural Languages (i.e.: ANSI, SQL, PL/SQL)
• Writing complex SQL queries, SQL PL procedures in IBM DB2 environment
• UNIX/LINUX operating systems

Qualifications

• Bachelor’s degree in Business, Computer Science, Mathematics, Engineering, or related discipline, or equivalent.
• Three (3) years of industry experience with focus on SQL, PL/SQL, SQL-PL in DB2.
• Three (3) years’ experience with a BI tool ( Cognos is preferred).
• Two (2) years of experience in design/data modeling for Data Mart/Data Warehouse.
• Strong understanding of reporting and database environments, processes, and associated applications.
• Competencies leveraging data visualization tools for senior management and enterprise data visualization.
• Ability to translate business requirements into specifications.
• Knowledge of RTC/ELM or similar tools.
• Competencies in database architecture such as relative, star and snowflake schemas.
• Competencies in DB2 (or other RDBMS).
• Level 3 Procedural Languages (i.e.: ANSI, SQL, PL/SQL).
• Writing complex SQL queries, SQL PL procedures in IBM DB2 environment.
• Competencies with UNIX/LINUX operating systems.
• Good verbal, writing/documentation, communication, organizational, and time management skills.
• Strong analytical, problem solving and communication skills.
• Well-developed knowledge of operational systems, processes and budgeting/forecasting concepts and activities.
• Proven ability to ensure effective forms of documentation.
• Ability to work in a complex matrix organization.

Preferred Qualifications

• Experience with IBM Cognos Analytics 12.1.0 or higher.
• Experience authoring and maintaining reports using IBM Cognos Analytics 12.1.0 or higher against relational, dimensional, and transactional databases.
• Experience with Core Java.
• Hands-on experience with data architecture and data analysis skill sets.
• Familiarity with PMI standards and practice.
• Healthcare Industry experience.

Location: Albany, NY

Job Type: Full-Time

Target Salary Range: $70,000 - $80,000

Security Clearance: No clearance— must be US Citizen or Green Card holder.