**Job no**: 565383
**Work type**: Full time
**Location**: Bogota, Colombia, Buenos Aires, Argentina, Mexico City, Mexico, San Jose, Costa Rica, San José - Santa Ana, Costa Rica, Toronto, Canada, USA- Remote
**Categories**: Information Technology
**Office Location**: Canada - Toronto
**About TMF**
- TMF Group helps its clients operate internationally and 'belong' wherever they are in the world. Our work includes helping companies of all sizes with business services such as HR and payroll, accounting and tax, corporate secretarial, global governance and administration and fiduciary services for structured finance, private equity and real estate investments.
We are looking for self-starters with the skills necessary where you will be directly responsible for addressing business needs through requirements gathering and collaborating on solution reviews to develop end-to-end data solutions including but not limited to data modeling, data delivery pipelines, data visualization, and working through complex problems and solutioning using agile development methodology. We are looking for a BI Engineer who is an ideal team player.
**Here's what a typical day for you might look like**:
- Designs, develops, deploys, and supports sustainable BI solutions such as dashboards, scorecards, and various other forms of data visualization using Power BI or Tableau
- Build wireframes, Proof of Concepts (POC), Minimal Viable Product (MVP), and produce compelling and interactive dashboards
- Designing, developing, and deployment of SQL Server Reporting Services (SSRS) reports
- Build data extraction ETL/ELT pipelines for data required for report or dashboard development
- Data extraction from various forms of data file formats, various databases, and REST API
- Perform extraction, transformation, and loading (ETL) OR extraction, loading, and transformation (ELT) of data from a wide variety of data sources using various data engineering tools and methods into a data lake storage or data warehouse.
- Build reusable datasets and models
- Build report delivery process across the enterprise adhering to industry's best practices and standards
- Provide support to end-users who are designing and building their own reports using pre-defined data models
- Meet the requirements and deadlines established for a given project
- Follow internal processes and procedures
- Investigate and resolve reported defects
- Work closely with other team members to coordinate assignments and communicate status
- Working closely with the solution leads on solution design, architecture, and implementation.
- Document and demonstrate solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code.
**Qualifications**
- Bachelor's degree in Computer Science or Data Analytics or Software Engineering or Mathematics
- 5+ years of development experience in Tableau and Power BI
- 5+ years of development experience in SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
- 5+ years of experience in dimensional data modeling using Analysis tools like SQL Server Analysis Service (SSAS) and Azure Analysis Services
- 5+ years of experience creating, managing, and troubleshooting complex reports/dashboards, SQL queries, views, procedures, and functions
- 5+ years of experience administrating Power BI (ex: Users, workspaces, Apps, building a new Power BI infrastructure from scratch, etc.)
- 5+ years of managing Power BI Governance
- 5+ years of Advance SQL development experience: Management of high volume of data, building aggregates, and cubes, tuning complex queries for performance, improving overall data retrieval process, indexing, and query plan analysis and refactoring
- 5+ years of data extraction development experience with a wide variety of ETL/ELT tools and processes
- 5+ years of working experience with Data Warehousing and Self-Service Business Intelligence
- 5+ years of working experience with Azure Data Factory, Azure SQL, Azure Synapse
- Experience with Power BI licensing (ex: Power BI pro, Power BI Premium, etc.)
- Experienced working in the cloud and serverless database solutions (Azure, AWS, Snowflake, BigQuery, BigTable, etc.) in combination with any BI Tools (SSRS, Power BI, Tableau, Looker, Qlik, etc.). Experience with Azure and Power BI and SSRS will be preferred.
- Experience with JIRA, Azure DevOps
- Proficient in relational databases
- Rigorous attention to detail
- Ability to communicate with internal and external stakeholders and work through data-related inquiries and issues
- Effectively manage workload with shifting priorities and varying business requirements
- Excellent problem-solving skills to identify creative ways to achieve solutions
- Capable of taking responsibility for a task and managing it through completion
- Excellent verbal and written communication skills
- Strong accounting background is a plus.
- Azure experience is preferred.
- Experience