Senior IT Software Developer

Job Description:
As a Senior IT Software Developer, you will be responsible for architecting and developing business
intelligence (BI) solutions in accordance with enterprise standards and user requirements.
Areas of responsibility include partnering with business users to identify and maximize opportunities to utilize data warehouse to improve business processes; evaluating, planning, designing, and implementing new data marts and data warehouse; delivering insightful, consumable, and actionable reports, scorecards, dashboards, metadata or sematic modelling (cubes), and analytical outputs to improve business performance; ensuring reliability consistency and availability of data warehouse.
Architecting and developing business intelligence (BI) solutions in accordance with enterprise standards and user requirements.
Define and implement technical requirements and data architectures for the data warehouse.
Create technical design and specifications for reports/dashboards.
Design logical data mappings and write SQL queries in Oracle or relevant RDBMS.
Contribute to the design, implementation, support and ongoing enhancement of our data warehouse and data mart environments.
Design and manage the information access and security requirements for the data warehouse.
Define and implement production release requirements.

Required Qualifications:
Bachelor’s Degree in Computer science or related field.
5+ years of work experience in as a lead developer or architect in data analytics design and development.
Experience working with IBM Cognos Analytics, DataStage.
Proficient in SQL, PL/SQL for profiling and analyzing the data.
Proficient knowledge of most common relational databases including Oracle, Microsoft SQL Server, Access, etc.
Knowledge of Data Warehousing, Dimensional Modeling (Star Schema, OLAP Cubes, Advanced Fact, and Dimension Table Techniques, Slowly Changing Dimensions, Bus Matrix Mapping) and various data modeling techniques to support business intelligence applications.
Ability to identify and diagnose database related issues, perform root cause analysis, and recommend corrective actions.
Excellent communication and presentation skills, both verbal and written.

Responsibilities:
Establish the long-term strategy and technical architecture for data warehousing efforts.
Partnering with business users to identify and maximize opportunities to utilize data warehouse to improve business processes.
Define and implement technical requirements and data architectures for the data warehouse.
Create technical design and specifications for reports/dashboards.
Design logical data mappings and write SQL queries in Oracle or relevant RDBMS.
Contribute to the design, implementation, support and ongoing enhancement of our data warehouse and data mart environments.
Design and manage the information access and security requirements for the data warehouse.
Define and implement production release requirements.

PLEASE NOTE: Our client has mandated COVID-19 vaccination for their workforce, all external personnel providing services to our client are required to comply with this requirement.

Compensation Range: $62 to $70.0/hr