Allied's Data Strategy requires the acquisition, curation, and transformation of data into a usable asset. This role will develop and deploy optimized data models and modern data architecture to support strategic data and business initiatives, serving as a subject matter expert for data domain knowledge, SQL, data design, and data processes. The goal is to design and build end-to-end data flows for optimal business intelligence, advanced analytics, and data monetization, contributing to future state Data Management and Data Strategy roadmaps.
Requirements
- 5+ years of experience with data warehousing, databases (MS SQL Server, Snowflake), and dimensional modeling
- 5+ years of experience in end-to-end data analysis and development
- 3-5 years of experience in AWS cloud services (AWS Glue, Lambda, S3, etc.)
- 3-5 years of experience with Snowflake (Snowpipe, Snowpark, Streamlit, Streams/Tasks) (preferred)
- Extensive Experience with SQL required
- Experience with R or Python (preferred)
- Experience with Git and CI/CD (preferred)
Responsibilities
- Creates detailed documentation of data warehouse, data stores, and end to end data flows
- Troubleshoots and corrects data and data processing errors in existing solutions
- Develops and continually refines the BI-focused data architecture
- Works closely with the Data Intelligence department to understand the data and reporting requirements from internal and external customers and the steps to take on the back-end data side to achieve the expected results
- Conducts gap analysis on source system databases against Allied’s enterprise data warehouse in support of Business Intelligence efforts
- Develops and maintains data sets and standardizes data collection and processing methodologies
- Works on plan and technical architecture to extract, integrate, and or push data to or from third party providers
Other
- Bachelor’s Degree required, or equivalent education/work experience
- Strong attention to detail
- Familiarity with Object Oriented Analysis, Project Management, Business Analysis Methodology, and the SDLC
- Ability to collaborate effectively and work as part of a team
- Customer-oriented, with a desire to resolve problems to the customer's satisfaction while maintaining focus on productivity, efficiency, and quality
