Business Intelligence Developer (#4446)

New Value Solutions is an IT consulting company with offices in the United States, Canada and Italy. The BI Developer will be an important member of the team to migrate hundreds of SSIS packages to Azure. This is a contract role.

The BI Migration Developer will be responsible for developing, and executing data the migration processes, ensuring the seamless transfer of data from on-premises to Azure.

Role and ResponsibilitiesData Analysis and Mapping - Analyze source and target data sources/databases, understand data structures, and create data mapping documents to define the data migration strategy. ETL Development - Develop, test, and implement ETL scripts and workflows to extract, transform, and load data from source systems to destination systems.Data Validation - Implement data validation processes to ensure data quality and integrity throughout the migration process. Documentation - Maintain detailed documentation of data migration processes, including scripts, configurations, and error handling procedures.Collaboration - Collaborate with project managers, database administrators, stakeholders, and other IT professionals to plan and execute data migration projects on time and within budget. Performance Optimization - Optimize data migration processes for efficiency and performance, minimizing downtime and disruptions. Troubleshooting - Identify and resolve data migration issues, including data transformation errors, data loss prevention, and data reconciliation. Data Security - Ensure data security and compliance with relevant regulations during migration, including data encryption and access controls.

Qualifications: Bachelor's degree in Computer Science, Information Systems, or specialized training/certification, or equivalent work experience3-5 years of experience as a Microsoft SSIS BI Developer Experience with Power BI: semantic models, Power QueryAdvanced DAX (Data Analysis Expressions) skillsAdvanced SQL skills. Experience with creating/maintaining stored procedures & structured viewsExperience with Microsoft Analysis Services (SSAS), Microsoft Reporting Services (SSRS) and Microsoft SQL Server Integration Services (SSIS).SQL Server Management Studio (SSMS)Experience with ETL/ELT tools, specifically Azure Data FactoryCloud to cloud integrationScripting, API development, Web connectorsData Lake designOLAP (Online analytical processing)Strong organizational and time management skillsTranslate complex business problems into technical specificationsExcellent problem-solving and analytical skillsAbility to organize, analyze, and present dataAbility to manage multiple priorities

Key Skills

• SQL