Data Architect Job Descriptions, Average Salary, Interview Questions

We are looking for a Data Architect who will play many important roles on our technology team. In this role, you will be responsible for integrating advertising platforms across clients and internal teams. We are looking for someone with excellent technical skills, a quick learner, and the ability to utilize tools and software to help our media, SEO, and analytics teams execute our marketing programs.

What you’ll do:

• Collaborates with the analytics team to set up, maintain, and QA data feeds into our reporting dashboards
• Helps troubleshoot data quality issues with the analytics team on an ongoing basis
• Participates in client discussions regarding the implementation and/or integration of CRM data into their media platforms (ie SalesForce integration into Google Analytics or SA360)
• Implements media pixels via tag management platforms on client’s website, via tagging SDR provided by the analytics team
• Participates in client conversations to troubleshoot relevant tagging implementation issues on their sites
• Provides data management support and consulting in support of ‘ad hoc’ client projects as needed

Who you are:

• A builder | Entrepreneurial attitude coupled with strong business acumen. Ability and appetite to bring people together. Innate ability to marshal people and create gravity around ideas
• Open and collaborative | Our team is close-knit and supportive and we’re working with a lot of unknowns – you must champion team environments that are comfortable and encouraging
• Optimistic and resilient | Dig in and figure out how to work around problems. Takes care of self and team. Balance is needed to maintain stamina and positivity
• Ego-less | We all wear the hats that need wearing, it’s a mentality that makes the team successful

What you’ll need:

• SQL experience
• Ability to participate in technical discussions
• Strong communication, both verbal and written
• Ability to adapt and maintain a positive and professional attitude under pressure and thrive in a fast-paced, deadline-oriented environment
• Ability to balance support of multiple clients at one time
• Organized, with the ability to follow through on issues and pay close attention to detail
• Google Tag Manager experience preferred, and/or experience with client-side JavaScript is a huge plus
• Preferred proficiency with a cloud-relevant programming language (Node.js, Python, Go, Java, .NET, Ruby or PHP)

We are looking for a passionate and seasoned leader and specialist to be responsible for Data Architect within client’s retail data and marketing landscape. The individual will own the task of designing and deploying product, consumer, and commerce services through standard access patterns. The candidate must be able to lead and guide engineering and integration teams on developing solutions that fully integrate and collaborate with existing IT systems to solve complex business solutions.

• Minimum of 7 years of hands-on experience in software development and a minimum of 3 years supporting application and systems architecture
• 5+ years of experience in data modeling (SQL) required
• 4+ or more years of experience with Tableau or Power BI
• 3+ years experience as a Data Architect

Required qualifications to be successful in this role

• Experience in Big Data Architecture, Data warehousing, and Database design & Development
• Information and Business Intelligence strategy engagement experience in banking domain
• Solution architecture experience in translating business needs and vision into roadmap, project deliverables, and organization strategy
• Experience in understanding Data & Process Modeling
• Good to have programming skills in Big data ecosystem like Apache Hadoop, Hive, MapReduce, Oozie, Kafka, and Spark
• Experience in Teradata/Oracle or any RDMS database environment
• Programming experience in Python, Java, or Scala Preferred
• Knowledge of data science, machine learning, and statistical modeling techniques
• Understanding of analytical techniques including segmentation, cluster analysis, and regression
• Excellent communication and thought leadership skill

The ideal candidate will have excellent client management and technical skills, will be able to take the technical ownership of their projects, and has experience delivering large scale DW and analytics projects.

Key responsibilities

• Work as part of a team, to design and develop cloud data solutions in Azure
• Must haves: Azure portal, Data Factory, Data Lake, Power Apps, Dataverse, Power BI Datasets, etc.
• Nice to haves: exposure to non-Azure technologies such as Dynamics 365 (CE, Projects), Sales Force, AWS, etc.
• Proven ability to deliver high quality work on time and with minimal supervision
• Skillful at listening, note taking, prioritizing and follow-ups while meeting customer expectations
• Responsible for client interactions (presentations, video/audio calls, emails, chats), technical design, documentation, and implementation of BI solutions
• Implement best practices for architectural design and data ingestions
• Create Architecture diagrams, review it with the customer, and execute the design implementation upon approval
• Strategic initiatives
• Follows directions and priorities and takes responsibility for execution
• Responsible for delivering internal strategic initiatives – including budget and resource planning, design, delivery, support roll off and status reporting
• Achieves quarterly revenue goals

Required qualifications, experience & skills

• Ability to manage ambiguity and solve undefined problems
• Ability to manage multiple projects and customers at any given time, and being able to make the switch seamlessly
• Knowledge of methodologies such as Kimble/Inmon is a must
• Extensive experience with Data Architecture, Database Design including Data Quality and Master Data Management (MDM) tools, processes, and governance
• Document business requirements and technical architecture/design while translating complex requirements and designs for development, testing, and implementation
• Ability to travel up to 20%