An innovative firm is seeking a skilled data professional with a strong background in database design and data analysis. This role involves developing web services and APIs, as well as providing support to clients while ensuring high data quality and security in distributed environments. You will work with BI architectural components and visualization tools to enhance reporting capabilities. Join a forward-thinking team that values your expertise in software design and development, and help drive impactful data solutions in the manufacturing and IT sectors. If you are passionate about leveraging technology to improve operations, this opportunity is for you.
Qualifications
Strong background in database design and data quality in cloud environments.
Experience with BI lifecycle, dimensional modeling, and ETL processes.
Experience in IT and Manufacturing industries; familiarity with quality, order management and operations systems.
Proficient in developing Webservices and APIs using REST and SOAP.
Proficient with Power BI, Power View and Excel for data visualization.
Provide tier 1 to 3 client support and analyze trends for improvements.
Strong understanding of SDLC and CI/CD practices using TFS.
Responsibilities
Develop web services and APIs using REST and SOAP.
Provide tier 1 to 3 support and analyze trends for system enhancements.
Analyze support requests and identify training or system improvements.
Set up CI using Visual Studio Team Foundation Server for automated builds.
Work with Power BI, Power View and Excel for reports.
Skills
Database design
Data analysis
BI architectural design
ETL
REST APIs
SOAP webservices
Report visualization tools
Software Design
ETL
Tools
Power BI
Microsoft Visual Studio Team Foundation Server
Excel
REST
SOAP
Microsoft Visual Studio Team Foundation Server
Job description
Strong background and skills in Database design, logical/physical data modeling, data analysis to drive superior data quality, security, privacy, integrity, and high performance, in highly distributed/cloud-based environments.
Strong background and design/modeling skills in BI architectural and pipeline components including dimensional modeling, data warehouse design and BI life cycle, cubes, ETL, source data profiling.
Experience in Information Technologies and Manufacturing industries. Functional experience working on quality, order management, planning & scheduling, shipping or operations management information systems projects.
Develop Webservices and APIs using REST, and SOAP webservices.
Experience in report visualization tools such as Power BI, Power View and Excel.
Provide tier 1 to 3 support to existing clients. Analyze support requests for trends and training or system enhancement opportunities.
Strong conceptual knowledge in Software Design and Software Development Life Cycle (SDLC).
Set up continuous integration using Microsoft Visual Studio Team Foundation Server to trigger automated build and deployment of various applications.