Responsibilities: Working with IT and business resources, support the Data Warehouse strategy and Business Intelligence initiatives:
Lead development activities to migrate the current on-premises SQL Server DW to Snowflake on AWS.
Gather requirements for Data Warehouse improvements and translate them to high level design documents including Physical Data Models. Provide technical architecture vision and recommend strategy/solutions.
Design and develop transformation processes and data structures for the Data Warehouse following best practice procedures.
Lead resolution of Data Warehouse load issues.
Support the analytical needs of the business users. Build strong relationships to help identify opportunities to enhance the analytical capabilities of the Data Warehouse.
Partnering with business stakeholders and technical report developers, establish, maintain, and promote consistent methodology for reporting and analytics deployment. Perform ad hoc data analysis to meet business unit data validation needs.
Participate in Data Quality initiatives and lead the data transformation component design to improve and maintain high quality data. Support performance tuning.
Foster teamwork through cooperative interactions with co-workers. Where needed, ensure project integration by communicating activities and status to project manager, appropriate project team members, and business users.
BS degree, preferably in Information Technology, Management Information Systems, Computer Science or similar discipline.
Post-college training in Data Management and vendor tool use Experience
5-8+ years of Data Warehousing/ BI experience.
Knowledge/Skills- This role serves as the primary technical resource for managing and moving data in and out of the Data Warehouse. The candidate must: Strong SQL skills with SSIS. SnowFlake is an added plus.
Be well versed in Data Warehouse design concepts including Kimball and Inmon methodologies
Have hands-on experience with ETL and ELT methodologies and tools.
Have experience with SQL Server 2016 and SSIS.
Experience with business reporting requirements analysis.
Familiarity with Data Management and Business Intelligence tools, such as Business Objects, Microsoft Power BI, QlikSense, Tableau, Looker, AWS S3 and Redshift, or Snowflake.
Demonstrated ability to clearly communicate with all levels within an organization.
Have experience leading small or offshore development teams
understanding and experience with building and deploying Business Intelligence and analytics applications.
Familiarity with Financial, Sales, Marketing, and Logistics reporting environments.
Strong sense of leadership, strong analytical skills, excellent communication Have expert skills and good technical abilities.
Preferred candidates will have experience with
Analytics design and development is preferred.
Hands on development experience with .Net is a plus.
Comfortable working in a fast-paced team. Capable of grasping new concepts quickly and acting with a sense of urgency.
Licenses / Certifications Preferred candidate may have certifications similar to:
CBIP (Certified Business Intelligence Professional)