Data Warehouse Programming Specialist jobs in Pennsylvania

Description

Job Summary:

Responsible for designing, implementing, and maintaining our organization's data warehouse infrastructure. This role requires a deep understanding of data modeling, ETL processes, and data integration, along with excellent problem-solving skills.

Responsibilities:

• Data Warehouse Design and Architecture:
  • Collaborate with stakeholders to understand business requirements and translate them into effective data warehouse solutions
  • Design, implement, and maintain data warehouse structures that support efficient storage and retrieval of data.
• ETL Development:
  • Develop and optimize Extract, Transform, Load (ETL) processes to ensure timely and accurate data integration.
  • Create and maintain ETL pipelines for data extraction from source systems to the data warehouse.
• Data Modeling:
  • Design and implement data models to support business reporting and analytics needs
  • Ensure data models align with business objectives and best practices.
• Performance Tuning:
  • Monitor and optimize the performance of the data warehouse to ensure efficient query processing.
  • Identify and resolve performance bottlenecks in collaboration with the IT team.
• Data Quality Management:
  • Implement data quality checks and processes to maintain the accuracy and consistency of data in the warehouse.
  • Work with data stewards to resolve data quality issues.
• Collaboration and Documentation:
  • Collaborate with cross-functional teams, including data scientists, analysts, and business users.
  • Document data warehouse processes, data lineage, and metadata.
• Security and Compliance:
  • Implement and enforce security measures to protect sensitive data within the data warehouse.
  • Ensure compliance with relevant data privacy regulations and policies.

Qualifications

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or related field.
• Proven experience (5 years) working as a Data Warehouse Specialist or in a similar role.
• Strong proficiency in data modeling, ETL development, and database management.
• Expertise in using data warehouse platforms such as (mention specific platforms, e.g., Snowflake, Amazon Redshift, etc.).
• Proficient in SQL and scripting languages (Python, Shell).
• Familiarity with data governance and data quality management principles.
• Excellent analytical and problem-solving skills.
• Strong communication and collaboration skills.

Preferred Skills:

• Certification in relevant data warehouse technologies.
• Experience with cloud-based data warehouse solutions.
• Knowledge of big data technologies (Hadoop, Spark).
• Familiarity with data visualization tools (e.g., Tableau, Power BI).