Senior Data Analytics Developer

FHLB Des Moines; California (MO); On-site; USD 109,575 - 146,100; Full time

Benefits offered by this job

Medical

Dental

Vision

401(k) with company match

Vacation

Paid sick leave

HSA/FSA

Employee Assistance Program

Job summary

Living Spaces is seeking a Senior Data Analytics Developer to design, test, and maintain data integration, transformation, and quality processes. You will build data models and data pipelines, and enable analytics across Marketing, Finance, Sales, and Logistics.

You will work with SSIS, SQL, Python, Java, and cloud platforms (AWS/Azure) to connect external sources with internal systems, ensuring data security and integrity and driving scalable analytics across teams.

Qualifications

• Bachelor's degree in computer science or engineering or related field.
• 5+ years of diverse experience in designing innovative data solutions for business analytics.
• Experience in Agile delivery and managing workflows from architecture to delivery.
• Knowledge of BI, data federation, big data, data quality, and related technologies.
• Experience with BI/dashboarding tools such as Tableau and Alteryx.

Responsibilities

• Architect, build, and launch intuitive data models for stakeholders across Living Spaces.
• Design optimal data architecture for seamless integration, distribution, and analysis.
• Build high-performance data pipelines from Data Warehouse to downstream data marts.
• Develop, implement, and maintain complex integrations from external cloud sources.
• Use multiple cloud-based APIs to establish data connections securely.
• Collaborate across teams and own the solution end-to-end.
• Analyze massive structured and unstructured data to identify trends and insights.
• Develop and optimize the business metrics data layer for scalability and reliability.
• Translate algorithms into working prototype code and implement data extraction heuristics.
• Lead analytics/data science initiatives, including entity resolution for business goals.
• Explore unstructured data to discover meaningful business value.

Skills

SQL

Python

Java

JavaScript

.NET/C#

Education

Bachelor's degree in CS/Engineering

5+ years experience in data analytics

Tools

SSIS

Tableau

Alteryx

AWS

Azure

Job description

Position SummaryThe Senior Data Analytics Developer will play a crucial role in ensuring relevant, timely, and actionable business integrations for Living Spaces. They will take charge of designing, testing, and maintaining data integration, data transformation, and data quality processes while maximizing efficient use of Living Spaces data across teams and platforms.Position DescriptionEssential Duties and Responsibilities include the following. Other duties may be assigned.Architect, build, and launch intuitive data models that provide actionable insights for stakeholders across Living Spaces.Determine the optimal data architecture to ensure seamless data integration, distribution, and analysis for Living Spaces’ business data domains, including Marketing, Finance, Sales, Logistics, Support, and more.Build highly efficient and reliable data pipelines to move large and small data amounts from Living Spaces’ Data Warehouse/Retail Systems to downstream databases and data marts for analysis.Develop, implement, and maintain complex integrations from external cloud sources to internal systems using a variety of tools and platforms.Use multiple cloud-based API’s to establish data connections and ensure their security and integrity.Work across multiple teams in high visibility roles and own the solution end-to-end.Organize, mine, and analyze massive structured and unstructured data sets to identify trends, patterns, and insights that assist in making critical decisions for Living Spaces.Develop and optimize the business metrics data layer for scalability, reliability, and resilience.Translate algorithms (graph theory, Map/Reduce, recursion, and other areas) into working prototype code effectively and efficiently.Develop strategies to extract, resolve, and unify information from various disparate data sources to ensure cohesive integration with external business applications.Create algorithms and heuristics to extract information from large data sets and implement the resulting algorithms in software/scripts.Be a thought – leader in analytics/data science with respect to entity resolution as it pertains to Living Spaces business goals.Explore data in an unstructured environment and discover meaningful trends that drive business value for Living Spaces.Use SQL Server Integration Services (SSIS) to build high-performance data integration solutions, including extraction, transformation, and loading (ETL) packages for data warehousing.QualificationsEducation/Experience: The ideal candidate for this position should have a Bachelor's degree (B. A. or B. S.) in computer science or engineering or related field, along with 5+ years of diverse experience in designing innovative data solutions for business analytics. They should also have proven experience in managing workflows from architecture to delivery in an Agile framework. Additional knowledge of different database technologies beyond RDBMS, vendor/solution capabilities in data management and reporting/analytics – data federation, big data, data quality, Business Intelligence, etc., and writing complex SQL queries in a data warehouse environment. They should also have experience BI and dashboarding/reporting tools, including Tableau, Alteryx, etc. The equivalent combination of education and experience will also be considered.Computer Skills: The candidate must have advanced proficiency in expert coding skills across several languages and cutting-edge technologies, including SQL, Python, Java, JavaScript, PHP, and .NET/C# framework. Being knowledgeable in XML, Dynamics AX 2012, Dynamics CRM, Amazon AWS, Microsoft Azure, Microsoft Data Lake and Data Warehouse migration skills will be a plus.Position Hiring RangeThe hiring pay range provides a good faith estimate of the salary or hourly wage that Living Spaces expects to pay for the position upon hire. Pay will be determined by several factors, including, but not limited to: applicant's education, relevant work experience, knowledge, applicable and relevant skills and abilities, market demand, Company budget, as well as internal equity and alignment with geographic market data. Living Spaces reserves the right to modify this page at any time.Compensation: $109,575.00 - $146,100.00Overtime pay is available for eligible, non-exempt Team Members. Reimbursement for expenses as required by applicable law and Company policy. Retail, Guest Services and Distribution Center Team Members are eligible to receive team bonus based on meeting specific goals and KPI's.Additional available benefits upon meeting eligibility requirements include:Medical (full-time only)Dental (full-time only)Vision (full-time only)401(k) with Company match (full and part-time)Vacation (full-time only or as otherwise required by applicable law)Paid Sick Leave (full and part-time)Flex or Health Spending Account (for eligible full-time only)Employee Assistance Program (full and part-time)Holiday pay (full-time only)Life insurance (full-time only)For more details, please visit our website at: Careers (livingspaces.com)Equal Opportunity EmployerIt is our policy to abide by all federal, state, and local laws prohibiting employment discrimination based solely on a person’s race, color, religious creed, sex, national origin, ancestry, citizenship status, pregnancy, physical disability, mental disability, age, military status, or status as a Vietnam-era or special disabled veteran, marital status, registered domestic partner or civil union status, gender (including sex stereotyping and gender identity or expression), medical condition (including but not limited to, cancer related or HIV/AIDS related), sexual orientation, or any other protected status except where a reasonable, bona fide occupational qualification exists.E-VerifyLiving Spaces participates in E-Verify. All newly-hired team members are queried through this electronic system established by the Department of Homeland Security (DHS) and the Social Security Administration (SSA) to verify their identity and employment eligibility.Applicant Privacy