| Database OR SQL Developer at mountainview CA at Remote, Remote, USA |
| Email: [email protected] |
| From: Shivani Sharma, Abidi Solutions [email protected] Reply to: [email protected] HI, greetings, please share some resume on below role: Title: Database Developer / SQL Developer ( Should have exp with python too) Location: Mountainview, CA ( Local Will be preffered ) ONLY independenet Candidates. JD: Requirement Details Short Description: Responsible for leveraging dbt to transform, model, and manage data within our organization's data analytics stack. Streamline data workflows, ensure data accuracy, and provide a structured foundation for data analysis and reporting. Complete Description: Note: This is a Hybrid position - 3 Days On-Site, 2 Days Remote. A dbt (data build tool) Developer is responsible for leveraging dbt to transform, model, and manage data within an organization's data analytics stack. dbt Developers play a crucial role in streamlining data workflows, ensuring data accuracy, and providing a structured foundation for data analysis and reporting. Responsibilities 1. Data Transformation and Modeling - Design and implement data transformations and models using dbt to create structured, cleaned, and aggregated datasets. - Develop and maintain dbt models that accurately represent business logic and data requirements. 2. SQL Expertise - Write and optimize SQL queries within dbt to extract, manipulate, and join data from various sources (e.g., databases, APIs, flat files). - Ensure SQL code follows best practices for readability, performance, and maintainability. 3. Version Control - Use version control systems (e.g., Git) to manage dbt codebase, enabling collaborative development and tracking changes over time. - Collaborate with data engineers and analysts to coordinate code changes. 4. Testing and Documentation - Implement unit tests within dbt to verify the accuracy and reliability of data transformations. - Document dbt models, data lineage, and transformations to facilitate understanding and collaboration. 5. Automation - Schedule and automate dbt runs to keep data models up-to-date and synchronized with source systems. - Implement data orchestration and scheduling as needed. 6. Data Quality Assurance - Develop and enforce data quality checks and validations within dbt to identify and rectify data issues. - Monitor data quality and integrity, responding to anomalies or discrepancies. 7. Performance Optimization - Optimize dbt models and queries for performance, identifying and addressing bottlenecks. - Analyze and fine-tune data processing pipelines to meet performance requirements. 8. Collaboration - Collaborate closely with data engineers, data analysts, and business stakeholders to understand data requirements and deliver data solutions. - Participate in cross-functional teams and contribute to data-related projects. 9. Security and Compliance - Ensure data security and compliance with relevant data protection regulations (e.g., GDPR, HIPAA) through appropriate data handling practices. 10. Knowledge Sharing - Share knowledge of dbt best practices and data modeling techniques with team members. - Provide training and support to data analysts and other users of dbt. Qualifications - Bachelor's or master's degree in computer science, data science, or a related field. - Strong proficiency in SQL and experience working with relational databases. - 3+ years of experience using dbt for data transformation and modeling in a data warehouse environment (e.g., Snowflake, BigQuery, Redshift). - 7+ years of experience building business rules using a business rules engine similar to dbt - Familiarity with version control systems (e.g., Git) and code collaboration workflows. - Excellent data analysis and problem-solving skills. - Strong attention to detail and a commitment to data quality. - Understanding of data warehousing concepts and best practices. - Knowledge of data governance and data security principles. - Effective communication and collaboration skills to work with diverse teams. - Experience with other data tools and languages (e.g., Python, R, Looker) is a plus. SHIVANI SHARMA Technical Recruiter Tel: (240) 891-2892 Office: (240) 240-9200 Ext (121) Email: [email protected] Web: www.abidisolutions.com Keywords: rlang California |
| [email protected] View all |
| Fri Jan 05 20:36:00 UTC 2024 |