Report Writer

**Triple Eight Transport Inc. is growing and is in search for a strong communicator who is detail orientated to join our dynamic team Are you interested in a rewarding, challenging and exciting career?**

The SQL Report Writer is responsible for building and maintaining reports by **collecting, analyzing and converting complex raw data and comprehensive information into written reports**. These reports are easy for the average reader or non-technical employees to understand.

**Responsibilities will include**:

- Work closely with other members of the IT team to estimate, design, develop, document, and implement various technical solutions, aligned with the organization’s business objectives and existing systems architecture
- Manages the accurate and timely financial reporting process including the preparation of all period end reports. Provides operational reporting in support of key business processes across various
- Consulting with the Project Manager, developers, analysts, architects and user representatives to define and understand business requirements, to develop data base models at the conceptual, logical and physical design stages, and determine required capacity;
- Developing data models and establishing data relationships through all stages of the design process;
- Work with the development team on database design to meet business requirements
- Participate in capacity planning and performance tuning activities.
- Develop and maintain reporting standards.
- Collaborate with cross-functional teams to understand their data needs, provide insights, and deliver solutions tailored to their business objectives.
- Create and maintain visually appealing and interactive dashboards, KPI scorecards, and visual reports in Power BI that present complex data in a clear and concise manner.
- Analyze and interpret complex data sets to uncover insights and trends, helping make data-driven decisions.
- Integrate data, alter data, and connect to data sources for business intelligence.
- Make charts and data documentation that includes descriptions of the techniques, parameters, models, and relationships.

**Qualifications**
- Proven 1+ years experience as a Database analyst, managing any of the following databases: SQL Server, MongoDB,
- Strong understanding of database concepts, principles, and best practices
- Proficient in writing and optimizing DB queries (e.g. SQL queries, MongoDB queries)
- Experience with database performance tuning and optimization techniques
- Familiarity with backup and recovery procedures, replication, and high-availability strategies
- Bachelor’s degree with majors in information system or finance
- Excellent communication skills
- Exceptional analytical thinking skills for converting data into illuminating reports.
- Familiarity with the tools and technologies used by the Microsoft SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, PowerBI, and DAX.
- Advanced knowledge of SQL and experience working with relational databases.
- Comprehensive understanding of data modeling, administration, and visualization
- Advanced knowledge of Microsoft Excel and proficiency in Microsoft Office suite of products
- Solid understanding of database security and access control
- Excellent problem-solving skills and attention to detail
- Must be legally allowed to work full time in Canada

**Why choose Triple Eight Transport Inc.?**
- State of the art facility
- Regular company lunches for special events
- Annual Summer Corporate team building event
- Annual Winter Holiday party with amazing prize draws rewarding our valuable team because our people are important to us
- Opportunities for growth within the company as we continue growing
- Our open door policy shows we value communication and building strong, meaningful relationships across our workplace
- Competitive wage and vacation packages

**Job Types**: Full-time, Permanent

Pay: $50,000.00-$60,000.00 per year

**Benefits**:

- Dental care
- Extended health care
- Life insurance
- Vision care

Schedule:

- Day shift
- Monday to Friday
- Morning shift

Work Location: In person