Data Warehouse Architect

Job content

Your responsibilities will include:

• You will work alongside the Project Management to ensure alignment of plans with what is being delivered.
• You will utilize your configuration management and software release experience; as well as change management concepts to drive the success of the projects.
• You will partner with senior leaders to understand and communicate the business needs to translate them into IT requirements. Consult with Customer’s Business Analysts on their Data warehouse requirements
• You will assist the technical team in identification and resolution of Data Quality issues.
• You will manage small to medium-sized projects relating to the delivery of applications or application changes.
• You will use Managed Services or 3rd party resources to meet application support requirements.
• You will interface daily with multi-functional team members within the EDW team and across the enterprise to resolve issues.
• Recommend and advocate different approaches and designs to the requirements
• Write technical design docs
• Execute Data modelling
• Solution inputs for the presentation layer
• You will craft and generate summary, statistical, and presentation reports; as well as provide reporting and metrics for strategic initiatives.
• Performs miscellaneous job-related duties as assigned

Business Intelligence and Analytics

• Partners with team members and business leaders to formulate BI technology strategy
• Builds the strategy, designs frameworks and guides implementation
• Provides direction related to creation of next generation reporting and analytics platform (traditional data warehouse and big data technologies)
• Helps business partners develop strategies that maximize the value of data

Master Data Management

• Provides senior level technical consulting to application and data development teams during data modeling, application design and development for highly complex or critical projects
• Leads the organization’s review of MDM tools and techniques to improve data management for the enterprise
• Develops MDM policies and procedures, ensuring that they are accurately documented and meet compliance requirements
• Collaborates with IT to ensure master data processes are aligned with enterprise business needs and evolving changes and implemented appropriately

Required Qualifications

• 6+ years experience in Data Warehousing including the following:
• 2+ years of hands on ETL (i.e, Informatica/Data Stage) experience
• 2+ years of hands on Big Data Experience (Hadoop, Spark, Hive)
• 2+ Unix/Linux scripting experience
• 4+ years Database experience in SQL Server/ Oracle/ MySQL/Postgres SQL
• 6+ years experience working in a cross-functional environment
• 6+ years of Teradata experience or related Appliance, PowerBI, Tabular Data Models

Preferred Qualifications

• Strong interpersonal, teamwork, organizational and workload planning skills
• Strong analytical, evaluative, and problem-solving abilities as well as exceptional customer service orientation
• Ability to drive clarity of purpose and goals during release and planning activities
• Excellent organizational skills including ability to prioritize tasks efficiently with high level of attention to detail
• Excited by the opportunity to continually improve processes within a large company
• Healthcare background/ Automobile background.
• Familiarity with major big data solutions and products available in the market.
• Proven ability to drive continuous improvements in organizational performance, efficiency and
• innovation for customers.

Education

• Bachelors in Computer Science or equivalent required