Lumen Senior Marketing Database Analyst- SQL- Nationwide in Utah
Lumen is guided by our belief that humanity is at its best when technology advances the way we live and work. With 450,000 route fiber miles serving customers in more than 60 countries, we deliver the fastest, most secure global platform for applications and data to help businesses, government and communities deliver amazing experiences. Learn more about Lumen’s network, edge cloud, security and communication and collaboration solutions and our purpose to further human progress through technology at news.lumen.com, LinkedIn: /lumentechnologies, Twitter: @lumentechco, Facebook: /lumentechnologies, Instagram: @lumentechnologies and YouTube: /lumentechnologies.
Owns and manages the marketing database, including all its data, processes, and reporting. Maintains and improves the quality of the marketing dataset through the development of automated processes and managing manual cleansing processes. Manages the dataset, including matching fuzzy data from different sources against the existing marketing database, refreshing and renewing of segmentation, tiering, profiling, job functions, contact data and ensuring all scores and models remain up to date.
The Main Responsibilities
Manage a marketing database, including working with large data sets, segmentation, organisation, data cleansing, data planning, analytics, reporting, data governance and data management. Maintain and update data governance practices, including building automated and manual process using defined business rules, documentation and communication of updates to the wider marketing team, Corporate Strategy, the Finance team and the Network Access teams.
Produce, automate and maintain marketing specific reporting, processes and analysis. Builds processes and performs analysis producing and incorporating reports from multiple different departments and data sources.
Develop visual reports and Dashboards in SSRS or Tableau to meet user requirements. Using parameters, drill throughs, and email scheduling as appropriate. Conform to the department standards for look and feel of reports. Provide Ad-Hoc Data Analysis support for customers using SQL and excel as appropriate.
Regularly communicates with wider marketing team and aligns with the financial intelligence team and network access team, taking full ownership of developing policies, gathering requirements, and translating business requirements in order to build reports, interpret and present data, and providing ongoing support.
Responsible for maintaining quality reference data in Oracle by performing operations such as cleaning, transformation and ensuring Integrity in a relational environment.
Initiate a lot of fine tuning mechanisms to tune the database as well as the queries to complete a set of given jobs or tasks in optimal time.
Develope a central reference data system for the downstream applications.
What We Look For in a Candidate
Experience working as a marketing data analyst and managing a marketing database, including skills in handling company and contact datasets and data flows.
Experience in communicating clearly with non-technical customers.
Proven skills & experience in Salesforce.com.
Proven skills and experience with Microsoft SQL Server (which uses the T-SQL ANSI/SQL development standards) specifically DDL and DML statements, Linked servers, open query and dynamic queries. Python, R, Hadoop experience.
Experience with SSIS. Experience with SSRS, tableau or other reporting platform is desirable.
Experience with Oracle databases, using Essbase, fuzzy matching is desirable.
Requisition #: 233351
When applying for a position, you may be subject to a background screen (criminal records check, motor vehicle report, and/or drug screen), depending on the requirements for the position. Job-related concerns noted in the background screen may disqualify you from the new position or your current role. Background results will be evaluated on a case-by-case basis.
We are committed to providing equal employment opportunities to all persons regardless of race, color, ancestry, citizenship, national origin, religion, veteran status, disability, genetic characteristic or information, age, gender, sexual orientation, gender identity, marital status, family status, pregnancy, or other legally protected status (collectively, “protected statuses”). We do not tolerate unlawful discrimination in any employment decisions, including recruiting, hiring, compensation, promotion, benefits, discipline, termination, job assignments or training.
NOTE: Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.
The above job definition information has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job. Job duties and responsibilities are subject to change based on changing business needs and conditions.