Business Intelligence Developer Job in New York, New York Us

The Business Intelligence Developer designs and develops computer programs in accordance with the software development life cycle for the Data Warehouse and Business Intelligence platforms.


Essential Duties and Responsibilities: 

·        Consult with clients to analyze and understand functions to be automated, client needs, objectives, desired features, and input and output requirements.

Analyze business requirements to identify and understand source data systems.

Perform data analysis and translate business needs into long-term information architecture solutions.

Conduct data quality analysis to rid system of old, unused, or duplicate data. Assist in the creation of data models, metadata, and reporting structures for better data management and quicker access.

·        Convert designs and specifications into software solutions following programming standards and best practices.

Develop ETL processes, tables, data marts, data models, OLAP cubes, metadata, and reporting structures for better data management and quicker access.

Create DW schema design and ensure optimum database performance.

Identify and streamline routine processes in a fast-paced environment.

·        Perform testing and review of code as required.

Create test scenarios to find errors and confirm program meets specifications. Analyze codes to find causes of errors and revise programs.

Ensure codes meets with standards and best practices.

·        Support production applications.

Monitor performance of production applications and provide necessary support.

Provide technical assistance by responding to inquiries from others regarding errors, problems or questions about programs.

Train any required technical support staff to use, test, and support programs.

Write documentation to support software solutions.

Write and maintain functional and technical specifications.

Write and maintain documentation to describe program development, logic, coding, testing, changes, and corrections.

Write documentation or review documentation written by others which describes installation and operating procedures.

Guide the full life-cycle of software development project.

Manage software development projects.

Maintain project status and related documentation.

Coordinate project related activities, including planning timelines,

scheduling meetings, coordinating resources, and tracking performance.


Other Duties and Responsibilities: 

·        Program Deployment.

Create deployment packages and deployment related documentation. Facilitate the transition of programs from development into production.

·        Analyze, assist installs, and test upgrades of internally/externally developed application programs.

·        Mentor technical team in designs, coding practices, and best overall software development practices.

·        Research and evaluate software and hardware to enhance the development environment and process.


Work Experience/Qualifications:


The employee is required to have at least 3 - 5 years of experience and be able to demonstrate all of the following:

·        Ability to read, analyze, and interpret common business/technical journals, financial reports, and legal documents.

·        Ability to respond to common inquiries or complaints from customers, regulatory agencies, or members of the business community.

·        Ability to effectively present information to top management, client group, and/or user community.

·        Must be able to analyze codes and application programs.

·        Ability to calculate figures and amounts such as discounts, incentives, surcharge, interest, commissions, proportions, and percentages.

·        Ability to use concepts of basic mathematics to resolve business issues.

·        Must be able to define problems, collect data, establish facts, and draw valid conclusions.

·        Must be able to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.

·        Ability to quickly analyze and understand existing dimensional and relational databases, and the ETL process that populate them.

·        Solid experience in designing and coding high-volume ETL applications for efficiency and maintainability.

·        Strong knowledge of dimensional design (star schemas).

·        Strong knowledge of relational database design (normalization).

·        Solid experience coming up with and explaining solution ideas/approaches to complex data and system problems.

·        Excellent written and oral communication skills.

·        Healthcare, Managed Care and/or CSC MHS knowledge.


Education Requirements:                            

The employee is required to possess a Bachelor's Degree.


Technical Skills:                            

The employee is required to posess advanced level skills in SQL and SSIS, as well as intermediate skills in SSRS, SSAS, MDX, and SAS Base.