Role:Senior Data Architect

Location:La Mirada, CA

About the job:

• The Senior Data Integrations Developer in this role will be responsible for the design, development, testing, execution, and quality assurance of key technical data integration, data transformation and data quality processes, using Microsoft SQL Server & SSIS as the primary tool.
• This role will provide data consistency across databases, systems, and data platforms, employing both batch methods and real-time integrations.
• This position will work closely with the Manager of BI & Data Integrations to maintain data repositories and to develop secure and efficient processes for input, output, and synchronization of data among the disparate and distributed applications and systems.
• The individual will act as a subject matter expert for the data architecture, frameworks, tools/technologies suite, and data analytics needed to deliver timely, relevant, and actionable business integrations.

• Architect, build and launch new data models that provide intuitive analytics to your customers.
• Determine the desired architecture from data source to integration, distribution, and analysis for all business data domains Marketing, Finance, Sales, Logistics, Support, etc.
• Design, build and launch extremely efficient & reliable data pipelines to move data (both large and small amounts) from our Data Warehouse/Retail Systems into downstream databases and data marts for analysis.
• Design and develop new systems and tools to enable end-users to consume and understand data faster.
• Work across multiple teams in high visibility roles and own the solution end-to-end.Organize, and mine massive data sets of both structured and unstructured data by implementing appropriate infrastructure tools and systems to house data for reporting and analytics purposes.
• Define, implement, maintain, enhance, and optimize the business metrics data layer for scalability and reliability.
• Develop and translate algorithms (graph theory, Map/Reduce, recursion, and other areas) into working prototype code.
• Develop strategies to extract, resolve, and unify information of various types from numerous disparate data sources and integrate cohesively with external business applications.
• Create algorithms and heuristics to extract information from large data sets and implement the algorithms in software/scripts.Identify trends in large data sets and validate expected and unexpected trends in the data to assist in identifying solutions to resolve the unexpected.
• Be (or rapidly become) a thought-leader in the area of analytics/data science with respect to entity resolution as it pertains to business goals.

• 5+ years of diverse experience in designing innovative data solutions for business analytics, beyond basic ETL and Warehousing using SSIS, Microsoft SQL Server.
• Proven experience in managing workflows from architecture to delivery in an Agile framework.
• 3+ years of experience working with ESB integration solutionsBroad knowledge of different database technologies beyond RDBMS.
• Broad knowledge of vendor/solution capabilities in data management and reporting/analytics data federation, big data, data quality, Business Intelligence etc.
• Experience with a variety of Business Intelligence and dashboarding/reporting tools, including Tableau, Alteryx, etc.Broad knowledge writing complex SQL queries in a data warehouse environment.
• Desire to explore data in an unstructured environment and discover meaningful trends.Creative, curious and fascinated by data and the trends they reveal.
• Experience dealing with large, scalable, or high performance data systems.
• Experience with .NET/C# frameworkExpert coding skills across several languages including SQL, Python, Java, JavaScript and PHP.
• Exercise independent judgment and demonstrate technical proficiency in developing methods, techniques and evaluation criteria.
• Excellent oral and written communication skills and an ability to translate complicated technical issues for a non-technical audience.

• XML
  
• TFS
  
• Dynamics AX 2012
  
• Dynamics CRM
  
• Optimine
  
• Amazon AWS
  
• Tellium