Sr. Business Intelligence Developer

Offer by Elev8 Hire Solutions

sql

sql-server

tsql

About this job

Job type: Full-time
Role: Database Administrator



Technologies

sql, sql-server, tsql



Job description

Sr. Business Intelligence Developer


Our client in the Alpharetta area is seeking a Sr Business Intelligence Developer. In this role you report directly to the Director of Development and is responsible for the ongoing and new development of internal and customer-facing reports. The position also includes designing, developing and maintaining the Safe Systems Data Warehouse as well as the processes that supply data to it. The Senior Business Intelligence Developer may be called upon to troubleshoot production environment and customer support issues.

Role Expectations & Responsibilities:


  • Writes high-quality code, documentation and unit tests to implement report or ETL designs as directed by manager or team lead
  • Responsible for customized and advanced report creation using SQL Server Reporting Services and Analysis Services (SSRS / SSAS)
  • Develops queries and stored procedures for data extraction
  • Perform ongoing support for reporting and business intelligence applications - including system monitoring, processing, user support and queries
  • Develops ad hoc reports as needed
  • Analyze database performance and makes adjustments to ensure maximum database efficiency
  • Assist in the development and maintenance of regular backup and replication procedures to ensure database availability and complete restore capability
  • Develop and maintain strong working relationships with other Safe Systems Service groups and customers to expedite delivery of Business Intelligence solutions
  • Contributes to the overall architecture of our reporting products, analyzes and solves problems, and analyzes new features and enhancements
  • Collaborates with other software engineers, managers and quality assurance
  • Performs unit testing and writes documentation so support his/her designs
  • Works with SQL Server Reporting Services, SQL Service Integration Services and SQL Server (including developing SQL queries, stored procedures, functions and triggers)
  • Works with CVS for source control and CruiseControl for build activities
  • Works on Reporting and Business Intelligence initiatives of large scope/complexity where analysis of situations or data requires a review of identifiable factors
  • Regularly exercises good judgment to determine appropriate action
  • Contributes to the completion of specific programs, projects and commitments established for the work unit while operating under the general direction of a manager or team lead
  • Mentor other direct/indirect team and company members · Educates peers and team members on industry best practices, design principles and implementation techniques
  • Leads any and/or all phases of the product development cycle from product definition and design, through implementation including:
    • Implementation and Testing
    • Performance Analysis
    • Design Specifications
    • Critical and High Visibility Customer Support
  • Participates and influences technical discussions within the immediate group and across groups, where evaluating and executing design and development plans for products are reviewed
  • Has close interaction with development team and management
  • Performs additional tasks and responsibilities that will contribute towards team, department, and company goals
  • Other duties as assigned


Skills Required:


  • Bachelor’s Degree from four-year college or university in Computer Science or related field
  • 7-10 years’ experience including full life-cycle and functional/non-functional experience specifically on the Microsoft platform including SQL Server (SSIS, SSRS, SSAS)
  • Experience with ad-hoc reporting
  • Must be skilled in problem solving and troubleshooting
  • Must work well in team environment
  • Possession of critical thinking skills, communication skills (verbal and written) and interpersonal skills
  • Professional, outgoing, and customer service oriented
  • Remain calm and professional in stressful situations
  • Friendly, courteous, service-oriented, and flexible and enjoys working with a variety of staff
  • Detail-oriented and work effectively under pressure while meeting all applicable deadlines
  • Must be able to work independently and productively with minimum supervision; able to manage multiple projects
  • Recognize problems, identify possible causes and resolve routine problems
  • Establish and maintain effective working relationships with internal and external organizations, groups, team members and individuals
  • Experience in the following Hardware/Software:
    • Microsoft Office
    • Database Software (SQL)
    • SQL Service Reporting Services
    • SQL Server Integration Services
    • Report/Query Debugging Tools

Benefits:

  • Full health, dental, etc.
  • 401k + benefits
  • PTO


A new version is available REFRESH