Business Analyst

WHO WE ARE
Abstrakt is a B2B lead generation company based in St. Louis. What we do is simple: we get our clients sales meetings. By identifying
our clients’ ideal audience and writing unique email campaigns, we capture people’s attention and compel them to respond.
What is it like to work at Abstrakt? Well, we’ve grown from 5 to 550 employees in 14 years while becoming one of the fastest
growing companies in the country (Inc. 500 list). Thrilling is probably a good word for it.
When it comes to developing yourself, supporting your team, and expanding the vision, we’re unrelenting. We move fast and break
things. Change comes from everywhere within our organization because the “from-the-top-down” structure has never been our
thing.
We have fun while going above and beyond to push ourselves and our clients, giving and taking constant feedback, and appreciating
the opportunity to grow and develop rapidly. Abstrakt is committed to creating inclusion and diversity across all levels of our
organization. We continue to make great strides in building our hiring and promotional practices to reflect our value and
commitment of celebrating diversity. Abstrakt strives to be a work environment where everyone can be their true authentic self.

POSITION SUMMARY
The Business Analyst will define, develop and deploy dashboards, reports and visualizations to enable metrics-driven decisions.
The Business Analyst must understand business/functional areas and translate them into requirements, identify available data
sources, recommend enhancement and understand/support the data strategy in the context of data governance and compliance
guidelines. This position must also create advanced queries for relational databases, auto-update visualizations, and present options
for improving data integrity/quality across our data warehouse.
The Business Analyst reports to the EVP of Finance, but works closely with and completes requests from the entire
team.

ESSENTIAL JOB FUNCTIONS
o Identify, analyze, and interpret trends or patterns in data sets
o Solicit and document requirements for dashboards, reports and visualizations
o Interact with business stakeholders/partners to understand their business and reporting needs, including critical
metrics and KPIs
o Design, develop and test BI Applications integrating reporting components from multiple data sources
o Maintain report documentation and data dictionary
o Monitor reporting systems for issues with data and report executions
o Provide daily support for reporting systems, which includes maintenance and enhancements to reporting systems
as well as responding to assigned tickets, troubleshooting and final resolution
o Ensure all reports and data transfers comply with Abstrakt security guidelines
o Other duties as assigned

REQUIRED EXPERIENCE/EDUCATION

MINIMUM EDUCATION:
Degree from accredited 4-year college or equivalent experience
MINIMUM EXPERIENCE:
Basic understanding of SQL development and troubleshooting, including developing stored procedures
Understanding of database management systems and development experience in one or more BI reporting Tools (Power BI,
Tableau, Qlik, Cognos, etc.)
Ability to understand business processes in order to create solutions that enable the business to effectively manage their
functions
Ability to effectively interpret and analyze data
Ability to maintain high level of confidentiality
Ability to work well under pressure
Ability to work independently and also collaboratively with others to achieve defined goals
Ability to build and maintain effective work relations
Ability to effectively manage conflict

MINIMUM SKILL REQUIREMENTS:

• SQL queries
• Power BI
• DAX
• Power Automate
• Power Query
• Optional: R and Python
• Optional: Experience with Amazon Redshift, S3, and

PHYSICAL, MENTAL, AND ENVIRONMENTAL DEMANDS

• Must be capable of working in an office-based or remote, collaborative environment to achieve business and departmental
• objectives.
• Must be comfortable in a position which requires working exclusively on a computer for the majority of the day.