Charlotte, NC, North Carolina
Sr. Data Warehouse Programmer Analyst
The successful candidate will be a part of the team that is responsible for Enterprise Data Warehouse. This position requires the candidate understands and applies technical standards, principles, theories, concepts, techniques and provides solutions to a variety of technical problems of moderate to high scope and complexity.
Skills Required:
• Bachelor’s Degree in Computer Science, Information Systems or similar
• 10 to 15 years of Data Warehousing and Data Modeling experience.
• Strong understanding of Normalized/Dimensional model disciplines and similar data warehousing techniques.
• Strong experience working with ETL/ELT concepts of data integration, consolidation, enrichment, and aggregation in large volume data sets.
• Expert in SQL and/or SQL-based languages and performance tuning of SQL queries.
• Working knowledge of Data Pipelines, stream processing and highly scalable ‘big data’ data stores.
• Experience with various data storage technologies – e.g. RDBMS (Oracle, SQL Server, etc.), columnar, tabular, document store, NoSQL
• Experience with various ETL/ ETL tools – e.g. ODI, SSIS, Informatica Power Center, Talend, IICS, etc.
• Experience with cloud-based data warehouses – e.g. Snowflake, BigQuery, Azure Synapse, RedShift, etc
• Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
• Collaborate with business users on normalizing and aggregating large data sets based on business needs and requirements.
• Data validation skills to verify data integrity, understand discrepancies, and resolve them with the highest sense of urgency.
• Demonstrated ability to share findings with non-technical or business stakeholders.
• Familiarity with Analytical/Reporting Solutions like Tableau, Power BI is a plus
• Virtual team collaboration tools such as WebEx, Zoom etc.
• Excellent written, verbal communication and Interpersonal skills
• Excellent problem solving skills
Experience & Education Required:
• Bachelor’s Degree in Computer Science, Information Systems or similar
• 7+ years of experience
• Strong understanding of Normalized/Dimensional model disciplines and similar data warehousing techniques.
• Strong experience working with ETL/ELT concepts of data integration, consolidation, enrichment, and aggregation in large volume data sets.
• Expert in SQL and/or SQL-based languages and performance tuning of SQL queries.
• Working knowledge of Data Pipelines, stream processing and highly scalable ‘big data’ data stores.
• Experience with various data storage technologies – e.g. RDBMS (Oracle, SQL Server, etc.), columnar, tabular, document store, NoSQL
• Experience with various ETL/ ETL tools – e.g. ODI, SSIS, Informatica Power Center, Talend, IICS, etc.
• Experience with cloud-based data warehouses – e.g. Snowflake, BigQuery, Azure Synapse, RedShift, etc
• Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
• Collaborate with business users on normalizing and aggregating large data sets based on business needs and requirements.
• Data validation skills to verify data integrity, understand discrepancies, and resolve them with the highest sense of urgency.
• Demonstrated ability to share findings with non-technical or business stakeholders.
• Familiarity with Analytical/Reporting Solutions like Tableau, Power BI is a plus
• Virtual team collaboration tools such as WebEx, Zoom etc.
• Excellent written, verbal communication and Interpersonal skills
• Excellent problem solving skills
Skills Preferred:
• Work individually and in a matrix environment • Work creatively and analytically in a problem-solving environment • Communicate (written and oral) effectively and demonstrate professional interpersonal skills • Interact professionally with clients and vendors • Build positive working relationships with employees at all levels within the organization • Meet deadlines as necessary • Effectively work with minimal supervision • “Can-do” attitude, pro-active and resourceful • Knowledge of CI/CD pipeline. • Experience with scripting languages – e.g. PowerShell, Python, etc |
Experience Preferred:
• 10 to 15 years of Data Warehousing and Data Modeling experience. |
Note: This position can be remote for the right candidate!