The Business Intelligence Developer communicates with the various business units across the organization to determine their reporting and analytic needs. This individual participates in all phases of the development life cycle and is responsible for gathering requirements, defining solutions, and ultimately developing a useful end product. Above all, this individual makes certain that the reporting and analytic solutions meet business objectives and builds a high level of user trust and confidence in the BI group's knowledge of and concern for the users' business needs.
Communicate with all lines of business to determine their needs and define the most appropriate BI solutions. Generally using ad-hoc SQL queries, SSRS reports, or Power BI dashboards
Document requirements and build reports according to those requirements
Design and develop dashboards, scorecards, charts, pivot tables, reports, and reporting systems according to business requirements
Deliver ad-hoc reports under tight deadlines, as needed by the business
Determine required Microsoft business intelligence components (SQL, SSRS, SSIS, Power BI, Excel…) to meet reporting requirements
Work with business analysts and other developers on design of technical solutions
Estimate technical effort required to deliver assigned tasks
Sound work experience in BI Development Role
Analyze complex problems and move them quickly to resolution
Self-Motivated: Ability to Work with Minimal Supervision
Fluency with Microsoft SQL is a must
Build SSRS reports using parameters, conditional formatting, and grouping
Create Power BI dashboards by joining multiple data tables
Ability to write complex SQL queries, stored procedures, views, and functions with an understanding of performance factors such as indexes, execution plans and statistics
Advanced Microsoft Excel knowledge
Microsoft SQL Server, SSRS, SSIS, (SSAS, PowerApps, and Microsoft Flow a plus)
Ability to combine multiple datasets using PowerBI
Handle and maintain the confidentiality of highly sensitive information
Ability to read, analyze and interpret common technical reports, and documentation
Present information to executive and senior management teams, sales department, internal groups and/or clients
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
OpenArc is a technology consulting firm providing industry-leading technical talent placement, software development, and technology strategy services to clients nationwide. Through a unique blending of people and software, OpenArc has a business practice that delivers amazing enterprise, mobile and consumer-facing apps and the best talent for contract, contract-to-hire and direct placements for clients and partners alike.
Staffed with the most-trusted recruiting experts, elite software developers, UI/UX designers and market experts, our team provides clients with the best resources, the right techniques and world-class support resulting in powerful measurable success.