- Microsoft SQL Server
Job Type: Full-time, Exempt
The SQL Business Analyst will design, build and maintain our business intelligence platform. He/She will be responsible for designing, building, and maintaining business intelligence solutions, including reports for external clients. Essential duties and responsibilities include program design, documentation, and post-production support. He/She will collaborate with internal and external customers and coordinate support from fellow developers who are not necessarily BI experts.
Essential Job Functions:
Verify the output of each report and query.
Create and maintain process flow diagrams and documents.
Document business rules and expected outcomes.
Perform data profiling to find exceptions and outliers.
Perform ad hoc analytical requests and research projects for internal parties.
Create of data flow, database, and process diagrams.
Test solutions to validate whether requirements have been met; develop test plans, test scripts, and test conditions based on the business and system requirements.
Define business rules and verification strategies.
Provide end-user support in post-deployment phases, assessing and evaluating feedback to ensure that the requirements necessary to correct issues are addressed.
Assist with the documentation, development, and migration to a new reporting environment.
Competencies Required for Position:
Strong knowledge of SQL (preferably using SQL Server 2008 r2 or higher), including experience working with procedure SQL (such as T-SQL or P/L SQL).
Experience gathering / writing business requirements and communicating with stakeholders.
Demonstrated experience establishing enterprise level reporting and data validation solutions.
Experience with Tableau, SQL Server Reporting Services, Spotfire, Pentaho or similar a plus.
Excellent communication, collaboration, and documentation skills.
Experience in requirements management, UAT/ application design, use case development, writing test scripts, training documentation and delivery.
Strong problem solving, organizational and analytical skills.
Bachelor’s Degree in Business or IT.
Experience working as a Functional, Data or Business Analyst, or QA role.
3+ years SQL knowledge T-SQL, Tables, Views.
Excellent communication skills (written and verbal).
If interested, please send your resume to firstname.lastname@example.org