Data Developer Snowflake at The Computer Merchant, LTD.
Quincy, MA 02171
About the Job
JOB TITLE: Data Developer Snowflake
JOB LOCATION: Quincy MA
WAGE RANGE*: $75-$78
JOB NUMBER: ITS77_EHS_FY25_DATA DEV – 200 – DPH
REQUIRED EXPERIENCE:
Preferred experience/skills:
JOB DESCRIPTION
DPH is executing a large-scale data modernization across the agency as part of DMI. This includes creating a consolidated Enterprise Data Platform on modern cloud tools (including AWS & Snowflake,) and re-platforming existing business data applications from solutions such as SAS and legacy databases to the new platform. DPH data systems enable epidemiologists, public health researchers, state and local public health officials, and business leaders to analyze public health trends and drive policy decisions.
The ideal candidate is an expert in project requirement analysis, data management and analysis, collaboration with internal and external stakeholders, documentation of requirements, translation of business requirements to technical specs, presentations and project management when needed. You can clearly articulate and present feedback on project and process documents shared by vendors. In this role, you are comfortable speaking to both business and technical stakeholders to ensure combined understanding and collaborative solutions. This role will be expected to own tasks and follow-up related to cloud data platform requirements and implementation activities and establish well documented best practices and processes.
Duties and Responsibilities:
Equal Opportunity Employer Veterans/Disabled
* While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions.
JOB LOCATION: Quincy MA
WAGE RANGE*: $75-$78
JOB NUMBER: ITS77_EHS_FY25_DATA DEV – 200 – DPH
REQUIRED EXPERIENCE:
- Experience in creating, reviewing and maintaining end-to-end data platform requirements.
- Strong communication skills comfortable explaining/proposing solutions to technical stakeholders, vendors, and business consumers.
- Experience working with highly sensitive health care information and familiar with HIPAA and other data privacy controls.
- Thorough knowledge and experience of data warehouse and Enterprise Data solution.
- Data analytics and data profiling skills
- Proficiency in building testcases to validate requirements.
- 2+ years of Cloud database platform experience such as Snowflake.
- Familiarity with AWS cloud services
- Excellent SQL query skills
- Working knowledge with at least one Business Intelligence tool such as Tableau
Preferred experience/skills:
- Healthcare experience
- Excellent Documentation and Presentation Skills
- Amazon Web Services experience
- Snowflake certification
- Tableau reporting experience
JOB DESCRIPTION
DPH is executing a large-scale data modernization across the agency as part of DMI. This includes creating a consolidated Enterprise Data Platform on modern cloud tools (including AWS & Snowflake,) and re-platforming existing business data applications from solutions such as SAS and legacy databases to the new platform. DPH data systems enable epidemiologists, public health researchers, state and local public health officials, and business leaders to analyze public health trends and drive policy decisions.
The ideal candidate is an expert in project requirement analysis, data management and analysis, collaboration with internal and external stakeholders, documentation of requirements, translation of business requirements to technical specs, presentations and project management when needed. You can clearly articulate and present feedback on project and process documents shared by vendors. In this role, you are comfortable speaking to both business and technical stakeholders to ensure combined understanding and collaborative solutions. This role will be expected to own tasks and follow-up related to cloud data platform requirements and implementation activities and establish well documented best practices and processes.
Duties and Responsibilities:
- Plan for, develop, and document in detail the functional, technical and business requirements of solutions for business and technical projects of a wide range of complexity
- Write both business and technical documentation that is appropriate to support the development and end user community
- Engage and collaborate with internal/external stakeholders to understand their requirements and get their feedback throughout the lifecycle of projects
- Follow established PMO standards and procedures
- Communicate milestones that define delivery timetables based on capacity and prioritization
- Ensure timely delivery of solutions meeting requirements and expectations
- Investigate, design, and implement business solutions and major upgrades or enhancements to existing solutions
- Assist in complex data analysis and translates business needs into Data solutions
- Assist with data training to ensure the end users of the Data Platform and the BI reports fully understand all components.
- Cross train peers within subject matter areas and technical expertise areas
- Work with Architects, Developers and Analysts to present an overview of requirements to build use cases
- Work with technical teams to translate business requirements to technical requirements
- Gather and understand user requirements and business activities
- Experience in Participating requirements and solution review sessions involving Data platform implementation.
Equal Opportunity Employer Veterans/Disabled
* While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions.
Salary
75 - 78 /hour