Title: Senior MS BI Developer - Onsite interview
Location: Dover, DE, United States
Length: Long term
Restriction: W2 or C2C
Very Long term contract; Initial PO till 6/30/2020 Usually the project goes for 4+ years with this customer *** 37.5 hours per week *** In person interview
1.Works with business partners to plan and implement enhancements to the existing BI infrastructure, Report Server and the Data Gateway.
2.Serve as subject matter expert in data warehousing and BI solution design, development and implementation.
3.Designs, develops and maintains data models, PowerBI datasets, ETL and other reporting infrastructure components for the Data Gateway, BI and reporting environments.
4.Creates, enhances, and performance tunes reports to support BI and Data Gateway administration.
5.Responsible for the administration, maintenance, operational support, configuration management, and manages security for Enterprise BI tools.
6.Serves as subject matter expert in BI tools working on problems of diverse scope and complexity.
7.Creates, enhances, and performance tunes reports.
8.Provides training and support to enterprise reporting community.
9.Accountable for maintaining the security and confidentiality of any proprietary or sensitive information or data in any medium regarding the State, employees of the State and customers/citizens. Accessing or disclosing such information or data must be deemed necessary for the performance of ones job responsibilities and must be authorized by the employees supervisor.
10.Responsible for following the defined SDLC, ensuring solution development adheres to the process controls.
11.Availability to work after hours and/or weekends and on-call, as specified by supervisor.
Bachelors degree with 5-8 years of related experience, or an equivalent combination of education and experience
Prefers 10 years experience
Strong understanding of BI best practices
Strong experience in business analysis, systems analysis, and data analysis in transactional and data warehousing environments
Advanced knowledge of and experience with data warehousing and Business Intelligence tools.
Strong experience working with SQL and Oracle
Strong experience with query languages such as T-SQL and DAX
Some experience with Python preferred
Strong experience working with integration tools (SSIS, DataStage etc.)
Strong report writing experience using BI tools (preferably Power BI).
Experience with the entire Microsoft BI stack preferred (Power BI, SSRS, SSAS, SSIS.)
Knowledge of superior customer service standards and practices
Ability to work independently to determine methods and procedures on new assignments
Receives no instruction on routine work, general instructions on new assignments