ZipRecruiter

Log In

1

Data Analyst Python Sql Jobs in South Dennis, MA

Fidelity Cooperative Bank

Lead Data Engineer

Hyannis, MA · On-site

$121K - $145K/yr

Optimize Snowflake warehouse utilization and SQL queries for maximum performance and cost ... Strong proficiency in Python for data engineering, analytics, and data product development.

Cape Cod Five

Lead Data Engineer

Hyannis, MA

$99K - $139K/hr

Optimize Snowflake warehouse utilization and SQL queries for maximum performance and cost ... Strong proficiency in Python for data engineering, analytics, and data product development.

Mutual Bancorp

Lead Data Engineer

Hyannis, MA · On-site

$121K - $145K/yr

Optimize Snowflake warehouse utilization and SQL queries for maximum performance and cost ... Strong proficiency in Python for data engineering, analytics, and data product development.

Mutual Bancorp

Lead Data Engineer

Hyannis, MA · On-site

$121K - $145K/yr

Optimize Snowflake warehouse utilization and SQL queries for maximum performance and cost ... Strong proficiency in Python for data engineering, analytics, and data product development.

Rockland Trust

Data Architect

Plymouth, MA · Hybrid

$69.25 - $89.25/hr

Design scalable data structures to support analytics and reporting Data Governance, Security ... Work with technologies such as MS SQL Server, Oracle, Snowflake, and Azure data platforms * Stay ...

Rockland Trust

Data Architect

Plymouth, MA · Hybrid

$69.25 - $89.25/hr

Design scalable data structures to support analytics and reporting Data Governance, Security ... Work with technologies such as MS SQL Server, Oracle, Snowflake, and Azure data platforms * Stay ...

Rockland Trust

Data Architect

Plymouth, MA · On-site

$69.25 - $89.25/hr

Design scalable data structures to support analytics and reporting Data Governance, Security ... Work with technologies such as MS SQL Server, Oracle, Snowflake, and Azure data platforms * Stay ...

Whoi

Engineering CO-OP 2026 AOPE

Falmouth, MA · On-site

$27.50/hr

Projects may also include programming in C, C++, Python, Java or Matlab, data analysis using Excel, documenting results in MS Word or PowerPoint, as well as scripting and plotting in Matlab or Python.

Whoi

Research Associate III

Falmouth, MA · On-site

Conduct quantitative data analysis across projects using scripting languages (Python), including statistical modeling, signal processing, and geospatial analysis as appropriate * Take a lead role in ...

Whoi

Research Associate III

Falmouth, MA

Conduct quantitative data analysis across projects using scripting languages (Python), including statistical modeling, signal processing, and geospatial analysis as appropriate * Take a lead role in ...

next page

Showing results 1-20

All JobsData Analyst Python Sql JobsData Analyst Python Sql Jobs in South Dennis, MA

Data Analyst Python Sql information

See South Dennis, MA salary details

$36.4K

$88.6K

$145.8K

How much do data analyst python sql jobs pay per year?

As of Aug 28, 2026, the average yearly pay for data analyst python sql in South Dennis, MA is $88,570.00, according to ZipRecruiter salary data. Most workers in this role earn between $67,000.00 and $104,000.00 per year, depending on experience, location, and employer.

What is a data analyst Python SQL?

Data Analyst Python SQL jobs involve analyzing and interpreting data to help organizations make informed business decisions. These professionals use Python for data manipulation, automation, and visualization, and SQL for querying and managing data stored in relational databases. Typical tasks include data cleaning, building reports, extracting insights, and creating dashboards. Data Analysts often collaborate with other teams to understand data requirements and communicate findings through presentations or visualizations. Proficiency in both Python and SQL is essential for efficiently handling large data sets and solving complex analytical problems.

What are the key skills and qualifications needed to thrive as a data analyst with Python and SQL?

To thrive as a Data Analyst specializing in Python and SQL, you need strong analytical skills, statistical knowledge, and proficiency in data manipulation, typically supported by a relevant degree or certification. Expertise in Python for data analysis, SQL for database querying, and experience with visualization tools like Tableau or Power BI are commonly expected. Attention to detail, problem-solving abilities, and effective communication are crucial soft skills for interpreting data and presenting actionable insights. These skills help ensure accurate analysis, impactful reporting, and informed decision-making within organizations.

How does a data analyst using Python and SQL typically collaborate with other departments within an organization?

Data Analysts proficient in Python and SQL frequently work alongside teams such as marketing, product development, finance, and operations. They gather requirements from stakeholders, translate business questions into data queries, and present actionable insights through dashboards or reports. Regular meetings and clear communication are essential to ensure that data solutions align with business goals, and Data Analysts often act as a bridge between technical data teams and non-technical decision makers. This collaborative environment helps drive data-informed decisions across the organization.

What is the difference between Data Analyst Python Sql vs Data Scientist?

AspectData Analyst Python SqlData Scientist
Required SkillsExcel, SQL, Python basics, data visualizationAdvanced Python, machine learning, statistical modeling
Work EnvironmentBusiness intelligence, reporting, dashboardsPredictive modeling, research, complex data analysis
Industry UsageFinance, marketing, retail, healthcareTech, finance, research institutions, startups

While Data Analysts with Python and SQL focus on interpreting data, creating reports, and visualizations, Data Scientists build predictive models and perform advanced statistical analysis. Both roles require Python and SQL skills, but Data Scientists typically have a stronger background in statistics and machine learning, making their work more research-oriented.

What cities near South Dennis, MA are hiring for Data Analyst Python Sql jobs?

Cities near South Dennis, MA with the most Data Analyst Python Sql job openings:

Data Analyst Python Sql jobs near you

Lead Data Engineer

Fidelity Cooperative Bank

Hyannis, MA • On-site

$121K - $145K/yr

Full-time

Re-posted 29 days ago

Job description

Salary Grade: 21
SUMMARY:
The Data Engineer III will develop and scale our data ecosystem including our medallion architecture in Snowflake and our data integrations throughout the bank with the goal of building trusted semantic models that power enterprise reporting and self-service aligned with shared services across banks. This role will contribute to our evolving AI capabilities with a focus on ROI and time to insight and will partner closely with Finance stakeholders to turn complex financial data into reliable, decision-ready assets. This role is ideal for an engineer who understands the language of Finance, GL structures, net interest margin, regulatory reporting, budgeting and forecasting, and can translate those concepts into well-governed, high-performing data products in Snowflake for reporting, analytics, and self-service. This role will provide technical mentorship to Data Engineers I & II as they lead all aspects of technical delivery.
ESSENTIAL JOB FUNCTIONS & RESPONSIBILITIES:
  1. Architect & Design: Design and develop Snowflake-native data systems and architecture, including our medallion architecture. Supporting application ingestion, API connections, and advanced reporting needs across Finance, Risk, Lending, and Retail.
  2. Pipeline Engineering: Build ETL/ELT pipelines for incremental and initial data loads into Snowflake using tools such as Matillion, Snowpipe, Dbt, Tasks, and Dynamic Tables, along with external orchestration tools, integrating data from core banking, loan origination, GL, and third-party systems.
  3. Master Data & Governance: Define, build, and manage customer and customer product solutions by consolidating and mastering golden records with match & merge, survivorship, householding, and legal entity relationships. establish data governance models, and enforce data quality, lineage, and consistency across systems. Aligning customer data models and hierarchies to support regulatory, operational, and analytical use cases
  4. Semantic Layer: Lead the design, development, and implementation of our enterprise-level semantic layer, building models that serve as the single source of truth for all bank reporting.
  5. Performance Optimization: Optimize Snowflake warehouse utilization and SQL queries for maximum performance and cost efficiency and conduct performance tuning on reports and underlying data models.
  6. Stakeholder Partnership: Partner with Finance, FP&A, Accounting, Marketing, and other areas to translate business requirements into scalable data models and KPIs, writing advanced SQL for complex financial transformations, reconciliations, and performance-critical queries.
  7. Quality Control & Code Review: Conduct peer reviews, enforce data engineering standards, support CI/CD practices, improve documentation, and ensure data products meet agreed acceptance criteria before release.
  8. Troubleshooting: Resolve complex pipeline, integration, reconciliation, and deployment issues across the warehouse, integration, and reporting stack, coordinating with source system owners and infrastructure partners as needed.
  9. Observability: Implement monitoring, alerting, and data quality checks to ensure data timeliness, completeness, accuracy, and one version of the truth in destination systems.
  10. Governance & Standards: Establish and enforce best practices around data modeling, version control, CI/CD, and documentation, and collaborate with Information Security, Infrastructure, Digital, and Risk to ensure SOX, GLBA, and other regulatory requirements are met.
  11. Artificial intelligence: Support the bank's responsible, coordinated, and value-driven adoption of AI by helping establish the data foundations needed for analytical and AI use cases and supporting multiple Bank AI use cases at one time.
  12. Mentorship: Become a domain expert on our banking and financial services business and provide technical mentorship to other team members to foster a culture of continuous learning.

QUALIFICATIONS:
EDUCATION & CERTIFICATIONS:
  • Bachelor's degree in computer science, Information Systems, Finance, Accounting, Mathematics, or a related field.
  • Relevant certifications are a plus.

EXPERIENCE:
  • 10+ years of professional experience in data engineering, data analytics, or a closely related role.
  • Demonstrated background working with Finance data and stakeholders - general ledger, financial consolidations, budgeting and forecasting, or bank/financial services reporting. Experience supporting shared services across multiple entities.
  • Prior experience in banking, credit unions, or financial services, with exposure to core banking platforms and shared services across multiple entities.
  • Prior experience mentoring engineers and leading cross-functional data initiatives.

KNOWLEDGE, SKILLS & ABILITIES:
  • Expert-level proficiency in Snowflake, performance tuning, warehouse sizing, RBAC, Streams, Tasks, Snowflake Intelligence, Cortex, Dynamic Tables, integrated apps (Streamlit, others) and cost optimization.
  • Proven experience designing and implementing medallion architectures (Bronze/Silver/Gold) at enterprise scale.
  • Familiarity with Customer Master Data and Data Governance solutions and data with an ability to integrate that data across the bank's ecosystem for analytics, reporting, and self-service.
  • Advanced SQL skills with the ability to write, tune, review, and troubleshoot complex queries against large financial and operational datasets.
  • Expert-level data integration experience - building and maintaining pipelines from source systems (core banking, ERP, GL, flat files, APIs) into a cloud data warehouse.
  • Deep expertise building semantic layers and views using tools such as dbt, Snowflake, BigQuery, and Matillion with a strong grasp of metric definitions, governance, and reusability to support downstream use cases within Snowflake Cortex/Intelligence and BI/visualization tools such as Power BI or Streamlit.
  • Strong proficiency in Python for data engineering, analytics, and data product development. Experience building scalable data pipelines, performing advanced data transformations, and integrating with cloud data platforms such as Snowflake, Streamlit, BigQuery.
  • Familiarity with regulatory and financial reporting requirements such as Call Reports, SOX, CCPA, or CECL.
  • Proficiency with version control (Git) and CI/CD workflows.
  • Excellent communication skills, with the ability to explain technical concepts to Finance and executive audiences.
  • Familiarity with Jira/Agile methodology for project and task management.
  • Deep hands-on experience of data warehousing, master data management, data catalog, and data governance tools.

COMPETENCIES:
  • Must have cyber security awareness to protect the digital environment, the Bank, and customers.
  • Excellent communication skills, with the ability to explain technical concepts to Finance and executive audiences.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.

Apply