Job Description
We are looking for a leader in IT staffing and staff augmentation services, seeks a Microsoft SQL BI Developer for our preferred client in Plano, TX location. The qualified candidate will possess 5+ years of experience.
Description:
The Business Intelligence Developer is responsible for transforming business requirements into functionally useful business intelligence solutions. Deliverables may include the following: reports; cubes; dashboards; visualizations; excel reports and templates; database modeling and development; Extraction Translation and Load (ETL) development; stored procedures; production job scheduling and management; related documentation; and other types as needed to support business requirements. Additionally, work with business users to proactively identify requirements, support testing/validation, off-hours support and assist with training are considered basics of this position.
This role requires proficient experience with Microsoft Business Intelligence toolset, BI development lifecycle and working knowledge on many BI concepts. It is expected that this individual can excel in a small, collaborative and dynamic environment. In addition, deliverables must ensure data is consistent, available, accurate and fit for analytics and reporting thus ensuring quality of our BI environment.
Responsibilities for this Position Include:
- Work directly with user groups to determine reporting needs; translate those needs into deliverables which best fit the organization and business need.
- Develop quality reports, cubes, ETL, Excel templates, data models, stored procedures, documentation and other deliverable types.
- Perform unit testing and validation for any and all deliverables before turning them over to the business user.
- Perform optimizations on deliverables such as reports, cube processing, stored procedure, SQL queries, etc. by working the issue and making appropriate changes.
- Work with project teams to identify new requirements for BI based on the needs of the project.
Qualifications
- Must be able to verify and reconcile data for accuracy and consistency.
- Proven ability to write, tune and execute complex T-SQL queries.
- Proven experience with the data warehousing technologies
- Relational Database and SQL language (column store is nice to have).
- OLAP development using SQL Server Analysis Services (SSAS) - Tabular and Multidimensional.
- Report development using SQL Server Reporting Services (SSRS).
- Extract, Transform and Load (ETL) using SQL Server Integration Services (SSIS).
- Ability to write OLAP query language MDX (DAX is a plus).
- Must have Strong experience in SSRS, Building Reports, and Stored Procedures
- Solid Experience with Power Query, Power Pivot and Excel
- Advanced level in MS Excel and ability to manipulate data out of cubes using pivot tables.
- Ability to deploy BI solutions in SharePoint a plus.
- Proficient knowledge of methodologies, processes and tools commonly used in BI environments
- Possess leadership skills as demonstrated by a disciplined approach to innovation and the capacity to create and embrace the vision for the end goal or project deliverable.
- Able to communicate clearly to both technical and non-technical audiences.
- Must be able to work independently and within a team and handle sensitive data professionally.
- Must be able to work on multiple projects concurrently and work within deadlines.
- Analytical approach to troubleshooting and solving issues.
- Strong work ethic, good attitude, highly organized, detailed oriented and team player.
- Ability and desire to learn new concepts and apply them to solutions.
- Willingness to be on-call to support the business off-hours.
- A Bachelor’s degree from an accredited program in Information Systems, Computer Science or other related field preferred