BKV

Returning Candidate?

Business Intelligence Developer

Business Intelligence Developer

Location 
US-GA-Atlanta
Type 
Regular Full-Time

More information about this job

Overview

COMPANY:

 

unified.agency is a strategic, full journey marketing agency that focuses on accountable communications. Comprised of 150 people on 5 focused teams (BKV, media +CRM; DRUM, digital strategy and development; Hiccup, content marketing; Resonant Analytics, analytics; & UMarketing, direct + research) across the US, u.a operates as the strategic consultant that brings the different disciplines together into one unified marketing strategy that delivers results. This position is for BKV and would be based out of Atlanta. 

 

BKV’s client roster includes Aflac, Spanx, AT&;T, Dell SecureWorks, Six Flags,

American Red Cross and Wounded Warrior Project, as well as many other prestigious for-profit

and nonprofit organizations. Check out bkv.com to learn more about what we do, who we are,

and how we can work together.

 

CULTURE:

 

Spend even a few minutes in our Buckhead office, and you’ll see for yourself: We love what we

do. At BKV, we’re aggressive, but we’re not ad-holes. Driven, but not to distraction. We believe in

the power of teamwork, and put it to work on everything from our bowling league to our award-

winning omni-channel campaigns. Here at BKV, everyone from the president to the summer

intern fulfills an active, hands-on role to meet our clients’ goals.

 

Summary:

 

The BI Developer manages and participates in the day-to- day reporting and analysis for various

clients. Works both collaboratively and independently among a team of other developers

in the areas of requirements gathering, learning industry and BKV’s best practices,

solution architecture and software development methodology.

Responsibilities

- Gather information about reporting needs from end users
- Write and test T-SQL procedures to deliver data from SQL Server to Tableau
- Create and test reports in Tableau
- Develop, maintain and support code/systems in support of the business needs.
- Train end users on capabilities of Tableau and finding insights from reporting
- Work with other team members to retrieve third-party reports and data for data integration and delivery
- Follows technical guidelines and best practices to ensure a consistently high standard of quality.
- Resolves defects or deficiencies with completed development, updatesdocumentation, and provides training to support team members on completed development as necessary.
- Create ad hoc data queries and solve data related reporting issues and document reports created.
- Manage projects and timelines for report delivery
- Ensure reported output is accurate and matches user requirements.
- Assist in training junior team members in use of Tableau and understanding SQL processes

Qualifications

- B.A. or B.S degree in a quantitative discipline - Economics or Statistics preferred
- 2-3 years of professional experience in a multi-client reporting and analysis environment.
- Excellent T-SQL skills including stored procedures, functions, & views
- Experience with the Microsoft BI Stack (SQL Server SSMS, SSRS, SSIS, & SSAS)
- Extensive knowledge of indexing, query optimization and other performance tuning techniques
- High capacity for data analysis, data modeling, computer programming, problem solving, sound judgment, accuracy and attention to detail
- 2+ Years experience developing in Business Intelligence Software such as
- Tableau and Microsoft Reporting Services.
- Understanding of SQL and relational and multidimensional designs
- Proficient in MS Office(Excel, PowerPoint, and Word)
- Experience delivering technical presentations to non-initiated audiences