Business Intelligence Developer

at  Ashta Tech Solutions Inc

Toronto, ON, Canada - 00000

Start DateExpiry DateSalaryPosted OnExperienceSkillsTelecommuteSponsor Visa
Immediate07 Dec, 2019Not Specified08 Sep, 20194 year(s) or aboveR,Database Design,Performance Tuning,Conversant,Power Bi,Json,Tuning,Cognos,Nosql,Performance Analysis,Salesforce,Java,Olap,Inmon,TableauNoNo
Required Visa Status:
CitizenGC
US CitizenStudent Visa
H1BCPT
OPTH4 Spouse of H1B
GC Green Card
Employment Type:
Full TimePart Time
PermanentIndependent - 1099
Contract – W2C2H Independent
C2H W2Contract – Corp 2 Corp
Contract to Hire – Corp 2 Corp

Description:

DESCRIPTION

Our Downtown Toronto enterprise client is looking for a Business Intelligence Developer. This will be an initial 6-month full-time contract position to start as soon as possible!
Summary: The Business Intelligence Developer is responsible for aggregating data from multiple sources in an efficient data warehouse and designing enterprise-level solutions for very large multidimensional databases. As a BI Developer, you collaborate as part of a team composed of technical leaders representing the enterprise, application, data and network architecture, infrastructure security, and business management leaders.

KNOWLEDGE, SKILLS, AND/OR ABILITIES:

  • Logical and Physical Database Design & Development using best practices for OLTP and OLAP (Kimball, Inmon) systems
  • Experience in complex query techniques and advanced analytical functions
  • Proficient in performance analysis, monitoring and SQL query tuning
  • Hands on experience with Cloud platforms
  • Worked on all phases of software development life cycle
  • Conversant with waterfall and agile methodologies
  • Experience in automating DevOps processes
  • Good knowledge of API technologies (SOAP, REST)
  • Knowledge of BI tools like Cognos, Oracle BI
  • Preferable experience with Phyton, R, Java, JSON
  • Knowledge of NoSQL and distributed systems is a plus
  • Experience in insurance and finance industry preferred
  • Any experience with Salesforce would also be desirable

Education and/or Experience:

  • 6+ years of related experience in data warehousing
  • At least 4 years’ experience using SSIS, SSAS, SSRS
  • BI tools like Tableau, Power BI would be an asset
  • Expert-level SQL coding and performance tuning skill

Responsibilities:

  • Design, develop and Test ETL processes per business requirements
  • Plan deployments, moving from Dev to QA to Production environments
  • Load/extract data from/to multiple data sources including cloud applications (Salesforce.com, Applied Epic, Callidus ICM)
  • Ensure designed systems are reliable, self-recovering and require minimal support
  • Work on troubleshooting data integration errors and identifying the data issues between data sources/targets
  • Research, analyze and define technical problems and recommend alternative solutions
  • Gather reporting and analysis requirements and translate into reporting structured data models, including aggregate tables, pivoted tables, and relational and dimensional (star-schema) data marts.
  • Define and document complex technical design/requirements for integrations and data warehousing
  • Develop /Maintain processes that conduct service calls through APIs that interface with applications on cloud
  • Document all of the following: business requirements, design requirements, and development work

Education and/or Experience:

  • 6+ years of related experience in data warehousing
  • At least 4 years’ experience using SSIS, SSAS, SSRS
  • BI tools like Tableau, Power BI would be an asset
  • Expert-level SQL coding and performance tuning skills

Job Type: Contrac


REQUIREMENT SUMMARY

Min:4.0Max:6.0 year(s)

Information Technology/IT

IT Software - DBA / Datawarehousing

Software Engineering

Graduate

Proficient

1

Toronto, ON, Canada