You will design and implement solutions to integrate, decompose, and combine data from various sources to support M&A data needs.
Responsibilities
Identify, design, and implement internal process improvements, including automating manual processes and re-designing infrastructure for scalability.
Investigate data sources and perform detailed data quality analysis.
Create and maintain optimal data pipeline architecture for ETL processes from internal and external sources.
Assemble complex datasets that meet functional and non-functional business requirements.
Communicate and maintain master data, metadata, and logical data models.
Required Skills
10+ years of professional experience designing and transforming data to/from Microsoft SQL Server, Azure SQL, Azure SQL DW, Dynamics CRM, and Dynamics 365.
Hands-on experience with integration technologies: Azure Data Factory, Azure Logic Apps, Power Automate, or similar services.
Mastery of relational SQL and NoSQL databases.
Proficiency with Snowflake in both AWS and Azure clouds.
Experience with data wrangling and preparing datasets for PowerBI consumption.
Proven ability to design and architect platforms for on-prem data migration.
Strong analytical and problem-solving skills combined with attention to detail.
Familiarity with SQL Server, Azure SQL, and AWS environments.