IT Data Specialist in Falmouth, Massachusetts | DiversityInc Careers

IT Data Specialist

Job Description

About This Role

We need someone to provide technical leadership covering a range of data analysis functions. These include data modeling, structured query language (SQL), data quality, data profiling, extract-transform-load (ETL), metadata enrichment and management, data provenance and lineage, report design and other specialized data management functions. You're a solid, independent, senior lead equipped to manage and direct activities related to analysis, design and support of technical data management solutions for larger projects.

Meaningful work is fueled by meaningful performance and career development conversations with your manager. Here are the essential job functions of this position:

  • Elicit, analyze, interpret business and data requirements to develop complete business solutions, includes data models (entity relationship diagrams, dimensional data models), ETL and business rules, data management, governance, lineage, metadata and reporting elements.
  • Apply automation and innovation on new and on-going data platforms for those development projects aligned to business or organizational strategies.
  • Design, implement reporting platforms (e.g. modeling, ETL, BI framework) and complex ETL frameworks that meet business requirements. Work with technology/project teams to understand the business meaning of data, provide analysis and requirements so that data design is fully understood and the development initiatives are in line with intended design and standards.
  • Deliver business or enterprise data deliverables (that adhere to enterprise frameworks) for various platforms/servers/applications/systems.
  • Provide data analysis and requirements within enterprise platform (e.g. Hadoop).
  • Implement processes aligned to data management standards, ensure data quality and requirements are embedded in/adhered to within system development deliverables.
  • Develop, maintain knowledge of data available from upstream sources and data within various platforms.
  • Perform data profiling using TD tooling and ad hoc system query languages to validate data analysis.
  • Help development and testing teams resolve data issues.
Other duties as assigned
• Driving Requirements:
• Travel Requirements:
Job Requirements

What can you bring to TD? Share your credentials, but your relevant experience and knowledge can be just as likely to get our attention. Here are the minimum requirements for this position:

  • Undergraduate Degree or Technical Certificate.
  • 7+ years relevant experience.
  • Subject matter expertise on business processes and procedures, as well as broader organizational issues and technology.
  • Advanced knowledge of business, standards, infrastructure, architecture and technology in related areas from a design/ support/ solutions perspective.
  • Consult as an expert in multiple areas and consult with clients and project teams with respect to research, analysis, design, hardware/software support, solutions development, serve as a key resource for technical information exchange within project teams, with the business and outside vendors.
  • Capacity and eagerness to work independently as a senior/lead role on diverse tasks, and also coach/educate/guide/direct others.
  • Ability to direct activities related to analysis, design and support of technical data management solutions on larger projects that are highly complex and multi-faceted.
  • Must be eligible for employment under regulatory standards applicable to the position.
Preferred Qualifications - Here are the preferred qualifications for this role:

Job Requirements:

• Seven (7) or more years relevant experience in a BI environment
• Hands on experience with statistical programming software such as SAS, and reporting tools such as Business Objects and Tableau
• Support and evolve current reporting practices to ensure customer satisfaction and SLA achievement
• Grow team expertise to align with the Bank's enterprise integrated data and reporting platforms and tools (e.g. Business Objects, Tableau server, EDPP)
• Support a culture of continuous improvement, implement process improvements to enhance productivity, effectiveness and operational efficiency

Technical Knowledge/Skills:
• Expertise in using visualization tools such as Business Objects and Tableau
• Skills in designing high-quality dashboards and performance scorecards
• Knowledge of one or more data-focused programming languages such as SAS, SQL, Python, R as applied to processing data sets
• Expert skills with Excel, Access and PowerPoint
• Advanced skills in querying, joining, manipulating and summarizing datasets of various types
• Experience with Big Data environment and tools (HADOOP, Hive, Spark) is a plus.
• Web Analytics expertise using tools such as Adobe Analytics or Google Analytics is a plus.