Data Analyst/BI Developer

Menands, NY, US • Posted 12 hours ago • Updated 8 hours ago
Full Time
On-site
USD 50.00 per hour
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Data Quality
  • Collaboration
  • Data Integrity
  • Workflow
  • Continuous Improvement
  • Microsoft Exchange
  • Extract
  • Transform
  • Load
  • FOCUS
  • Data Modeling
  • Data Marts
  • Data Warehouse
  • OLAP
  • Business Intelligence
  • Data Visualization
  • Dashboard
  • RTC
  • ELM
  • Database Architecture
  • Snow Flake Schema
  • RDBMS
  • PL/SQL
  • SQL
  • Profit And Loss
  • IBM DB2
  • Unix
  • Linux
  • Operating Systems
  • Writing
  • Management
  • Analytical Skill
  • Problem Solving
  • Conflict Resolution
  • Communication
  • Mapping
  • Reporting
  • Budget
  • Forecasting
  • Forms
  • Documentation
  • IBM Cognos Analytics
  • Database
  • Java
  • Data Architecture
  • Data Analysis
  • PMBOK
  • Health Care
  • Computer Science
  • Mathematics
  • TCM
  • DICE

Summary

JOB TITLE: Data Analyst/BI Developer
JOB LOCATION: Menands, NY - Hybrid
WAGE RANGE*: $50hr to $55hr w2
JOB NUMBER: 26-01289

REQUIRED EXPERIENCE:


Business Intelligence (BI), Data Analysis, Data Mart, Structured Query Language (SQL) Development
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)

JOB DESCRIPTION
  • You will 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.
  • Work closely with functional teams to understand requirements regarding solutions to ensure data quality. Collaborate on definition, development, and maintenance of standards and processes.
  • 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


Required Experience: NO MORE than 5 years of experience will be accepted
  • 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


Required Technical Skills:
  • Strong understanding of OLAP business intelligence applications
  • 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 that will be used to implement required reports and dashboards
  • 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


Required Skills and Abilities:
  • Good verbal, writing/documentation, communication, organizational, and time management skills
  • Strong analytical, problem solving and communication skills, including mapping of business need or issue to development of application requirements or procedural initiatives.
  • Strong understanding of reporting and database environments, processes, and associated applications.
  • Well-developed knowledge of operational systems, processes and budgeting/forecasting concepts and activities
  • Proven ability to ensure effective forms of documentation essential for support of overall technical and user needs.
  • Ability to work in complex matrix organization.


Preferred Skills:
  • 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


Education:

Bachelor's degree in Business, Computer Science, Mathematics, Engineering, or related discipline, or equivalent

Equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities

* While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions. Benefits offered are in accordance with applicable federal, state, and local laws and subject to change at TCM's discretion.

#Dice
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: cxtcml
  • Position Id: 26-01289
  • Posted 12 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Hybrid in Albany, New York

Today

Easy Apply

Contract, Third Party

Depends on Experience

Albany, New York

Today

Full-time

USD 100,000.00 - 110,000.00 per year

Virginia

Today

Full-time

USD 75,000.00 - 95,000.00 per year

Remote

Today

Full-time

Search all similar jobs