What are the responsibilities and job description for the Data Architect and Data Engineer openings position at Tech Pro Inc.?
Location: Houston, TX (hybrid) 3 days onsite regularly and 5 days onsite during go-live
seeking a hands-on Data Architect / Sr. Data Engineer with very strong expertise in SQL, Snowflake, and DBT to support a high-visibility financial analytics project. The role requires both architectural thinking and deep technical execution designing and coding data models, building pipelines, and optimizing performance in a collaborative, fast-paced environment.
Key Responsibilities
- Architect, design, and implement scalable data solutions leveraging Snowflake and DBT.
- Develop and optimize SQL queries, data models, and transformation pipelines.
- Collaborate with business stakeholders, analysts, and data scientists to translate requirements into efficient data solutions.
- Implement best practices for data governance, quality, security, and compliance.
- Monitor, troubleshoot, and enhance data pipelines for performance and reliability.
- Drive automation and CI/CD practices within the data engineering ecosystem.
- Provide technical leadership and mentorship to junior engineers where needed.
Required Skills & Experience
- 10 years of experience in data engineering or data architecture roles.
- Strong hands-on expertise with Snowflake (data modeling, performance optimization, security, and integration).
- Proficiency in DBT for transformation and workflow management.
- Advanced knowledge of SQL (query optimization, complex joins, window functions, CTEs).
- Experience in data pipeline orchestration and integration tools (e.g., Airflow, Prefect, or similar).
- Solid understanding of ETL/ELT design patterns, data warehousing concepts, and modern data architectures.
- Familiarity with cloud platforms (AWS, Azure, or Google Cloud Platform).
Nice to Have
- Previous experience working in the financial services domain (banking, insurance, capital markets, fintech).
- Exposure to data visualization or BI tools (Tableau, Power BI, Looker).
- Experience with version control, CI/CD, and DevOps practices for data.
- Strong problem-solving, analytical, and communication skills.
Resume direct to kumar @ techpro-inc . com with Subject: Applying from Dice (only this line)
OR
click on Apply now