MSBI Data Architect

Acestack; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

Acestack is seeking a MSBI Data Architect to design and implement data solutions for a remote, full-time role. You will optimize data models, develop robust ETL pipelines with SSIS, and build scalable Power BI dashboards that adhere to best practices.

You will collaborate with cross-functional teams to integrate data from on-prem and cloud sources, ensuring performance with advanced DAX and SSRS reporting while maintaining strong communication with stakeholders.

Qualifications

• Strong analytical and problem-solving skills.
• Excellent communication and presentation skills.
• Ability to work independently and as part of a team.

Responsibilities

• Coordinate with external technical and functional teams to understand requirements and translate into technical specs.
• Understand existing source SQL data architecture and rearchitect downstream SQL Data Warehouse based on new source system.
• Modify existing standards and customize programs based on requirements.
• Analyze issues and provide resolutions.
• Work with offshore team to provide requirements and supervise overall work.
• Testing of application.
• Estimate effort and timelines for enhancements.
• Create/update technical specifications.

Job description

Job Title: MSBI Data Architect
Location: Remote
Fulltime

Job Description

Must Have Technical/Functional Skills

• Strong foundation in MS SQL server
• Create complex SQL queries, view, Stored procedure etc. in SQL server.
• Design and implement robust ETL using SSIS.
• Develop scalable and reusable Power BI solutions that adhere to best practices and industry standards.
• Integrate data from various sources, including on-premises databases, cloud services, and external APIs, into Power BI.
• Optimize data models for performance, ensuring efficient data retrieval and processing.
• Develop advanced DAX formulas and Power Query transformations to create complex calculations and data transformations.
• Understanding and support existing reports in SSRS and developing new reports.
• Domain knowledge of metal and manufacturing industry is a big plus
• Strong analytical and problem-solving skills.
• Excellent communication and presentation skills, with the ability to convey technical concepts to non-technical audiences.
• Ability to work effectively both independently and as part of a team

Roles & Responsibilities

• Coordinate with external technical and Functional team to understand requirements, convert that to technical specifications.
• Understand existing source SQL data architecture and rearchitect downstream SQL Datawarehouse based on new source system
• Modify existing standards as well as customized program based on requirement
• Analyze issues and provide resolution
• Work with offshore team to provide the requirements and supervise the overall work
• Testing of application
• Estimate the effort and timelines for enhancements
• Create/update technical specifications

Generic Managerial Skills, If any

• Strong communication skills and client/stakeholder interfacing is mandatory.
• Developing reusable code/components for future use.
• Optimization of the applications or modules for maximum performance and scalability.
• Must follow and ensure the coding standards defined by Oracle and the community in the project.
• Strong debugging skills.
• Familiar with Agile and waterfall models.
• Strong analytical and problem-solving skills.
• Excellent communication skills with business and technical stakeholders.
• Ability to work independently in a high availability manufacturing environment.
• Proactive mindset with ownership and accountability.
• Experience working in onsite offshore delivery models.