Data Warehouse Analyst
4 months ago
Parsippany
Job Description MAIN FUNCTION: We are seeking a highly skilled and experienced Data Warehouse Analyst to oversee the management and optimization of our data warehouse systems. The successful candidate will lead cross-functional teams, drive data strategies in alignment with business objectives, and ensure seamless integration across various departments. QUALIFICATIONS: • Experience: Minimum of 5 years of experience in data warehousing, business intelligence, or a similar role. Proven experience in data warehousing or a similar role, with a track record of successful data warehouse implementations and ongoing maintenance., • Technical Proficiency: Strong understanding of data warehouse technologies, database management systems, and programming languages such as SQL, with expertise in maintaining system performance and updates., • Strong foundation in Microsoft SQL Server, • Experience with cloud platforms like Azure Synapse, Amazon Redshift a plus, • Familiarity with Data Lake/Lakehouse models, • Proficiency with ETL tools such as Azure Data Factory, SSIS, • Power BI expertise including DAX and service admin, • Analytical Skills: Ability to analyze complex business processes and data sets to optimize data warehouse performance and ensure continuous improvement. Analyze both structured and unstructured data to provide comprehensive insights., • Project Management Skills: Excellent organizational and leadership abilities, with proficiency in project management methodologies and tools for both implementation and maintenance phases., • Communication Skills: Strong verbal and written communication skills, capable of conveying complex data warehouse concepts to non-technical stakeholders, facilitating ongoing support and training., • Problem-Solving Aptitude: Demonstrated ability to troubleshoot issues and implement effective solutions during data warehouse deployment and post-implementation maintenance., • Adaptability: Willingness to stay updated with the latest advancements in data warehouse technologies and integrate them into business processes, ensuring the system remains current and efficient., • Educational Background: Bachelor’s or Master’s degree in Computer Science, Information Technology, Business Administration, or a related field, with a focus on systems management and maintenance., • Relevant certifications (e.g., PMP, data warehousing certifications, BI certifications) are a plus., • Experience in Business Intelligence (BI) and Data Warehousing (DW): Essential for transforming raw data into meaningful information that supports decision-making and enhances business operations and outcomes., • Modern Data Architecture & Storage: Cloud Data Warehousing, • Experience with platforms like Azure Synapse Analytics, Amazon Redshift, or Google BigQuery WORKING CONDITIONS: The work environment characteristics are representative of those an employee encounters while performing the essential functions of this job. KEY RELATIONSHIPS: • Executive Management: Collaborate with senior leaders to align data warehouse strategies with organizational goals and secure necessary resources., • Department Heads: Work closely with heads of various departments to identify data integration opportunities and ensure smooth implementation., • IT and Development Teams: Coordinate with technical teams to oversee the configuration, customization, and deployment of data warehouse modules. Ensure data warehouse systems comply with data privacy regulations and maintain robust security standards., • End Users: Provide training and support to employees to facilitate effective utilization of data warehouse systems. DUTIES AND RESPONSIBILITIES: To perform this job successfully, the individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. • Data Warehouse Strategy: Develop and implement data warehouse strategies that align with the organization's business objectives., • Project Management: Lead data warehouse projects from conception through deployment, ensuring timely and within-budget delivery., • Cross-Functional Collaboration: Work closely with various departments to identify opportunities for data integration and ensure seamless implementation., • Technical Oversight: Supervise the development and optimization of data warehouse systems, ensuring they meet business requirements and performance standards., • Training and Support: Conduct training sessions for employees on data warehouse systems and provide ongoing support to ensure effective utilization., • Performance Monitoring: Continuously monitor data warehouse system performance, making necessary adjustments to improve efficiency and effectiveness., • Compliance Assurance: Ensure all data warehouse implementations comply with data privacy regulations and industry standards., • Vendor Management: Manage relationships with data warehouse technology vendors and service providers to facilitate successful implementations. COMPENSATION: The base salary range for this position is $100,000 to $115,000; the exact salary depends on several factors such as experience, skills, education, and budget. BENEFITS OVERVIEW: We offer a competitive benefits package that includes medical, dental, vision, basic life and AD&D coverage, short- and long-term disability, a 401(k) retirement plan, annual discretionary salary increases and bonuses. Employees receive paid company holidays, paid time off, and access to company-paid training. Optional benefits include tuition reimbursement, a 529 college savings plan, pet insurance, legal and ID theft coverage, and other voluntary insurance plans.