BI Engineer
at Apptad Inc
Montréal, QC, Canada -
| Start Date | Expiry Date | Salary | Posted On | Experience | Skills | Telecommute | Sponsor Visa |
|---|---|---|---|---|---|---|---|
| Immediate | 18 Apr, 2025 | USD 80 Hourly | 18 Jan, 2025 | 3 year(s) or above | Query Optimization,Data Warehousing,Data Warehouse,Reporting,Sql Server,Fixed Income,Analytics,Sql,Communication Skills,Business Intelligence,Data Modeling,Relational Databases,User Requirements,Dax,High Pressure Environment,Interpersonal Skills | No | No |
Required Visa Status:
| Citizen | GC |
| US Citizen | Student Visa |
| H1B | CPT |
| OPT | H4 Spouse of H1B |
| GC Green Card |
Employment Type:
| Full Time | Part Time |
| Permanent | Independent - 1099 |
| Contract – W2 | C2H Independent |
| C2H W2 | Contract – Corp 2 Corp |
| Contract to Hire – Corp 2 Corp |
Description:
JOB SUMMARY:
We are seeking highly skilled Business Intelligence / Reporting Engineer with a robust background in SQL and data warehousing for enterprise-level systems. The ideal candidate must possess strong Power BI skills, particularly in developing dashboards and canned reports. The role involves designing and developing reports, dashboards, and ad-hoc queries. The candidate should be comfortable collaborating with business users and exhibit business analyst expertise.
MUST-HAVE SKILLS:
- Data modeling using Power Query/Power Pivot.
- Proficiency in DAX.
- Experience with Power BI Report Builder and/or Paginated Reports.
- Strong SQL skills, particularly with SQL Server or similar relational databases.
NICE-TO-HAVE SKILLS:
- Working knowledge of Data Flows.
- Experience with PBRS (Power BI Report Server).
- Familiarity with Power On.
- Experience with Snowflake data warehouse.
QUALIFICATIONS:
- Minimum of 7+ years of combined experience in data warehousing, business intelligence, analytics, and reporting systems.
- At least 3+ years of experience in relational and multi-dimensional (OLAP) data modeling.
- Proficiency in SQL, including relational and dimensional database structures and query optimization.
- Strong knowledge of Fixed Income, Equity, and Derivative businesses.
- Ability to analyze user requirements, make recommendations, and implement solutions.
- Self-driven with the ability to troubleshoot and provide quick resolutions to issues.
- Experience with full project management and development life cycle.
- Strong oral and written communication skills.
- Strong presentation and interpersonal skills.
- Ability to prioritize and manage tasks in a high-pressure environment.
Job Type: Fixed term contract
Pay: $80.00-$85.00 per hour
Experience:
- Business intelligence: 10 years (preferred)
- DAX: 8 years (preferred)
- SQL: 5 years (preferred)
Responsibilities:
- Design and develop reports, dashboards, and ad-hoc queries.
- Collaborate with business users to understand and meet their requirements.
- Utilize data modeling techniques using Power Query/Power Pivot.
- Develop and optimize DAX queries.
- Use Power BI Report Builder and/or create Paginated Reports.
- Manage and query SQL Server or any other relational databases.
REQUIREMENT SUMMARY
Min:3.0Max:10.0 year(s)
Information Technology/IT
IT Software - DBA / Datawarehousing
Software Engineering
Graduate
Proficient
1
Montréal, QC, Canada
