MICROSOFT BI DEVELOPER

Job Description:

Some of the essential aspects of the position include:

• Develop, document, and implement data mappings for ETL implementations
• Design, develop and maintain BI reporting and analytic dashboards using data visualization technologies
• Participate in business process analysis and requirements gathering sessions with business stakeholders while contributing to the design, presentation, and implementation of technical solutions to meet business needs
• Review business requirements and create reports and dashboards
• Provide technical support for existing reports
• Assess and estimate project tasks and provide the accurate status of assigned projects
• Work closely in a team environment with other developers, project managers, and business analysts.

What it takes:

• 5+ years of experience with SQL programming using Microsoft SQL Server
• 4-year degree in Computer Science or equivalent experience.
• Excellent understanding of Microsoft SQL Server
• Expert-level knowledge around SSIS, SSAS (Multidimensional and Tabular), SSRS, PowerBI and tools such as SSMS and SSDT
• Experience working with Data Visualization, Auditing, Data Validation, and Data Mining
• Strong working knowledge and track record of Data Analytics development
• Experience designing automated processing, data validation, error checks and alerts, and performance testing techniques
• Knowledge of ERP systems in a distribution environment
• Experience working in a SOX environment
• Experience with Microsoft Excel strongly desirable - Excel skills should include the ability to create pivot tables, graphs, complex lookups, etc