MSBI Data Architect || Fulltime || Without Sponsorship

Voto Consulting LLC; Davenport (IA); On-site; USD 90,000 - 130,000; Full time

Job summary

Voto Consulting LLC is seeking a hands-on BI/ETL Engineer to design and implement robust ETL using SSIS, and to develop scalable Power BI solutions for manufacturing data. You will integrate data from on-prem databases, cloud services, and external APIs, and optimize data models for performance.

The role emphasizes advanced DAX and Power Query work, SSRS report support, and collaboration with offshore teams.

Qualifications

• Experience designing and implementing ETL with SSIS.
• Develop scalable Power BI solutions following best practices.
• Integrate data from on-premises databases, cloud services and APIs into Power BI.
• Optimize data models for performance and efficient retrieval.
• Develop advanced DAX and Power Query transformations.
• Support existing SSRS reports and develop new ones.
• Metal/manufacturing domain knowledge is a plus.
• Strong analytical and communication skills.

Responsibilities

• Collaborate with cross-functional teams to understand requirements and translate to technical specs.
• Architect downstream SQL Data Warehouse based on new source system.
• Modify coding standards per project requirements and implement reusable components.
• Analyze issues and provide timely resolutions.
• Coordinate with offshore team to oversee deliverables.
• Test applications and estimate effort/timelines for enhancements.
• Create or update technical specifications and documentation.
• Communicate effectively with clients and stakeholders.

Skills

ETL

SSIS

Power BI

DAX

Power Query

SQL

SSRS

Datawarehouse

Agile

Waterfall

Communication

Stakeholder management

Tools

Oracle

SQL Server

Job description

• 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
• Ability to work effectively both independently and as part of a team
• 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
• 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.
• 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.

Generic Managerial Skills, If any