BUSINESS DATA ANALYST - STRONG WITH TERADATA -THIS IS A 70 PERCENT DATA ANALYST COUPLED WITH 30 PERCENT BUSINESS ANALYSIS
Position Summary:
The Sr. Business & Data Analyst will contribute to the ongoing development, maintenance, and enhancement of the Enterprise Marketing Database, providing overall business knowledge to projects and support. This position will be assigned to many projects within the Enterprise Marketing Management group. This position collaborates with company customers, staff members, IT colleagues, and other stakeholders to define detailed customer requirements and system interfaces, assess available technologies, and develop and present solutions. The Sr. Business & Data Analyst acts as an internal consultant, providing business process expertise and technical guidance on the most complex projects or researching strategic planning matters.
Responsibilities:
- Produce functional requirements and solution end-to-end database development in an Enterprise Data Office (EDO) environment supporting SiriusXM's Enterprise Marketing Management solution.
- Document processes and mentor staff through the software development lifecycle process.
- Lead, collect and analyze business requirements for large, multifunctional projects.
- Participate with other IT members, customers, and other stakeholders in new product reviews, tests, and pilots.
- Perform feasibility studies, translate requirements into an appropriate design.
- Identify conflicting business practices and integration issues, suggesting alternative solutions.
- Foster and maintain good relationships with customers and IT colleagues to meet expected customer service levels.
- Document processes and mentor development staff through the software development lifecycle process.
- Work with EDO Architecture and Innovations group to craft solutions for data integration and business layer.
- Analyze new data sources for integration into SiriusXM's Marketing Database -- structured/semi-structured and unstructured data from various sources in support of the electronic marketing management tools and other related systems.
- Work with Operations Tier I and Tier II teams to ensure control objectives are implemented for all data movement processes, implement change control for production data, establish and follow proper incident management procedures.
- Ensure compliance with all applicable data privacy regulations and policies related to firm and client/contact data.
Minimum Qualifications:
- Overall experience of 10 years with atleast 7 to 8 years of with writing functional requirements, data warehouse experience required.
- Bachelor/Associate degree in computer science, information systems, or related course of study or equivalent, relevant experience.
Technical Skills:
- At least 2 to 4 years in writing SQL.
- At least 4 years of experience with Cloud (S3, Redshift, e.g.) or on-prem Database (Teradata, Oracle, SQL Server or similar database platform.
- Thorough knowledge of MS Office Suite (Word, Excel, PowerPoint).
- Experience implementing best practices for EDW development.
- Thorough knowledge of MS Office Suite (Word, Excel, PowerPoint, Access).