All Lines Technology is seeking a Lead Business Intelligence Developer who will provide technical expertise and direction in developing and supporting an enterprise business intelligence platform, interfacing with the various business units across the organization on their reporting and analytic needs. You will participate in all phases of the development life cycle. You will also be responsible for defining standards, production support and maintenance of the BI environment, and works with the team on system performance optimization and interoperability issues. Reporting and analytic solutions will need to meet business objectives and build a high level of user trust and confidence in the BI group's knowledge of and concern for the users' business needs.
Essential Duties and Responsibilities
Designs and develops dashboards, scorecards, charts, pivot tables, reports, and reporting systems according to business requirements
Determines required Microsoft business intelligence components to meet reporting requirements
Assists in the development and maintenance of Microsoft SQL Server Integration Services (SSIS) packages
Works with business analysts and other developers on design of technical solutions
Work with Help Desk personnel to resolve reporting request from the business users using SSRS, Excel and other front end reporting tools.
Estimates technical effort required to deliver assigned tasks
Additional Duties, as assigned
Undergraduate Degree in Computer Science, Software Engineering or Information Technology
3-4 Years’ Work Experience in BI Development Role
Ability to create efficient and professional parameterized reports that include tables, matrixes, charts, and sub reports using key indicators.
Knowledge of creating drill-down and dashboard reports
Development/support of MS SQL server code including complex optimized SQL queries, stored procedures, views, and functions with an understanding of performance factors such as indexes, T-SQL techniques, execution plans and statistics
Advanced Microsoft Excel knowledge
Microsoft SQL Server, SSAS, SSRS (2008 R2 or higher), SSIS, Power Pivot, (PowerApps and Microsoft Flow a plus)
Ability to create and manage reports in Microsoft PowerBI including PowerBI Desktop and PowerBI service.
Knowledge of data mashing procedures using PowerBI
Ability to handle and maintain the confidentiality of highly sensitive information
Ability to analyze complex problems and move them quickly to resolution
Self-Motivated: Ability to Work with Minimal Supervision
Strong Customer Service Focus
Clear Verbal and Written Communication Skills
Ability to Work in Fast-Paced Environment and Meet Deadlines
Capability to Work both Independently and as part of a Team
Problem-Solving Mindset with Ability to Multitask
Internal Number: BGMC4462
About All Lines Technology, Inc.
All Lines Technology is a leading provider of enterprise technology solutions and services, with proven expertise enabling organizations to overcome obstacles and achieve excellent business results.
All Lines Technology is a woman owned solutions provider that delivers cost effective, industry standard IT solutions to our customers. We strive to be a Professional Business Partner and Trusted Advisor with each of our clients. In doing so, we help companies streamline and improve the way they buy, implement, and manage their technology infrastructures that support their mission critical business applications. These scalable solutions deliver benefits to companies from start up to Fortune 500.
All Lines Technology specializes in industry standard solutions for Enterprise Infrastructure, Microsoft Collaboration and Productivity Solutions, MSP/Cloud Solutions, IT Staffing, IT Consulting, and 24/7/365 Help Desk. As a value-added solutions provider, we partner with only best-of breed industry leaders that meet the business needs of our clients. We use our expertise to deliver streamlined solutions customized to the unique needs of your business, and strive to be your true trusted ad...visor. By leveraging cutting edge technology deployment and management solutions from industry leaders, we ensure you receive the technology solutions you require, delivered with the highest level of service.
Our corporate headquarters is located in Warrendale, PA which includes a state of the art datacenter showcasing some of the latest technology hardware and software solutions for our customers as well as a Tier 3 datacenter for our cloud based services. We utilize these for live demos, proof of concepts, and application testing. In addition, we also have a 20,000 square foot warehouse, staging & integration center that we use for client management/imaging and warehousing. We have a secondary location in Cranberry Township, PA where our 24/7/365 Help Desk and network operations center resides.