Business Intelligence Analyst

Tigunia has an incredible opportunity for a Business Intelligence Analyst

Benefits:

Competitive salary

Health insurance for yourself and your family – 100% employer paid for employee and 50% employer paid for dependents

Dental and Vision insurance for yourself and your family – 100% employer paid for employee and dependents

Life/AD&D Insurance for yourself – 100% employer paid and covers 100% of your salary

Short Term Disability for yourself – 100% employer paid and covers 60% of your weekly salary up to $1,750.00

Long Term Disability for yourself – 100% employer paid and covers 60% of your monthly salary up to $6,000

401k with 4% match

Flex-time and paid time off to promote a healthy work-life balance

Position Description (Abstract):

This role is part of the Business Intelligence department of Tigunia, which handles all reporting and data-related tasks for our clients of many differing industries. To be successful in this role, you will need a combination of technical, soft, and analytical abilities. You will have to mine data using sophisticated tools and software, analyze it to spot trends, and then properly convey your results to others once you have identified data trends. Responsibilities will include implementations of Jet Analytics / TimeXtender, managing security permissions in various security model complexities, extensive dimensional modeling and data warehousing, and development of reports in various front-end reporting solutions as well as consulting and training on each of these topics.

This is a role where you will interface directly with clients and their systems, collaborating with them to complete their data or business intelligence objectives. This is an active, hands-on role that relies on problem-solving capabilities and self-reliance. Team members will work with a variety of clients daily, both in communications as well as video conferencing, and will need to be able to manage and prioritize requests as they come in. Team members are expected to adhere to naming conventions within client environments as well as to notate complex designs so others can support and troubleshoot if needed.

The right person for this position is someone who:

Knows what the Kimball Model is. Not only do you need to understand dimensional modeling and reporting techniques, but also will need to be able to explain them to people who do not know much about either. Our team is designed to partner with our clients to achieve business intelligence, meaning we strive to make their users power users of their own right, rather than relying on us for everything.

Enjoys data analysis and reporting. It is one thing to understand how data is queried; it is an entirely different thing to enjoy what reporting and analysis can provide. Our daily activity revolves around reporting and data modeling, so it is important that you enjoy what you are creating. It also helps when relating things to clients, as you will be able to speak to your experiences.

Is a professional troubleshooter. In this role, there will be scenarios where the data provided is different than what was expected by the client. You will need to be able to dig into those details and explain what is different and why. Being proficient with data sleuthing is key to being successful in this role.

Responsibilities

Gather requirements and document needs for reports.

Review and examine reports to locate and resolve issues.

Prepare and present reports to clients.

Development of data models via Jet Data Manager and TimeXtender.

Oversee the development of data warehouses and analysis services databases.

Analyze and evaluate the performance of SQL Server environments and issues.

Communicate the results of data analysis in both written and verbal form eloquently.

Understand and implement complex security models across varying levels of criteria.

Required Skills / Experience

Bachelor’s degree in computer science, business, mathematics, statistics, accounting, or related.

Strong experience with one of the following: Power BI, Jet Reports, Jet Analytics, TimeXtender, SSRS, Azure Data Factory, Cosmos Data Technologies, or Solver.

Strong written and verbal communication skills.

2 to 4 years of experience creating reports and performing the duties of an analyst.

Strong T-SQL knowledge of query development using MS SQL Server 2008 through current.

Thorough understanding of the Kimball model and SQL relational databases.

Experience developing data warehouses and analysis services databases.

Ability to manage time and prioritize projects to meet deadlines.

Comfortability with databases of varying sources and an ability to find your way through them.

Strong understanding of Excel and Pivot Tables.

Tigunia provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), parental status, national origin, age, disability, genetic information (including family medical history), political affiliation, military service, or other non-merit-based factors