Skip to main content

SQL Server Engineer

Technology
Atlanta, United States1 week ago
Service contract

Job description

Looking for a SQL Server Engineer who has experience working in the marketing space and/or with marketing data. Hands on experience with Google Analytics is preferred but not required. Candidates who apply need to have a heavy SQL background and hands on involvement in creating tables and views to move existing data around in SQL.

In this role you will be working on a small, very collaborative team and will have the opportunity to grow within the organization. Hands on experience with Talend is required.

Responsibilities

  • Create simple but highly effective data solutions that increase the productivity of analysts to develop targeted audience segments
  • Design, implement, and operate SQL Server, SSAS and Snowflake data infrastructure to support marketing operations (segmentation, customer journey, analytics, and KPI reporting).
  • Implement data ingestion routines to curate data from internal sources (Insurance and Claims Systems), and external sources (Google Analytics, LisTrak for Email, Facebook Ads, Google Ads, Affiliates, etc.)
  • Play a key role in elevating data capabilities of the Marketing organization by creating actionable data sets for campaign analysts and business intelligence analysts.
  • Develop data solutions for email and digital campaign performance reporting.
  • Develop automation and repeatable processes to cleanse data and maintain data integrity
  • Collaborate within our overall data engineering team to ensure marketing data models are created following engineering best practices and governance standards.
Qualifications
  • Expert in data modeling, who is comfortable working with datasets of varying complexity, and size.
  • 3+ years of hands-on industry experience with data modeling and data analytics.
  • Experience in data ingestion and ETL/ELT processes preferably Talend and Stitch.
  • Extensive expertise with Microsoft SQL Server (2016+) and Transact-SQL.
  • SQL expertise with multi-stage transformations and usage of more sophisticated transformation tools and methods, such as windowing functions and temp tables in Transact-SQL.
  • Experience with marketing attribution related pipelines and reporting requirements.
  • Experience implementing business logic into models that successfully drive business value.
  • Excellent verbal and written skills to effectively communicate business concepts to partner analysts and teams.
  • A drive to learn the intricacies of the insurance business, with a versatile and dynamic understanding of businesses you've worked with in the past.

Required Skills : T-SQL (SQL Development) - Understanding Microsoft SQL, table creating, view creation, stored procedures - MUST SKILL Marketing (Google Analytics ideally) - knows general things about marketing ETL - Talend experience (be a backup with Talend, does not have experience with) - TALEND IS A MUST SSAS - SQL Server Analysis Services - MUST SKILL Must have excellent communication skills

Basic Qualification :

Additional Skills : 100% remote Exclusive!!

Background Check :Yes

Drug Screen :Yes

Notes :This position IS contract to hire so candidates must be able to go full time 100% remote Exclusive!! Manager only wants to see people in the eastern or central time zone!

Selling points for candidate :100% remote Exclusive!!

Project Verification Info

Exclusive to Apex :No

Face to face interview required :No

Candidate must be local :No

Candidate must be authorized to work without sponsorship :Yes

Interview times set : :No

Type of project :Development/Engineering

Master Job Title :Engineer: Other (Non-IT/Non-Telecom)

Branch Code :Atlanta

Interested in this role?