Data Warehouse Developer

Job Details

Job Title: Data Warehouse Developer Full-time

Location: Austin, TX (Remote)

Duration: Long Term

Experience: 6-10 Years

We're searching for a skilled Data Warehouse Developer to design, develop, and maintain our data warehouse systems. You'll collaborate with data analysts, data scientists, and product managers to ensure the availability and accuracy of data for business insights.

Responsibilities

• Design, develop, and implement data warehouse solutions to support business intelligence and analytics.
• Create and maintain ETL (Extract, Transform, Load) processes to integrate data from various sources into the data warehouse.
• Optimize data warehouse performance through indexing, partitioning, and other techniques.
• Work closely with data analysts and product managers to understand data requirements and translate them into technical solutions.
• Ensure data quality, integrity, and security within the data warehouse.
• Write clean, maintainable, and well-documented code, adhering to best practices.
• Conduct code reviews and contribute to a collaborative development environment.
• Troubleshoot and debug complex technical issues related to data integration and warehousing.
• Stay up-to-date on the latest advancements in data warehousing and related technologies.

Qualifications

• 5+ years of experience as a Data Warehouse Developer.
• In-depth knowledge of data warehousing concepts, architecture, and methodologies.
• Experience with ETL tools (e.g., Informatica, Talend, SSIS) and data integration processes.
• Proficiency in SQL and experience with relational databases (e.g., SQL Server, Oracle, MySQL).
• Familiarity with data modeling, star schema, snowflake schema, and normalization techniques.
• Experience with BI tools (e.g., Tableau, Power BI) is a plus.
• Life/Accidental Death & Disability Provider: Guardian
• Proficiency in version control systems (Git) and familiarity with CI/CD pipelines.
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration skills.
• Experience with cloud data warehousing solutions (e.g., Amazon Redshift, Google BigQuery, Snowflake) is a plus.

Skills

• Design, Analytics, Data, Data quality, Debugging, Warehouse, Extract, transform, load, Informatica, Talend, Microsoft SSIS, Data integration, SQL, Relational databases, Microsoft SQL Server, Oracle, MySQL, Data modeling, Star schema, Normalization, Business intelligence, Tableau, Microsoft Power BI, Version control, Git, Continuous integration, Continuous delivery, Problem solving, Analytical skill, Communication, Collaboration, Cloud computing, Data warehouse, Amazon Redshift, Snow flake schema