Sr. Data Modeller

Sligo Software Solutions Inc.; New York (NY); On-site; USD 140,000 - 190,000; Full time

Job summary

Sligo Software Solutions, Inc. in New York, NY is seeking a Sr. Data Modeller with Financial Experience for a 30-month engagement with NY State - Department of Financial Services. The role focuses on building data workflows, validating financial data, and enabling data governance.

You will translate complex business requirements into technical specifications, develop data warehousing pipelines using SQL and cloud tools, and automate reporting with Python, VBA, or R.

Qualifications

• 15+ years of experience in IT data platforms and governance.
• Expert in data warehousing, profiling, governance, and data quality for financial reporting.
• Proficient in SQL, Oracle, and data visualization tools.
• Experience with cloud data platforms (Snowflake or Azure).
• Bachelor's degree required; copy of identification documents.

Responsibilities

• Translate business requirements into technical data pipelines and workflows.
• Build and maintain data warehousing workflows and pipelines.
• Analyze and validate data using statistical methods and model calculations.
• Define technical requirements from business needs to guide implementations.
• Perform data profiling, exception reporting, and metadata lineage management.
• Automate ingestion and reporting using Python/VBA/R.

Skills

SQL

Python

R

VBA

Data Governance

Data Modeling

Data Warehousing

Data Visualization

Education

Bachelor's Degree

Tools

Tableau

Power BI

Oracle

Snowflake

Azure

Informatica

Collibra

Job description

Greetings from Sligo Software Solutions, Inc. !!
SLIGO is a Software Development & IT Consulting company. We have around 100+ IT associates working with our esteemed clients across several domains such as IT, Banking, Healthcare, and Government.
We have an urgent requirement for Sr. Data Modeller with Financial Exp position with our client. Role: Sr. Data Modeller with Financial Exp Location: Nyc, New York Duration: 30 Months Job ID: HBITS-08-15019 Client: NY State - Department of Financial Services
Description
We are looking for a technical expert to build data workflows, validate financial data, and enforce data quality. You will actively engineer data solutions, automate manual reporting, and query datasets to support Data Governance and business stakeholders.
Duties

• Translate complex business requirements from data stakeholders into technical specifications for data pipelines and automated workflows.
• Build and maintain data warehousing workflows and data pipelines using SQL and cloud database tools.
• Compile, compute, analyze and validate data using advanced statistical formulas and model calculations.
• Elaborate high-level policies and business needs into technical requirements (user stories/system use cases) to guide platform implementation.
• Execute data profiling, build exception reports, and manage metadata/lineage using data platforms.
• Use programming language (Python/VBA/R) to automate data ingestion and reporting processes.
  

Mandatory Requirements

• Experience (15+ Years)
• Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer.
  

Requirements

• This is an 100% Onsite.
• 84 Months experience in Data warehousing, profiling, governance, modeling or data quality assurance for Financial Reporting.
• 84 Months of Experience in SQL, Oracle and other Database Management Systems, including querying. Provide example(s) of independently problem solving and support to internal data stakeholders that resolved data issues in real time.
• 84 Months of Experience with data visualization, dashboarding, using tools like Tableau, Business Objects, Power BI.
• 84 Months of Experience in automating data tasks like ingestion, mapping, reporting, testing, validation, analysis, using programming languages such as SAS, Python, R, or Excel VBA.
• 84 Months of Experience in providing governance, and technical support. Liaise with data vendors/solution providers, internal stakeholders, other technology teams (Data Architecture, Project Management team) to support data strategy and initiatives. Translate business requirements into technical specifications.
• 84 Months of Experience with Data Cataloging Platforms (e.g., Informatica, Collibra, Alation) to execute data profiling, data quality, data mapping and manage lineage.
• 84 Months of experience in writing documentation to capture requirements and logic, and encourage adoption of data catalog, data quality and data management processes and other data related initiatives (i.e., data platform/integration solutions).
• 36 Months of Experience in cloud based data platforms, like Snowflake or Azure.
• Bachelor's Degree
• R sum
• Copy of Candidate Identification(i.e., Driver's License/Green Card/Visa and Passport if applicable)
• Any documents referenced in the above Requested Qualifications(i.e., professional certifications, degrees, etc.)