Acquire, clean and develop datasets from internal and external sources to support business analysis and reporting
Acquire, validate, store, protect, and adhere to processes around data to ensure the accessibility, reliability, and timeliness of the data for its users
Develop and execute data architectures, policies, practices and procedures that properly manage the full data lifecycle needs of an enterprise
Identify opportunities for process improvements
Coordinate with other teams to ensure all aspects of data needs are taken into account
Prepare data for reporting and analysis including visualizations to support business requirements
Requirements
Bachelor's degree
5 or more years of technical experience in data analysis/ using ETL tools and developing ETL packages using SSIS
Worked on a project through its entire life cycle, from design, coding, code review and deployment
Experience providing expert architecture guidance on Data Warehouse, Data Lake and Modern BI architecture concepts and technologies using Azure Synapse Analytics and SNOWFLAKE
Experience implementing scalable and maintainable Dimensional Data Models to meet business objectives, includes construction of Azure Data Factory and automation of data architectures implemented
Experience taking complex data and making it more accessible, understandable and usable for leaders to derive insights
Proficiency in root cause analysis
Must have experience working with Databricks
Tech Stack
Azure
ETL
SSIS
Benefits
Medical, dental, and vision benefits
401(k) retirement savings plan
Paid time off (including paid time off, company and personal holidays, volunteer time off, paid parental and caregiver leave)