Job Description :
BI Developer – Alpharetta, GA
Job Description
The BI Developer is responsible for the transforming business requirements into state-of-art business intelligence solutions. This includes designing and hands on development of the application using Microsoft Business Intelligence technologies. Also, it is expected the individual delivers solutions of which the data is consistent, available, and accurate and fit for reporting and analytics and ensures the quality of our BI products and deliverables. Being part of the development team, this developer is expected to take on additional responsibilities such as working closely with the product team to understand business requirements and collaborating with the BI Architect to develop a robust solution.
* Implement, maintain and enhance ETL solution fulfilling data quality, availability, and performance requirements
* Perform tests and validate all data flows and prepare all ETL processes according to business requirements.
* Perform root cause analysis on all processes and resolve all production issues
* Prepare documents for all data flow diagrams, technical and system specifications documents for all ETL processes.
* Implement, maintain and enhance existing reports, fulfilling easy-to-use and performance requirements
* Adhere to Agile delivery practices
* Participate in architecture, data modeling, and overall design sessions
Requirements/Skills
Technical Skills
– Ability to write, tune and execute complex T-SQL queries
– Experience with the data warehousing technologies, including:
* Relational Database and SQL language
* Dimensional Modeling
* SQL Server Analysis Services (SSAS) Tabular development, including knowledge of DAX language
* Report development using SQL Server Reporting Services (SSRS)
* Extract, Transform and Load (ETL) using SQL Server Integration Services (SSIS)
* Power BI and dashboard design
– Advanced level in MS Excel and ability to manipulate data out of cubes using pivot tables
Analysis and Soft Skills
– Must be able to verify and reconcile data for accuracy and consistency
– 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 to learn new concepts and apply them to solutions
– Creative thinking
– Experience in supporting the design and specification of data presentation and knowledge of reporting, analytics, KPIs and trending.
– Ability to collaborate on a team with infrastructure, BI report development and business analyst resources, and clearly communicate solutions to both technical and non-technical team members

Client : NextWave Resources