Senior Business Intelligence Analyst, Information Technology
ServiceLink
full-time
Posted on:
Location Type: Office
Location: Moon Township • Pennsylvania • 🇺🇸 United States
Visit company websiteSalary
💰 $90,000 - $100,000 per year
Job Level
Senior
Tech Stack
ETLMS SQL ServerPythonSQLSSIS
About the role
- Develop reports and dashboards for all departments within ServiceLink
- Work with business leaders to determine data and reporting needs
- Provide ad hoc reports in a fast-paced environment with very short deadlines
- Develop creative solutions to facilitate decision making within the business
- Analyze client's business and data requirements and convert into reporting solutions
- Troubleshoot data issues and validate result sets
- Recommend and implement process improvements
- Be the SME for BI end user solutions, inclusive of sharing skills with technically inclined business users
- Utilize and master 3rd party tools such as Excel, SSRS, Power BI and SQL Server
- Create and maintain automated reporting services - combining data from various sources to produce reports within Microsoft Reporting Services environment
Requirements
- A B.S. Computer Science/MIS or its equivalent
- 5+ years of experience and strong background with Microsoft SQL Server
- The ability to receive, prioritize and complete tasks from multiple sources with minimal supervision
- Knowledge of relational databases
- Experience creating and optimizing stored procedures
- A strong desire to learn new technologies and improve your skills
- Strong attention to detail
- 5+ years of experience with SSIS and SSRS
- 5+ years of experience with T-SQL for writing stored procedures demonstrating the ability to write complex code to be utilized by applications, ETL and reports
- Strong report/dashboard design and code development skills required
- Expert knowledge of Excel inclusive of creating formulas and macros
- Knowledge of DAX preferred
- Experience with a language such as R or Python is a plus
Benefits
- health, vision, dental and life insurance
- 401(k) plans
- Employee Stock Purchase Plan
- paid vacation and sick time
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
Microsoft SQL ServerSSISSSRST-SQLstored proceduresExcelDAXRPythonreport/dashboard design
Soft skills
attention to detailprioritizationtask completionproblem-solvingcommunicationcreativityadaptabilitycollaborationtime managementlearning agility
Certifications
B.S. Computer ScienceB.S. MIS