Data Transformation Developer

1 month ago


Sleepy Hollow, United States Visionet Systems Inc. Full time
  • The DBT Data Transformation Analyst/Developer will be responsible for designing, implementing, and maintaining data transformation processes using DBT (Data Build Tool).
  • This role requires a deep understanding of data modeling, ETL processes, and the ability to collaborate with various stakeholders to ensure the delivery of high-quality, reliable data for analytics and business intelligence.


Key Responsibilities:

  • Data Transformation Development:
  • Design, develop, and maintain data transformation pipelines using DBT.
  • Create and manage data models to transform raw data into structured datasets suitable for analysis and reporting.
  • Data Integration:
  • Collaborate with data engineers to integrate data from diverse sources into the data warehouse.
  • Ensure seamless data flow and consistency across different data sources.
  • Optimization and Performance:
  • Optimize DBT models for performance and efficiency.
  • Monitor and improve the performance of data transformation processes to ensure timely data availability.
  • Collaboration and Requirements Gathering:
  • Work closely with data analysts, data scientists, and business stakeholders to understand their data requirements.
  • Translate business requirements into technical specifications for data transformation.
  • Quality Assurance:
  • Implement automated testing and validation frameworks to ensure data accuracy and reliability.
  • Conduct thorough testing of data transformations and troubleshoot any issues that arise.
  • Documentation and Best Practices:
  • Document data transformation processes, data models, and workflows.
  • Develop and enforce best practices for DBT development and data transformation.
  • Continuous Improvement:
  • Stay updated with the latest advancements in DBT and data transformation technologies.
  • Continuously seek opportunities to improve and innovate data transformation processes.

Qualifications:

Education:

Bachelor's degree in Computer Science, Data Science, Information Systems, or a related field.


Experience:

Proven experience as a DBT Developer, Data Engineer, or similar role focusing on data transformation and modeling.

Experience working with modern data warehousing solutions (e.g., Snowflake, Redshift, BigQuery).


Technical Skills:

Proficiency in DBT and SQL.

Strong understanding of data modeling concepts and best practices.

Experience with version control systems (e.g., Git) and CI/CD pipelines.


Analytical Skills:

Strong analytical and problem-solving skills.

Ability to design efficient and scalable data transformation workflows.


Preferred Qualifications:

Experience with data visualization tools (e.g., Tableau, Looker).

Familiarity with cloud platforms (e.g., AWS, GCP, Azure).

Knowledge of Python or other scripting languages for data transformation.



  • Sleepy Hollow, United States Visionet Systems Inc. Full time

    The DBT Data Transformation Analyst/Developer will be responsible for designing, implementing, and maintaining data transformation processes using DBT (Data Build Tool).This role requires a deep understanding of data modeling, ETL processes, and the ability to collaborate with various stakeholders to ensure the delivery of high-quality, reliable data for...


  • Sleepy Hollow, United States Links Technology Solutions Full time

    We are looking for an experienced Senior Program Manager to spearhead a comprehensive business intelligence harmonization project for Links Technology Solutions. This crucial position will unify and enhance the organization's data analytics framework, promoting operational efficiency and enabling informed decision-making.Key Responsibilities:Visionary...


  • Sleepy Hollow, United States Links Technology Solutions Full time

    We are looking for an experienced Senior Program Manager to spearhead a comprehensive business intelligence harmonization project for Links Technology Solutions in the pharmaceutical sector. This crucial position will unify and enhance the organization's data analytics framework, promoting operational efficiency and facilitating informed decision-making.Key...

  • Data Architect

    1 week ago


    Sleepy Hollow, United States Visionet Systems Inc. Full time

    RESEARCH DOMAIN DATA ARCHITECT JD:This role for a pharmaceutical client expects a candidate with technical leadership background and strong experience in designing the Data model, data productsData Architecture Leadership:Spearhead the strategic development and continuous refinement of data architecture frameworks, leading the design and implementation...


  • Sleepy Hollow, United States Insight Global Full time

    Location: 2-3 days/week in Sleepy Hollow NY (1 day can be in Basking Ridge, NJ if needed)Duration: 6 month contract with extensionsMust Haves:10+ years’ experience as a Solutions Architect 3+ years of recent experience/knowledge within general and administrative functions, such as Finance, Procurement, HR, as well as compliance. Strong experience with...


  • Sleepy Hollow, United States Insight Global Full time

    Location: 2-3 days/week in Sleepy Hollow NY (1 day can be in Basking Ridge, NJ if needed)Duration: 6 month contract with extensionsMust Haves:10+ years’ experience as a Solutions Architect 3+ years of recent experience/knowledge within general and administrative functions, such as Finance, Procurement, HR, as well as compliance. Strong experience with...

  • Senior Data Architect

    2 months ago


    Sleepy Hollow, United States Visionet Systems Inc. Full time

    Position Name – Data Platform ArchitectLocation – NY (Sleepy Hollow) and Basking Ridge, NJ. Need to be onsite 3 days a weekIn this role, you will define the design and build scalable data platforms that support our organization's data needs. The Data Platform Architect will be responsible for developing robust data architecture, overseeing database...

  • Senior Data Architect

    2 months ago


    Sleepy Hollow, United States Visionet Systems Inc. Full time

    Position Name – Data Platform ArchitectLocation – NY (Sleepy Hollow) and Basking Ridge, NJ. Need to be onsite 3 days a weekIn this role, you will define the design and build scalable data platforms that support our organization's data needs. The Data Platform Architect will be responsible for developing robust data architecture, overseeing database...


  • Sleepy Hollow, United States Aroghia Group, LLC Full time

    Work closely with Clients C-level stakeholders, identifying and interpreting business needs andresponding with Analytics solutions.Serve as a trusted advisor to our clients, understanding their unique challenges, goals, andopportunities related to Data Engineering & Analytics.Develop and implement effective data strategies and governance frameworks for our...


  • Sleepy Hollow, United States Aroghia Group, LLC Full time

    Work closely with Clients C-level stakeholders, identifying and interpreting business needs andresponding with Analytics solutions.Serve as a trusted advisor to our clients, understanding their unique challenges, goals, andopportunities related to Data Engineering & Analytics.Develop and implement effective data strategies and governance frameworks for our...

  • Data Architect

    1 week ago


    Sleepy Hollow, United States Visionet Systems Inc. Full time

    CLINICAL DOMAIN DATA ARCHITECT JD:This role for a pharmaceutical client expects a candidate with technical leadership background and strong experience in designing the Data model, data products.Core responsibilities include:Establishing a data architecture framework. Data architects determine the standards and principles that an organization’s framework...

  • Data Architect

    1 week ago


    Sleepy Hollow, United States Visionet Systems Inc. Full time

    CLINICAL DOMAIN DATA ARCHITECT JD:This role for a pharmaceutical client expects a candidate with technical leadership background and strong experience in designing the Data model, data products.Core responsibilities include:Establishing a data architecture framework. Data architects determine the standards and principles that an organization’s framework...

  • Sr Program Manager

    3 weeks ago


    Sleepy Hollow, United States Links Technology Solutions Full time

    Our client in the Pharma industry is seeking a seasoned Senior Program Manager to lead their critical BI harmonization project. This role is pivotal in consolidating and transforming their business intelligence tools, driving efficiency, and enhancing data-driven decision-making across the organization.Responsibilities:Oversee BI Harmonization Project:...


  • Sleepy Hollow, United States Diverse Lynx Full time

    Job Title: Business Intelligence Solutions Architect Location: Sleepy Hollow, NY - Onsite Duration: Full Time-Only Job Overview Technical/Functional Expertise Proficiency in Tableau Development and Administration, Data Modeling Experience Required Extensive experience and comprehensive understanding of business intelligence tools and frameworks,...

  • Sr Program Manager

    3 weeks ago


    Sleepy Hollow, United States Links Technology Solutions Full time

    We are seeking a seasoned Senior Program Manager to lead an enterprise-wide BI harmonization initiative for our client in the Pharma industry. This pivotal role will consolidate and transform the company's business intelligence ecosystem, driving efficiency and empowering data-driven decision-making.Key Responsibilities:Strategic Leadership: Provide...

  • Sr Program Manager

    3 weeks ago


    Sleepy Hollow, United States Links Technology Solutions Full time

    We are seeking a seasoned Senior Program Manager to lead an enterprise-wide BI harmonization initiative for our client in the Pharma industry. This pivotal role will consolidate and transform the company's business intelligence ecosystem, driving efficiency and empowering data-driven decision-making.Key Responsibilities:Strategic Leadership: Provide...

  • Solutions Architect

    2 months ago


    Sleepy Hollow, United States Atlas Full time

    We are seeking a Solution Architect - Digital Innovation Lead to support our top biopharmaceutical client. This role is positioned to be a pivotal role in their digital transformation endeavor. This role will lead the charge in exploring cutting-edge technologies, investment in alliance to co-create and design solution tailored to drive the next wave of...


  • Sleepy Hollow, United States Links Technology Solutions Full time

    Links Technology Solutions is looking for an experienced Senior Program Manager to spearhead a vital business intelligence harmonization initiative. This position is crucial for unifying and enhancing the organization’s data analytics tools, promoting operational efficiency, and facilitating informed decision-making across various departments.Key...


  • Sleepy Hollow, United States Atlas Full time

    Requirements: .At least 10 years of demonstrated experience collaborating with business or customer communities driving innovation, evaluating and practicing data, AI and digital technologies.A proven track-record of prior innovation solutioning experience with digital technologies.Strong experience in agile development.Ability to effectively communicate and...


  • Sleepy Hollow, United States Atlas Full time

    Requirements: .At least 10 years of demonstrated experience collaborating with business or customer communities driving innovation, evaluating and practicing data, AI and digital technologies.A proven track-record of prior innovation solutioning experience with digital technologies.Strong experience in agile development.Ability to effectively communicate and...