Microsoft BI Developer
IBA InfoTech Inc.
Holly Springs, United States of America
30 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
Holly Springs, United States of America
Tech stack
Sql Server Data Tools (SSDT)
Microsoft Excel
Data Validation
ETL
Data Mining
Data Visualization
Microsoft SQL Server
Pivot Tables
Power BI
SQL Databases
SQL Server Reporting Services
SQL Server Integration Services
SQL Server Analysis Services
Performance Testing
Information Technology
Data Analytics
SQL Server Management Studio (SSMS)
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.
Requirements
- 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