Job Description
Job DescriptionPosition Summary
We are seeking a talented and detail-oriented detail oriented to play a critical role in designing, developing, and managing robust data solutions that drive impactful business insights. This position focuses on building scalable ETL processes, maintaining high-quality data pipelines, developing reports, and facilitating collaboration with key stakeholders.
Primary Responsibilities
Design and Develop Data Pipelines: Implement and manage ETL (Extract, Transform, Load) workflows using Matillion, ensuring seamless integration of data from diverse sources into our Snowflake Data Warehouse.
Manage and Optimize Data Warehouses: Develop scalable data storage systems to support analytics, reporting, and business intelligence initiatives.
Ensure Data Quality and Compliance: Create robust protocols to ensure data integrity and compliance, implementing quality checks and adhering to established standards.
Reporting and Analytics: Develop dashboards and reports through Qlik Cloud, offering actionable analytics to business leaders and stakeholders.
Cross-Department Collaboration: Partner closely with business users, analysts, and leadership to understand requirements, ensuring the delivery of suitable and efficient data-driven solutions.
Issue Resolution: Identify and address issues related to data quality and operational performance challenges in the BI environment.
Automation and Workflow Improvement: Build automated processes and scripts to enhance efficiency in data handling and reporting.
Miscellaneous Duties: Perform other assignments as directed by supervisors or senior leadership.
Key Qualifications
A minimum of 1 year of detail oriented experience or equivalent internship experience in a related field.
Demonstrated proficiency in SQL, with capabilities to write, optimize, and troubleshoot queries effectively.
Fundamental knowledge of data modeling and database management systems.
Familiarity with ETL processes and tools, particularly Matillion
Hands-on experience working with Snowflake Data Warehouse.
Exposure to data integration platforms such as Microsoft Power Apps or Power Automate is a plus.
Strong analytical skills with great attention to detail and problem-solving abilities.
Adaptability working in fast-paced team environments and eagerness to learn new technologies.
Willingness to work onsite at least three days a week at our Corporate Office in Acton, MA .Business Intelligence Technologies, Microsoft Power BI, Business Intelligence (BI), Power BI, Dax Technologies