Job added in hotlist
Applied job
Contract job
90-day-old-job
part-time-job
Recruiter job
Employer job
Expanded search
Apply online not available
View more jobs in Louisville, KY
View more jobs in Kentucky

Job Details

Senior Business Intelligence Developer

Location
Louisville, KY

Apply for this job






Profile

SGSCO needs an awesome BI Developer!

As one of our senior BI developers you will use the latest technologies to deliver solutions for our internal clients that address their business needs and challenges. You will engage in a range of analytical projects, from complex data modelling to designing ETL solutions that include error handling, data synchronization and auditing.

At sgsco, we share a commitment to excellence and a desire to work in a comfortable, friendly environment. Our IT is a group of fearless, collaborative, innovators, who wear Hawaiian shirts like nobodys business! Does this sound like you? Apply now, or reach out to Sarah Brumfield at *************************.

Essential Responsibilities and Accountabilities

- Plan, design, document, develop, test, and manage BI solutions

- Analyze functional specifications and assist in designing potential technical solutions

- Performs impact analysis for systems/database modifications

- Develop detailed specifications based on business requirements and update release documentation to reflect technical modifications

- Debug, monitor, and troubleshoot BI solutions

- Assist in the development, execution, and documentation of system and integration test plans

- Write relational and multidimensional database queries

- Create and deploy solutions

- Assist in the configuration, deployment, and maintenance of database servers and code

- Design, develop and troubleshoot SSIS packages that implement complex ETL processes

- Manage job data processing for ongoing success troubleshoot and rectify any production related issues

- Optimize code for performance

- Update and maintain ETL metadata

- Identify data sources and works with source system developers and business owners to define data extraction methodologies

- Utilize the ETL application and analyze data necessary to resolve issues uncovered and related to source data

- Work closely with business partners to deliver effective global BI architecture in a timely manner

- Educate and advise internal customers on how to leverage available data for consumption

- Build relationships with business intelligence partners to understand data needs in order to execute with excellence on documented user requirements and prototypes

- Assist in documenting requirements, resolving ambiguities and conflicts, and ensuring requirements are complete

- Work with end-users to help identify issues and to refine requirements

- Manage individual workload and deliver to agreed upon project milestones

- Demonstrate ability to work in team environment and help resolve issues

- Communicate status / risks to manager regarding delivering solutions on time

- Establish and maintain working relationships with team members across the technology organization

- Assist in any additional responsibilities, as directed by management.

Competency Requirements

- Expertise in Microsoft SQL Server 2005/2008/2012

- Expertise with Microsoft SQL Server Integration Services (SSIS)

- Experience with Microsoft SQL Server Reporting Services (SSRS) and Analysis Services (SSAS), or equivalents

- Experience with Power BI or equivalent technology

- Experience with MDX is a plus

- Adherence to all development standards and protocols including the likes of change management, code review, documentation and testing

- Demonstrated SQL skills with extensive experience in developing stored procedures, views, functions, triggers and advanced logical methods.

- Familiarity with data warehousing methodology and techniques.

- Robust ETL design expertise (error handling, data synchronization / auditing, etc.)

- Strong skills in Microsoft Excel and/or Excel Services, SharePoint.

- Experience with Web development tools and Web services a plus (*******, ******, XML)

- Understanding of SDLC and production environments

- Good interpersonal, oral, and written communication skills, including the ability to communicate complex ideas in a simple way

- Azure SQL experience an advantage

Do you like perks? So do we!

- Our office is located at 626 W. Main St. in beautiful downtown Louisville. We have the best view of the Ohio river and it is convenient to museum row. Oh and did I mention, we have free parking!

- We offer competitive pay, 401k plan with company match and several benefits including company paid short-term/long-term Disability and Basic Life.

- Causal dress (prepare your jeans game, because that is what we wear on most days)

- Creative work environment.

And now for the legal stuff

- While preforming the duties of this job, the employee is occasionally required to walk, sit, use hands to touch, handle or feel objects, tools or controls. Reach with hands and arms, talk or hear.

- The employee is occasionally required lift uplift and/or move up to 30 pounds.

- Specific vision abilities that are required by the job include: close vision for computer monitor and the ability to adjust.






Job Type

Permanent





Job Reference

a3039e475b34a57



Job ID

20355796













Enter your details to join Resume-Library and apply for this role

Email





First Name



Last Name




Latest Job Title




Zip Code




Authorization to work in the U.S.


- Select -
I am authorized to work in this country for any employer
I am authorized to work in this country for my present employer only
I require sponsorship to work in this country




I am authorized to work in this country for any employer


I am authorized to work in this country for my present employer only


I require sponsorship to work in this country




This email already exists
Enter your password to login and apply

Forgotten your password?









Apply Now

Company info

Sign Up Now - SQLCrossing.com

Similar Jobs:
Software Developer
Location : Jeffersonville, IN
Summary:The Senior Software Developer will be responsible for the technical enhancements and new features for Heartlands custom developed Merchant Servicing Systems, enhancing and supporting them as necessary to meet business goa...
The number of jobs listed on EmploymentCrossing is great. I appreciate the efforts that are taken to ensure the accuracy and validity of all jobs.
Richard S - Baltimore, MD
  • All we do is research jobs.
  • Our team of researchers, programmers, and analysts find you jobs from over 1,000 career pages and other sources
  • Our members get more interviews and jobs than people who use "public job boards"
Shoot for the moon. Even if you miss it, you will land among the stars.
SQLCrossing - #1 Job Aggregation and Private Job-Opening Research Service — The Most Quality Jobs Anywhere
SQLCrossing is the first job consolidation service in the employment industry to seek to include every job that exists in the world.
Copyright © 2018 SQLCrossing - All rights reserved. 169