Data Analyst / BI Developer[Hybrid]-(Relocation open]- W2 ROLE Job at SmartIPlace, Albany, NY

  • SmartIPlace
  • Albany, NY

Job Description

W2 ROLE Data Analyst / BI Developer

Location: Albany, NY

Work Mode: Hybrid; local Albany candidates preferred

Job Type: Contract-to-Hire (CTH)

Visa: USC or GC

Experience: 2 4 years preferred; maximum 5 years accepted

Position Overview

We are seeking a Data Analyst / BI Developer to support Business Intelligence, data analysis, reporting, data visualization, and data integration initiatives. The ideal candidate will have hands-on experience with SQL, IBM DB2, Cognos, data modeling, Data Mart/Data Warehouse, and BI reporting .

This is a mid-level opportunity , and candidates with significantly more than 5 years of experience will not be considered.

Key Responsibilities
  • Develop and maintain BI reports, dashboards, and data visualization solutions.

  • Analyze data to identify patterns, anomalies, trends, and data-quality issues.

  • Translate business requirements into technical specifications for reports and dashboards.

  • Write complex SQL queries and SQL PL procedures in an IBM DB2 environment.

  • Design and develop Data Mart/Data Warehouse models.

  • Create dashboards supporting drill-down, drill-up, slicing, and dicing of data.

  • Author and maintain reports using IBM Cognos Analytics.

  • Support ETL, data integration, data exchange, and automation initiatives.

  • Collaborate with functional teams to understand requirements and ensure data quality.

  • Develop reusable templates and models to improve data integrity and workflow efficiency.

  • Produce ad hoc reports based on business requirements.

  • Support continuous improvement and automation of BI solutions and processes.

  • Work with upstream and downstream enterprise applications throughout the dashboard development lifecycle.

  • Maintain technical and user documentation.

Required Qualifications
  • Bachelor's degree in Business, Computer Science, Mathematics, Engineering, or a related discipline, or equivalent experience.

  • 2+ years of related experience.

  • Maximum 5 years of total experience accepted.

  • Strong experience with SQL, PL/SQL, SQL PL, and IBM DB2 .

  • Experience with a Business Intelligence/BI reporting tool; IBM Cognos preferred .

  • Experience with Data Mart/Data Warehouse design and data modeling .

  • Strong understanding of OLAP and Business Intelligence applications .

  • Experience with reporting and database environments.

  • Knowledge of relational, star, and snowflake schemas .

  • Experience with DB2 or other RDBMS platforms.

  • Experience working with UNIX/Linux environments.

  • Strong analytical, problem-solving, communication, documentation, and organizational skills.

  • Ability to translate business needs into technical requirements.

Preferred Skills
  • IBM Cognos Analytics 12.1.0 or higher.

  • Experience authoring and maintaining Cognos reports against relational, dimensional, and transactional databases.

  • Experience with Core Java .

  • Data architecture and data analysis experience.

  • Experience with ETL and data integration .

  • Knowledge of RTC/ELM or similar tools .

  • Healthcare industry experience.

  • Familiarity with PMI standards and practices .

  • Experience working in a complex matrix organization.

  • Bilingual English/Spanish skills.

Job Tags

Contract work, Local area, Relocation

Similar Jobs

Confidential

Senior Manager, P&O Business Partner Job at Confidential

Job Description: The P&O Business Partner, Demand COE and 3D serves as the lead strategic partner to senior leaders across the MSNA Demand COEHuman Intelligence, PESO, and Capabilitiesand 3DDCOM, Digital, and Data. Reporting to the Sr. Director, P&O One Demand, this...

Stewart Facility Services

Part-Time Evening Cleaner - $14 to $15.50/hour Job at Stewart Facility Services

 ...Looking for part-time evening and/or weekendwork in the Pell City area?We're hiring to add to our Cleaning Crewto help maintain...  ...facilities for our customers. Starting Pay: $14.00$15.50/hour Training Provided | Raise & Bonus Opportunity After 60 Days... 

SGS Consulting

Occupational Heath Nurse Job at SGS Consulting

 ...patient medications and update as needed. ;Provide comprehensive education and direct patient care, particularly around chronic ....  ...patient education skills Clinical Focus: Patient education on diabetes and cardiovascular disease Positive attitude Strong... 

Offit Kurman

Commercial Litigation Attorney - Counsel Job at Offit Kurman

 ... Commercial Litigation (Tysons Corner or Bethesda) Offit Kurman, an Am Law 200 firm, is seeking a senior commercial litigation attorney at the Counsel or Junior Partner level to join our Tysons Corner, VA or Bethesda, MD office. This is a lead-litigator role designed... 

Ernst & Young

Forensics - Insurance and Federal Claims Services - Insurance Adjuster - Manager Job at Ernst & Young

 ...help to build a better working world. EY's Forensics Insurance and Federal Claims Services practice specializes in helping clients achieve...  ...claims professional with a background in commercial claims adjusting to join our practice as a Manager. This role is ideal for...