Programmer Analyst - Data Warehouse

Remote position

Pay rate-$60-64/hr

Hours:9am-5pm

6-12 Month Contract to hire

Position Description:

The successful candidate will be part of the team responsible for the Enterprise Data Warehouse. This position requires understanding and applying technical standards, principles, theories, concepts, and techniques to provide solutions to a variety of technical problems of moderate to high scope and complexity. The candidate will develop

deep knowledge and understanding of the data warehouse and data management assets available within our data platforms and act as the subject matter expert on the data and its utility for operational use. Regular interaction with customers, data management teammates, and product development partners is expected.

Skills and Experience 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 datasets.
• Expertise 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.
• Ability to create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
• Collaboration with business users on normalizing and aggregating large datasets 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.
• Proficiency in virtual team collaboration tools such as WebEx, Zoom, etc.
• Excellent written, verbal communication, and interpersonal skills.
• Excellent problem-solving skills.

Skills and Experience Preferred:

• Ability to work individually and in a matrix environment.
• Ability to work creatively and analytically in a problem-solving environment.
• Effective communication (written and oral) and professional interpersonal skills.
• Professional interaction with clients and vendors.
• Building positive working relationships with employees at all levels within the organization.
• Meeting deadlines as necessary.
• Effectively working with minimal supervision.
• Maintaining a "Can-do" attitude, being proactive and resourceful.
• Knowledge of CI/CD pipeline.
• Experience with scripting languages, e.g., PowerShell, Python, etc.

EOE (including Disability/Veterans)