Job Responsibility:
Experience with enterprise-class ETL/BI tools (Microsoft SQL/SSAS/SSRS/SSIS)
Experience with software testing, report writing and database management.
Assist in the development of logical and physical data models for designing/developing business intelligence / data warehouse requirements.
Translate stakeholder’s deliverables into project methodology delivers that result in design, such as functional specifications, uses cases, work flow/ process diagrams, data flow/ data model diagrams.
Performs table and interface designs, development of logical and physical data model/database, ETL process, BI reports, tuning of databases, queries while meeting business/user requirements.
Design & Analysis reports using SSRS and SSIS.
Position Requirement:
Experience with requirements gathering and documentation processes
Experience with Fetch XML a plus.
Designing and deploying reports in SharePoint/Microsoft CRM a plus.
Experience with Scribe, CRM and Power BI is a big plus
Design the architecture, data warehouse, data marts and BI reports which will support the various data initiatives.
Design and develop extremely reliable, scalable and high performing reports.
Deploy BI reports
Achieves and maintains relevant technical competencies and helps to foster an environment of continued growth and learning among colleagues on existing and emerging technologies.
Participate in conference call with onsite and customer team.
Develop iterative prototype based on requirements. Contribute to architectural design & discussions.
Technical Skills:
Reporting Tools: SSRS
SQL languages: T-SQL, Fetch XML
ETL Tool: SSIS, Scribe or similar data integration tool.
RDBMS: SQL 2012 R2, SQL 2014
Other: Power BI or similar.